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

Database Concepts & Terminology 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 Concepts & Terminology flashcards as text

  1. Which term describes the process of organizing database tables to reduce data redundancy and improve data integrity?

    Answer: Normalization

    Normalization is the process of structuring a relational database according to normal forms (1NF, 2NF, 3NF, etc.) to eliminate redundancy and dependency anomalies.

  2. In Oracle Database, what is a 'tablespace'?

    Answer: A logical storage container that groups related data files

    A tablespace is the logical unit of Oracle database storage that groups one or more physical data files, and all database objects belong to a tablespace.

  3. What does 'atomicity' mean in the context of ACID database properties?

    Answer: All operations in a transaction either complete fully or are entirely rolled back

    Atomicity guarantees that a transaction is treated as a single indivisible unit—if any part fails, all changes made by the transaction are rolled back entirely.

  4. Which of the following best describes a 'data dictionary' or 'system catalog' in a DBMS?

    Answer: A repository of metadata that describes the structure and organization of the database

    The data dictionary (system catalog) is a set of system tables and views that store metadata about all database objects, such as table definitions, column data types, and constraints.

  5. What is a 'surrogate key'?

    Answer: A system-generated unique identifier with no business meaning used as a primary key

    A surrogate key is an artificially created unique identifier (often an auto-incremented number) that has no intrinsic business meaning but serves as the primary key.

  6. The term 'concurrency control' in database management refers to:

    Answer: Managing simultaneous access to the database by multiple users to ensure data consistency

    Concurrency control mechanisms, such as locking and multiversion concurrency control (MVCC), coordinate simultaneous transactions so they do not corrupt each other's data.

  7. Which of the following is an example of a DML (Data Manipulation Language) statement in SQL?

    Answer: UPDATE employees SET salary = 5000 WHERE id = 10

    UPDATE is a DML statement because it modifies existing data within a table, whereas CREATE and DROP are DDL and GRANT is DCL.