1Z0-071 Data Definition Language (DDL)

Question 1

Which DDL statement creates a new table in Oracle?

Accepted Answer

CREATE TABLE

Answer

CREATE TABLE defines a new table with its columns, data types, and optional constraints.

Question 2

What does the ALTER TABLE ... ADD COLUMN statement do?

Accepted Answer

Adds a new column to an existing table

Answer

ALTER TABLE with the ADD clause inserts a new column definition into an existing table.

Question 3

Which constraint ensures each value in a column is unique and not NULL?

Accepted Answer

PRIMARY KEY

Answer

A PRIMARY KEY constraint enforces both uniqueness and NOT NULL on the column(s) it covers.

Question 4

What does the DROP TABLE statement do?

Accepted Answer

Removes the table and all its data permanently

Answer

DROP TABLE removes the table definition and all its rows, freeing all associated storage.

Question 5

Which Oracle DDL command renames an existing table?

Accepted Answer

RENAME old_name TO new_name

Answer

The RENAME statement changes the name of a table (or other object) to a new name.

1Z0-071 - Oracle Database SQL Certified Associate Practice Test