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

Database Administration and Security 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 Database Administration and Security flashcards as text

  1. Which initialization parameter file stores the database configuration parameters and can be modified without restarting the instance?

    Answer: SPFILE (server parameter file)

    The SPFILE (Server Parameter File) is a binary file that allows parameters to be changed dynamically using ALTER SYSTEM and persist across instance restarts.

  2. What is the role of the Oracle SMON background process?

    Answer: Performing instance recovery at startup and coalescing free space in tablespaces

    SMON (System Monitor) performs automatic instance recovery at database startup and reclaims unused temporary space in tablespaces.

  3. A user receives ORA-01950: no privileges on tablespace error when trying to insert data. What is the most likely fix?

    Answer: Grant a quota on the tablespace to the user using ALTER USER

    ORA-01950 occurs when a user has no quota assigned to a tablespace; the fix is ALTER USER username QUOTA amount ON tablespace_name.

  4. What is the purpose of Oracle's UNDO tablespace?

    Answer: Storing before-images of data to support transaction rollback and read consistency

    The UNDO tablespace stores before-images (undo records) of changed data, enabling transaction rollback, read consistency, and Flashback features.

  5. Which Oracle feature automatically manages the sizes of various SGA components like the buffer cache and shared pool?

    Answer: Automatic Memory Management (AMM) / Automatic Shared Memory Management (ASMM)

    Automatic Memory Management (AMM) or Automatic Shared Memory Management (ASMM) dynamically redistributes memory between SGA components based on workload needs.

  6. In Oracle, which dictionary view would you query to see the privileges granted directly to a specific user (not through roles)?

    Answer: DBA_SYS_PRIVS

    DBA_SYS_PRIVS shows system privileges granted directly to users and roles, allowing a DBA to see which system privileges a user holds.

  7. What is the correct sequence of steps when Oracle performs a CHECKPOINT?

    Answer: LGWR writes log buffer → DBWR writes dirty blocks → control file and data file headers updated

    During a checkpoint, LGWR first ensures redo is written, DBWR then writes dirty buffer cache blocks to data files, and finally control files and data file headers are updated with the checkpoint SCN.