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
Which DDL statement creates a new table in Oracle?
Answer: CREATE TABLE
CREATE TABLE defines a new table with its columns, data types, and optional constraints.
What does the ALTER TABLE ... ADD COLUMN statement do?
Answer: Adds a new column to an existing table
ALTER TABLE with the ADD clause inserts a new column definition into an existing table.
Which constraint ensures each value in a column is unique and not NULL?
Answer: PRIMARY KEY
A PRIMARY KEY constraint enforces both uniqueness and NOT NULL on the column(s) it covers.
What does the DROP TABLE statement do?
Answer: Removes the table and all its data permanently
DROP TABLE removes the table definition and all its rows, freeing all associated storage.
Which Oracle DDL command renames an existing table?
Answer: RENAME old_name TO new_name
The RENAME statement changes the name of a table (or other object) to a new name.
Which DDL statement removes all rows from a table but keeps its structure, and cannot be rolled back?
Answer: TRUNCATE TABLE
TRUNCATE TABLE is a DDL command that removes all rows instantly without logging individual row deletions and cannot be rolled back.