무료 온라인 액세스 Oracle.1Z0-116.v2022-06-16.q29 모의 시험 (Page 5)

1Z0-116 문제 16

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

A. encrypted columns cannot have an Index.

B. Column level encrypted data remains encrypted in the buffer cache.

C. All encrypted columns of a table use the same encryption key.

D. It can bo used for tables in encrypted tablcspaces.

E. Column-level encryption keys are not encrypted by the master key.

1Z0-116 문제 17

Which statement can be used to force password complexity in the password file?

A. orapwd file=orapwOBCL forroat=12.2

B. orapwd file=orapwORCL force=yes format=legacy

C. orapwd file=orapwORCL format=12 force-yes

D. orapwd file=orapwOPCL forcaat=12

1Z0-116 문제 18

Examine this query:

Why is this account in this status?

A. The ACCOUNTS_ STATUS column is not updated until the user attempts to log in.

B. The user exceeded the value of FAILED_LOGIN _ATTEMPTS and its password has not been reset yet.

C. The user exceeded the value of PASSWORD_LIFE_TIME and Its password has not been reset yet

D. The account uses a global authentication.

E. The account has the SYSDBA privilege granted.

1Z0-116 문제 19

Database user SCOTT requires the privilege to select from all tables and you decide to configure this using a global role.
You have not yet configured the database with Enterprise User Security.
You plan to perform these steps:
1. create role GLOBAI._ROI.E identified globally;
2. grant select any table to GLODAL_COLE;
3. grant GLOBAL_ROLE to SCOTT;
What is the result?

A. The third statement falls because global roles can be granted only by using a central authority.

B. The first statement falls because the database Is not set up with Enterprise User Security.

C. All statements succeed even without Enterprise User Security configuration, but the role is not effective.

D. The second statement falls because granting a global role can be completed only by using a central authority.

1Z0-116 문제 20

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?
A)