Oracle 1Z0-116 問題集

質問 1：
User jane must report on who has done RMAN backups on a database that has Unified Auditing enabled.
What is the minimum that must be done to allow JANE to generate these reports?
A. Use grant audit_admin to Jane;
B. Use alter system set AUDIT_SYS_OPERATION= TRUE;
C. Use grant audit_viewer to Jane;
D. Use create audit policy.
正解：D

質問 2：
Which CVSS Version 3.1 metric indicates how close an attacker needs to be to the vulnerable component?
A. Scope
B. Availability
C. User Interaction
D. Attack Vector
E. Privileges Required
F. Attack Complexity
正解：A

質問 3：
You must redact the salary column of the HR.EMPLOYEES table to display only the number o. Examine this syntax:

Which function type must be Inserted at the end of line #7?
A. DBMS_REDACT.PARTIAL
B. DBMS_RE DACT.RANDOM
C. DBMS_BEDACT.NONE
D. DBMS_REDACT.FUI,I.
E. DBMS REDACT.REGEXP
正解：A

質問 4：
As the SYSKM user you must create the password-based keystore, which will be used for TDE. Examine this list:

Identify the sequence that Oracle uses to search for the keystore and its location.
A. 3,5,2,4,1
B. 1,4,5,2
C. 1,2,5,4
D. 1,2,3,5
正解：C

質問 5：
You Issue this statement as user SYS:
audit, context namespace kilimanjaro attributes a, b;
Which is true?
A. The statement will not audit any users.
B. The statement must be updated to specify which users to audit.
C. The statement will only audit sys.
D. The statement will audit all users.
正解：C

質問 6：
Examine this sqlnet.ora file used by a client application:

Which three are found in the wallet specified by the directory parameter?
A. the username, password, and service name required to connect to the database
B. the private key of the database service
C. the user certificate used to uniquely Identify the database service
D. the user certificate used to uniquely Identify the client application
E. the trusted certificates of the Certification Authority
F. the trusted certificates of the database service
G. the private key of the client application
正解：D,E,G