Oracle SQL Oracle SQL DDL and Schema Objects

Question 1

Which Oracle SQL constraint ensures no two rows in a table have the same value in a column?

Accepted Answer

UNIQUE

Answer

PRIMARY KEY

Answer

NOT NULL

Answer

CHECK

Question 2

What does the CASCADE option do in DROP TABLE in Oracle SQL?

Accepted Answer

Drops the table and all dependent foreign key constraints

Answer

Backs up the table before dropping

Answer

Drops related tables too

Answer

Forces the drop even if rows exist

Question 3

Which Oracle SQL statement modifies the structure of an existing table?

Accepted Answer

ALTER TABLE

Answer

MODIFY TABLE

Answer

UPDATE TABLE

Answer

CHANGE TABLE

Question 4

Which Oracle SQL object automatically generates unique sequential numbers?

Accepted Answer

SEQUENCE

Answer

AUTO_INCREMENT column

Answer

TRIGGER

Answer

ROWNUM

Question 5

What is the purpose of a DATABASE LINK in Oracle SQL?

Accepted Answer

Allows queries to access objects in a remote Oracle database

Answer

Creates a hyperlink in SQL reports

Answer

Links a table to a view

Answer

Stores frequently used queries

Question 6

Which Oracle SQL statement removes a view from the database?

Accepted Answer

DROP VIEW

Answer

DELETE VIEW

Answer

REMOVE VIEW

Answer

TRUNCATE VIEW