Oracle 1Z0-116 問題集

質問 1：
Examine these steps:
1. Run the DBSAT Collector
2. Run the DBSAT Discoverer
3. Run the DBSAT Reporter
Identify the minimum required steps for producing a report of schemas with sensitive data.
A. 2
B. 1,2,3
C. 1,2
D. 2,3
正解：B

質問 2：
You must mask data consistently In three database copies such that data relations across the databases remain In place.
Which Data Masking Format allows this?
A. Random Strings
B. Shuffle
C. Array List
D. Substitute
E. Auto Mask
正解：B

質問 3：
Examine these statements which execute successfully:

Which are the two reasons that no rows Are returned from the query?
A. Enterprise User Security is not configured and used for the user.
B. An administrator issues the ALTER SYSTEM FLUSH global context statement.
C. The application context is global.
D. The set_empno_crx_proc procedure must be in a package.
E. Only DBA users can query SESSION_CONTEXT view contents.
正解：A,C

質問 4：
While upgrading your Oracle database server from 10g to 19c, you want to ensure that the users can still connect with their current passwords after the upgrade.
What do you need to set explicitly for this purpose?
A. SQLNET.ALLOWED_LOGON_VERSION_SERVER = 12a in the sqlnet.ora of the new database home
B. Client net. allowed_lLOGON_VERSION_client must be set to a lower value than the server SQLNET.ALLOWED LOGON. VEBSION .SERVER.
C. SQLNET.ALLOWED_LOGON_VERSION_client = 8 in the sqlnec.ora file of the client application.
D. SQLNET.ALLOWED_LOGON_VERSION_sebveb = 8 In the aqlnec.ora of the new database homo.
正解：D

質問 5：
Examine these commands and the output used to configure Real Application Security:

What does this output mean?
A. You created a realm and an access control list that reference a non-existent policy.
B. You treated an access control list that references a non-existent policy.
C. You created an access control list that references a non-existent realm.
D. You created a policy that references a non-existent realm.
E. You created a realm that references a non-existent policy.
F. You created a policy that references a non-existent access control list.
正解：E

質問 6：
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 second statement falls because granting a global role can be completed only by using a central authority.
C. The first statement falls because the database Is not set up with Enterprise User Security.
D. All statements succeed even without Enterprise User Security configuration, but the role is not effective.
正解：C