Practice Test Geeks(1Z0-006) Oracle Database Foundations Associate Practice Test
← All 1Z0-006 Flashcard Decks

Security Management Flashcards

7 cards from real 1Z0-006 practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 7 Security Management flashcards as text

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

    Answer: FAILED_LOGIN_ATTEMPTS

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

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

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

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

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

    Answer: DBA_SYS_PRIVS

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

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

    Answer: Grant the same object privilege to other users

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

  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?

    Answer: Enabling a role within the session

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

  6. Which Oracle tool or feature provides centralized management of database security policies across multiple databases?

    Answer: Oracle Enterprise Manager (OEM)

    Oracle Enterprise Manager provides a centralized console for monitoring, managing, and enforcing security policies across multiple Oracle database targets.

  7. What is the effect of revoking a system privilege that was granted WITH ADMIN OPTION from a user?

    Answer: Only the original grantee loses the privilege; downstream grants remain

    Unlike object privilege revocation cascades, revoking a system privilege does not cascade — users who received it from the revoked grantee keep their privilege.