Oracle SQL Oracle SQL DDL and Schema Objects 3

Question 1

What does the INVISIBLE option do when creating an index in Oracle SQL (11g+)?

Accepted Answer

Creates the index but the optimizer ignores it by default

Answer

Drops the index after the session ends

Answer

Creates an index that only works for DML

Answer

Makes the index available only to privileged users

Question 2

Which Oracle SQL object stores the result of a query and updates it periodically?

Accepted Answer

Materialized view

Answer

Regular view

Answer

Inline view

Answer

Indexed view

Question 3

What does the ENABLE NOVALIDATE constraint state do in Oracle SQL?

Accepted Answer

Enables the constraint for new rows only, without validating existing rows

Answer

Enables the constraint and checks all existing rows

Answer

Disables the constraint entirely

Answer

Validates existing rows without enabling for new ones

Question 4

Which Oracle SQL statement creates a table that exists only for the duration of a session?

Accepted Answer

CREATE GLOBAL TEMPORARY TABLE

Answer

CREATE TEMP TABLE

Answer

CREATE VOLATILE TABLE

Answer

CREATE SESSION TABLE

Question 5

What is the purpose of the GRANT statement in Oracle SQL?

Accepted Answer

Gives privileges on database objects to users or roles

Answer

Creates a new user account

Answer

Transfers object ownership

Answer

Audits user activity

Question 6

What does ALTER TABLE employees ADD CONSTRAINT emp_pk PRIMARY KEY (employee_id) do?

Accepted Answer

Adds a primary key constraint to an existing table

Answer

Replaces an existing primary key

Answer

Creates a new column called employee_id

Answer

Adds a foreign key referencing employee_id