1Z0-006 Security Management 3

Question 1

Which profile parameter limits the number of consecutive failed login attempts before an account is automatically locked?

Accepted Answer

FAILED_LOGIN_ATTEMPTS

Answer

FAILED_LOGIN_ATTEMPTS in a profile defines how many consecutive incorrect passwords are allowed before Oracle locks the account.

Question 2

What is the role of the SYSDBA privilege in Oracle Database?

Accepted Answer

It grants the highest administrative power, including starting and stopping the database

Answer

SYSDBA is the most powerful Oracle privilege, enabling operations such as STARTUP, SHUTDOWN, and RECOVER DATABASE that go beyond normal DBA capabilities.

Question 3

Which view would a DBA query to see privileges that have been granted directly to a specific user?

Accepted Answer

DBA_SYS_PRIVS

Answer

DBA_SYS_PRIVS lists system privileges granted to users and roles, showing the grantee, privilege name, and whether it was granted WITH ADMIN OPTION.

Question 4

What does granting a privilege WITH GRANT OPTION allow the recipient to do?

Accepted Answer

Grant the same object privilege to other users

Answer

WITH GRANT OPTION lets the grantee pass the same object privilege on to additional users, creating a chain of privilege delegation.

Question 5

A user requires temporary elevated access to run a monthly report. Which Oracle feature best supports granting time-limited access without changing the user's default privileges?

Accepted Answer

Enabling a role within the session

Answer

A role can be enabled or disabled within a session using SET ROLE, allowing users to activate extra privileges only when needed.

(1Z0-006) Oracle Database Foundations Associate Practice Test

(1Z0-006) Oracle Database Foundations Associate Practice Test

1Z0-006 Security Management 3