Oracle SQL Oracle SQL DDL and Schema Objects 2

Question 1

What is a synonym in Oracle SQL?

Accepted Answer

An alternate name for a database object

Answer

A copy of a table's data

Answer

A stored procedure alias

Answer

A backup of an index

Question 2

Which Oracle SQL index type is best suited for columns with very few distinct values like gender (M/F)?

Accepted Answer

Bitmap index

Answer

B-tree index

Answer

Function-based index

Answer

Composite index

Question 3

What does CREATE TABLE AS SELECT do in Oracle SQL?

Accepted Answer

Creates a new table with structure and data copied from a query result

Answer

Creates a view based on a SELECT

Answer

Creates a temporary table

Answer

Creates a table with only column structure, no data

Question 4

Which Oracle SQL constraint ensures a column's value meets a specific condition?

Accepted Answer

CHECK

Answer

UNIQUE

Answer

NOT NULL

Answer

FOREIGN KEY

Question 5

What is the purpose of the NOCACHE option when creating an Oracle SEQUENCE?

Accepted Answer

Prevents the sequence from being cached in memory, issuing numbers one at a time

Answer

Stops the sequence from cycling

Answer

Creates a descending sequence

Answer

Prevents other sessions from using the sequence

Question 6

Which privilege is required to create a table in another user's schema in Oracle SQL?

Accepted Answer

CREATE ANY TABLE

Answer

CREATE TABLE

Answer

ALTER TABLE

Answer

INSERT ANY TABLE