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 statement correctly describes the difference between system privileges and object privileges in Oracle?

    Answer: System privileges allow actions on any object of a type; object privileges apply to a specific object

    System privileges (e.g., CREATE TABLE) allow performing an action on any applicable object, while object privileges (e.g., SELECT on HR.EMPLOYEES) apply only to a named object.

  2. Which Oracle view shows object privileges granted on objects owned by the current user?

    Answer: USER_TAB_PRIVS_MADE

    USER_TAB_PRIVS_MADE lists all grants the current user has made on their own objects, showing the grantee and the privilege granted.

  3. What is a 'secure application role' in Oracle Database?

    Answer: A role that can only be enabled through a PL/SQL procedure that verifies context conditions

    A secure application role can only be activated by calling a specific PL/SQL procedure, which can verify application context, IP address, or other conditions before enabling the role.

  4. Which password profile parameter prevents a user from reusing a password within a specified number of days?

    Answer: PASSWORD_REUSE_TIME

    PASSWORD_REUSE_TIME specifies the number of days a user must wait before they can reuse a previously used password.

  5. Fine-Grained Auditing (FGA) in Oracle differs from standard auditing primarily because it:

    Answer: Can trigger auditing based on specific column values accessed in a query

    FGA allows policies that fire only when specific columns are referenced in a query or when the data returned matches defined conditions, providing much more precise auditing than standard auditing.

  6. Which predefined Oracle role grants the privileges needed to perform all database administration tasks except those requiring SYSDBA?

    Answer: DBA

    The DBA role contains a broad set of system and object privileges that cover typical database administration tasks, though STARTUP/SHUTDOWN still requires SYSDBA.

  7. When a user is created without specifying a PROFILE, which profile does Oracle assign by default?

    Answer: DEFAULT

    Oracle assigns the DEFAULT profile to any new user when no profile is explicitly specified in the CREATE USER statement.