1Z0-082 Managing Schemas and Database Objects 3

Question 1

Which constraint type enforces uniqueness of values in one or more columns but allows NULL values?

Accepted Answer

UNIQUE

Answer

PRIMARY KEY

Answer

CHECK

Answer

NOT NULL

Question 2

What is an Index-Organized Table (IOT) in Oracle?

Accepted Answer

A table whose rows are stored in primary key order within a B-tree index structure

Answer

A table stored entirely in memory

Answer

A table with a bitmap index

Answer

A partitioned table sorted by a date column

Question 3

Which data dictionary view lists all indexes owned by the current user?

Accepted Answer

USER_INDEXES

Answer

ALL_INDEXES

Answer

DBA_INDEXES

Answer

SESSION_INDEXES

Question 4

What is the primary purpose of the DBMS_STATS package in Oracle?

Accepted Answer

To collect optimizer statistics on tables, indexes, and schemas

Answer

To back up the database

Answer

To monitor active sessions

Answer

To manage redo log files

Question 5

Which index type is most appropriate for a column with very few distinct values, such as a gender or status flag?

Accepted Answer

Bitmap index

Answer

B-tree index

Answer

Function-based index

Answer

Reverse key index

Question 6

What is the purpose of a database link (DBLINK) in Oracle?

Accepted Answer

To create a connection that allows queries to access objects in a remote Oracle database

Answer

To link two tables within the same schema

Answer

To synchronize indexes automatically

Answer

To establish a backup channel to standby