Oracle Database Security Administration (1Z0-116) Free Practice Test
Question 1
Which two statements are true about the Secure External Password Store (SEPS)?
Correct Answer: B,E
Question 2
What Is the first step when analyzing security within a database?
Correct Answer: F
Question 3
When querying the database view, VSECRYPTION_WALLET, the status Is OPEN_NO_MASTER _KEY. What does this mean?
Correct Answer: C
Question 4
Which two privileges can be restricted at the column level?
Correct Answer: E,F
Question 5
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.
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.
Correct Answer: C
Question 6
You connect to the database Instance over a network to change the password of user scott.
Which two methods avoid the new password for user scott from being compromised by network sniffing?
Which two methods avoid the new password for user scott from being compromised by network sniffing?
Correct Answer: D,E
Question 7
Which two are true about auditing in an Oracle Database?
Correct Answer: B,E
Question 8
Examine this command that Is executed:

What is the result?

What is the result?
Correct Answer: E
Question 9
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?
Examine this command:

Which two options are true?
Correct Answer: E,F
Question 10
What is true about the client identifier?
Correct Answer: B