Question 1

You export and Import a table's data using Data Pump connected as a user who Is assigned DBA role with

default privileges.

There is a data redaction policy on the table.

Which two statements are true about the redaction policy?

Options :

A : The actual data in the tables is copied to the Data Pump target system with the redaction policy applied.

B : The policy Is not Included In export and Import operation.

C : The actual data in the tables is copied to the Data Pump target system without being redacted.

D : The policy Is Included In the export and Import operation but is not applied by default to the objects In the target system.

E : The policy is included in the export and import operation and applied by default to the objects in the target system.

Answer: B,C

Question 2

Examine this parameter In sqinet.ora:

SQLNET.ADTHENTICATION_SEBVICES=(NONE)

For which two cases do you need a password file?

Options :

A : to authenticate externally Identified users locally

B : to authenticate nonprivllegcd database users locally

C : to authenticate administrative privileged users remotely

D : to authenticate externally Identified users remotely

E :

to authenticate externally Identified users remotely

F :

to authenticate administrative privileged users locally

Answer: A,C

Question 3

Using Unified Audit, you must determine who performed an pkan backup ot recovery operations on a database.

You are connected as sysdba.

Which statement(s) achieve this?

Options :

A :

B :

C :

D :

E :

Answer: A

Question 4

A database link must be created to connect a source Autonomous Database to target on premises database.

Examine this command:

Which two options are true?

Options :

A : The target database wallet can be uploaded to the data_pctmp_dtr directory.

B : The db_link_cred parameter stores the password in a wallet.

C : The db__link__cred references the credential for the username and password for the target database.

D : The credential_nam£ parameter automatically creates the credential object store.

E : The database link port Is not correct because It must be restricted to 1521.

F : Only data_pump_dir directory can be used to store credential wallets.

Answer: B,D

Question 5

Which three authentication methods are available with Centrally Managed Users (CMU)?

Options :

A : remote Access Services authentication

B : smart key authentication

C : public key Infrastructure (PKT) authentication

D : kerberos authentication

E : username/password authentication

F : SSH authentication

Answer: C,D,F

Confidently Practice Online with Free 1Z0-116 Exam Cram

Buying Options: