Oracle Database Cloud Service 2021 Specialist (1z0-998-21) Free Practice Test

Question 1

Which three are true about Transparent Data Encryption (TDE)?

A. dbcli update_tdekey command is used to update the master encryption key for a PDB.

B. TDE stores the master key outside the database in an external security module.

C. TDE allows you to encrypt sensitive data in individual columns.

D. Set encrypt new table spaces parameter to false to stop encrypting the tablespaces.

E. TDE overrides access controls configured using Oracle Database Vault.

F. When the TDE master encryption key is reset, backups taken using the old TDE master encryption key become obsolete.

Correct Answer: A,C,D

Question 2

Examine the command:
dbcli describe-component
What information will you get by executing this command?

A. displays the latest patch available for the DB system

B. displays all the components related to the Object Storage

C. displays all the storage objects created

D. displays the installed patch versions for the DB system

Correct Answer: D

Question 3

Which two important factors need to considered while configuring a DB system?

A. Dynamic Routing Gateway

B. Transparent Data Encryption

C. Cluster Time Synchronization Service

D. Network Time Protocol

E. Service Gateway

Correct Answer: B,D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 4

What is the default encryption for user-defined tablespaces in a database on OCI?

A. encrypt_new_tablespaces = cloud only

B. encrypt_new_tablespaces = DDL

C. encrypt_new_tablespaces = NONE

D. encrypt_new_tablespaces = true

Correct Answer: A

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 5

You created a new PDB in a VM DB system and while creating a tablespace in the PDB an error is returned:
ORA-28374: typed master key not found in wallet.
Which three options would resolve this problem?

A. Disable the auto-login wallet and convert the wallet to password wallet.

B. Re-enable the auto-login wallet.

C. Change the location of the auto-login wallet.

D. Delete the encryption wallet entry from the sqlnet.orA.

E. Activate the master encryption key for the newly created PDB.

Correct Answer: A,C,E

Question 6

You want to enable the EM Express console for a database in the DB system. Which procedure/function would you use?

A. DBMS_XDB_CONFIG.GETHTTPSPORT

B. DBMS_XDB_CONFIG.SETHTTPSPORT

C. DBMS_XDB_CONFIG.GETHTTPPORT

D. DBMS_XDB_CONFIG.SETLISTENERENDPOINT

Correct Answer: B

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 7

You want to migrate a schema from on premises database to OCI database. Which two can be used to achieve this?

A. Data Pump

B. Golden Gate

C. SQL Developer

D. Data Guard

Correct Answer: B,D

Question 8

Which two statements are true about the regions and availability domains (AD)?

A. OCI is hosted in multiple regions and multiple availability domains.

B. Regions provide disaster recovery capability.

C. A region can have only one AD for disaster recovery capability.

D. OCI is hosted in one region with multiple availability domains.

Correct Answer: C,D

Welcome to TestSimulate

Oracle Database Cloud Service 2021 Specialist (1z0-998-21) Free Practice Test