1Z0-071 Data Definition Language (DDL)

Question 1

Which DDL statement creates a new table in Oracle?

Accepted Answer

CREATE TABLE

Answer

INSERT TABLE

Answer

MAKE TABLE

Answer

BUILD TABLE

Question 2

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

Accepted Answer

Adds a new column to an existing table

Answer

Removes an existing column

Answer

Changes the data type of an existing column

Answer

Renames the table

Question 3

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

Accepted Answer

PRIMARY KEY

Answer

UNIQUE

Answer

NOT NULL

Answer

CHECK

Question 4

What does the DROP TABLE statement do?

Accepted Answer

Removes the table and all its data permanently

Answer

Removes all rows but keeps the table structure

Answer

Moves the table to a different schema

Answer

Disables all constraints on the table

Question 5

Which Oracle DDL command renames an existing table?

Accepted Answer

RENAME old_name TO new_name

Answer

ALTER TABLE old_name RENAME TO new_name

Answer

MODIFY TABLE old_name TO new_name

Answer

UPDATE TABLE old_name SET name = 'new_name'

Question 6

Which DDL statement removes all rows from a table but keeps its structure, and cannot be rolled back?

Accepted Answer

TRUNCATE TABLE

Answer

DELETE FROM table

Answer

DROP TABLE

Answer

REMOVE TABLE