Practice Test Geeks1Z0-082 - Oracle Database Administration I Practice Test
← All 1Z0-082 Flashcard Decks

Managing Schemas and Database Objects Flashcards

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

Read the first 6 Managing Schemas and Database Objects flashcards as text

  1. Which data dictionary view shows all tables accessible to the current user, including those in other schemas?

    Answer: ALL_TABLES

    ALL_TABLES shows all tables that the current user has privileges to access, including their own and those granted by other schemas.

  2. What is the primary purpose of a database trigger in Oracle?

    Answer: To automatically execute PL/SQL code in response to a DML or DDL event

    A trigger is a stored PL/SQL block that fires automatically when a specified DML (INSERT, UPDATE, DELETE) or DDL event occurs on a table or schema.

  3. Which DDL command is used to modify an existing column's data type or add a new column to a table?

    Answer: ALTER TABLE

    The ALTER TABLE statement is used to modify existing table structure, including adding, modifying, or dropping columns and constraints.

  4. What is a materialized view in Oracle Database?

    Answer: A physical copy of query results stored as a table and refreshable on demand or schedule

    A materialized view physically stores the results of a query and can be refreshed either on demand or automatically on a schedule to reflect source data changes.

  5. When a table is dropped using the DROP TABLE command in Oracle, where does it go by default?

    Answer: It is moved to the Recycle Bin

    By default in Oracle 10g and later, dropped tables are moved to the Recycle Bin and can be recovered using the FLASHBACK TABLE ... TO BEFORE DROP statement.

  6. What prerequisite must be met to use FLASHBACK TABLE to restore a dropped table in Oracle?

    Answer: The Recycle Bin must be enabled and the table must still exist in it

    FLASHBACK TABLE ... TO BEFORE DROP works by restoring the table from the Recycle Bin, which requires the Recycle Bin feature to be enabled and the object not yet purged.