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 Oracle security feature allows row-level access control based on security policies?

    Answer: Oracle Label Security / Virtual Private Database (VPD)

    Virtual Private Database (VPD) / Oracle Label Security enables fine-grained access control by automatically appending WHERE clauses to queries based on security policies.

  2. What is Transparent Data Encryption (TDE) in Oracle used for?

    Answer: Encrypting data stored in data files and backups without application changes

    TDE encrypts data at rest in data files and tablespaces, protecting against physical theft of storage media without requiring any application changes.

  3. Which command would a DBA use to change a user's password in Oracle?

    Answer: ALTER USER username IDENTIFIED BY new_password

    The ALTER USER ... IDENTIFIED BY statement is the correct SQL syntax to change a user's password in Oracle.

  4. What is the purpose of an Oracle PROFILE?

    Answer: To define a set of resource limits and password policies assigned to database users

    An Oracle PROFILE is a named set of limits on database resources (CPU, sessions, etc.) and password settings that can be assigned to users.

  5. In Oracle, what is the difference between a system privilege and an object privilege?

    Answer: System privileges allow performing actions on the database; object privileges allow actions on specific schema objects

    System privileges (like CREATE TABLE) allow a user to perform database-wide actions, while object privileges (like SELECT on a specific table) control access to individual schema objects.

  6. What does the Oracle parameter ARCHIVELOG mode enable?

    Answer: Recording of all redo log files before they are overwritten, enabling point-in-time recovery

    In ARCHIVELOG mode, Oracle saves (archives) filled redo log groups before reusing them, enabling complete media recovery and point-in-time recovery.

  7. Which Oracle utility is used for logical database backups and exports of database objects?

    Answer: Data Pump (expdp/impdp)

    Oracle Data Pump (using expdp for export and impdp for import) performs high-speed logical backups and transfers of database objects and data.