Practice Test Geeks1Z0-071 - Oracle Database SQL Certified Associate Practice Test
← All 1Z0-071 Flashcard Decks

Data Definition Language (DDL) Flashcards

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

Read the first 6 Data Definition Language (DDL) flashcards as text

  1. What does DESCRIBE (or DESC) command show for a table in Oracle SQL*Plus?

    Answer: Column names, data types, and NULL/NOT NULL constraints

    DESC table_name displays each column's name, nullability, and data type in SQL*Plus and SQL Developer.

  2. Which view can you query to see all tables owned by the current user in Oracle?

    Answer: USER_TABLES

    USER_TABLES shows metadata about all tables owned by the currently logged-in Oracle user.

  3. What happens to dependent objects like views when you DROP a table in Oracle?

    Answer: They become invalid but are not dropped

    When a base table is dropped, views and synonyms that depend on it become INVALID but remain in the data dictionary.

  4. Which DDL command is used to remove a column from an existing table?

    Answer: ALTER TABLE ... DROP COLUMN

    ALTER TABLE ... DROP COLUMN removes a column and all its data from an existing table.

  5. What does the ON DELETE CASCADE option on a FOREIGN KEY do?

    Answer: Automatically deletes child rows when the parent row is deleted

    ON DELETE CASCADE automatically deletes all child rows in the referencing table when the parent row is deleted.

  6. Which Oracle data type stores large amounts of character data beyond 4000 bytes?

    Answer: CLOB

    CLOB (Character Large Object) stores up to 128 TB of character data and is Oracle's recommended type for large text.