1z1-116 試験問題を無料オンラインアクセス

Which two statements are true about column-level transparent data encryption?

• A.All encrypted columns of a table use the same encryption key.
• B.It can bo used for tables in encrypted tablcspaces.
• C.Column level encrypted data remains encrypted in the buffer cache.
• D.encrypted columns cannot have an Index.
• E.Column-level encryption keys are not encrypted by the master key.

You configured Kerberos authentication for databases running on servers A and B.
However a database link connecting the database on server A to the database on server B fails with ORA-12638 Credential retrieval failed.
Where must you make a change to sqlnet.ora to allow the database link to use its stored credentials Instead of trying to use Kerberos?

• A.on server side of server B
• B.on client side of server B
• C.on server side of server A
• D.on client side of server A

Examine these commands that execute successfully:

What must be done to allow the index to be used?

• A.Add the first_name column to the ix_employee Index to Improve its selectivity.
• B.Enable encryption hardware acceleration on the CPUs of the machine.
• C.Create a SQL baseline to preserve the execution plan from before the encryption.
• D.Use tublespace encryption instead of column encryption.

Database Vault realm r protects all tables In the fin schema from DBA access User fin is configured as the owner in realm R.
You must also prevent access to realm r protected tables by user FIN. Which achieves this?

• A.Remove the owner authorization of user fin in realm R.
• B.Make user FIN participant In realm r. Instead of owner.
• C.Revoke the select any table privilege from user FIN.
• D.Make realm R a mandatory realm.

Which two are true about auditing in an Oracle Database?

• A.No SYS operations are audited by default In unified auditing.
• B.SYS logon operations are always audited In unified auditing.
• C.All SYS operations are audited by default in unified auditing.
• D.SYS logon operations are always audited in mixed mode auditing.
• E.No SYS operations are audited if audit_sys_operations is set on false in unified auditing.
• F.No SYS operations are audited if audit_sys_operations is set on false in mixed mode auditing.