Question 1

A(n)____ index is an index that is partitioned when either the table is not partitioned or the table is partitioned in a different way than the index.

Accepted Answer

A global partitioned index is an index that is partitioned independently of the table's partitioning scheme, meaning it can be partitioned even if the table is not, or it can be partitioned differently from the table.

Question 2

The ____ index is used for application- or cartridge-specific indexes.

Accepted Answer

The domain index is used for application- or cartridge-specific indexes, allowing developers to create custom indexing schemes tailored to specific application needs.

Question 3

If successful,the ALTER INDEX ...REBUILD command automatically corrects an index that has been marked ____ because a change was made to the structure of the underlying table or partition.

Accepted Answer

When a change is made to the structure of the underlying table or partition, the index becomes unusable and needs to be rebuilt. The ALTER INDEX ...REBUILD command automatically corrects this issue and rebuilds the index, making it usable again. Therefore, the correct answer is B, "UNUSABLE".

Question 4

The reverse key index is a type of ____ index used to improve efficiency of Oracle Real Application Clusters.

Accepted Answer

Reverse key index is a type of BTree index used to improve performance by distributing index entries more evenly across all leaf blocks, which is particularly useful in Oracle Real Application Clusters.

Question 5

____________________ constraints enforce only those changes that are made within the application.

Accepted Answer

The answer of ____________________ constraints enforce only those changes that...

Question 6

An index created to support a ____ constraint does not allow any null values in any of the indexed columns,because there is an automatic NOT NULL constraint added to a primary key column.

Accepted Answer

A PRIMARY KEY constraint automatically enforces NOT NULL and UNIQUE constraints, ensuring that all values in the primary key column(s) are unique and not null.

Question 7

The ____ index is used on partitioned tables where the index is created on all partitions for the entire table,as a single index.

Accepted Answer

The global partitioned index is created on all partitions for the entire partitioned table, as a single index. Therefore, it is the appropriate choice for the given scenario.

Question 8

A ____ view is a view that can be used to insert a new row into the underlying table,as long as the row would be returned by a query,or the row exists for the view.

Accepted Answer

The answer of A ____ view is a view that...

Question 9

An index can have from one to ____ columns (only 30 columns if it is a bitmap index).

Accepted Answer

According to the statement, an index can have from one to 32 columns. Therefore, the best choice is A.

Question 10

When executing a package or a procedure,you must either wrap the command in a PL / SQL block by using the BEGIN and END;clauses on either side of the command,or type ____ and the command all on a single line.

Accepted Answer

The correct syntax to execute a package or a procedure in SQL*Plus is to use the EXECUTE command followed by the name of the package or the procedure. Therefore, the best choice is D, which is EXECUTE. Option A, INIT, is not a valid keyword in this context. Option B, COMMAND, is too general and does not provide enough information on how to execute the package or procedure. Option C, RUN, is a valid SQL*Plus command, but it is not the correct one to execute a package or procedure.

Question 11

Sequence values can be accessed using the ____ and NEXTVAL pseudocolumns.

Accepted Answer

The correct pseudocolumns for accessing sequence values are CURRVAL (to access the current sequence value) and NEXTVAL (to generate and retrieve the next sequence value). There is no pseudocolumn called PREVVAL or FIRSTVAL. UPVAL is not a valid pseudocolumn at all.

Question 12

A data dictionary view named ____ lists indexed column names and statistics either owned by the user or accessible to the user.

Accepted Answer

The ALL_IND_COLUMNS view lists indexed column names and statistics for indexes that are either owned by the user or accessible to the user.

Question 13

The ____ index is used to store pre-computed expression values based on table columns.

Accepted Answer

Function-based indexes are used to store pre-computed expression values based on table columns. These expression values can be used to speed up queries that involve complex computations or expressions. The other options, domain, BTree, and reverse key indexes, are not specifically designed for storing pre-computed expression values.

Question 14

You can create a ____ index on a nonpartitioned table.

Accepted Answer

A global partitioned index can be created on a nonpartitioned table. A global partitioned index is a type of index where the index table is partitioned in the same way as the underlying table. This means that the index table is divided into partitions that are constructed and managed in the same way as the underlying table. As a result, a global partitioned index can improve query performance by reducing the amount of data that needs to be scanned or searched.

Question 15

The ____ index is by default a BTree but can also be a hash-clustered index.

Accepted Answer

The cluster index is the only index among the options that can be implemented as a hash-clustered index in addition to its default BTree implementation. The domain index is not a type of index in Oracle database, while both local partitioned and global partitioned indexes are based on BTree structure only.

Question 16

The indexed columns in a ____ index should have low cardinality.

Accepted Answer

Indexed columns in a bitmap index should have low cardinality because bitmap indexes work best with columns that have a low number of distinct values. Bitmap indexes use a bitmap for each possible value in the indexed column, and the bitmap indicates which rows contain that particular value. If the column has high cardinality (many distinct values), then the bitmaps can become very large and the index can become inefficient. Therefore, a bitmap index is the best choice when the indexed columns have low cardinality.

Question 17

A ____ index cannot contain any DESC columns.

Accepted Answer

The answer of A ____ index cannot contain any DESC...

Question 18

____________________ constraints are constraints defined at the database level on either a column or a table.

Accepted Answer

The answer of ____________________ constraints are constraints defined at the...

Question 19

In addition to providing faster access to data,certain indexes also have a second purpose: enforcing a PRIMARY KEY constraint or ____ constraint.

Accepted Answer

Indexes with a UNIQUE constraint enforce uniqueness of values in a column or a group of columns, which is the purpose of a PRIMARY KEY constraint. Therefore, D is the correct answer. FOREIGN KEY constraint is not related to indexes, CHECK constraint ensures that a column value meets a specified condition, and NOT NULL constraint ensures that a column cannot have a NULL value.

Question 20

Unless you specifically instruct Oracle 10g to create a bitmap index,it always creates a ____ index.

Accepted Answer

The default index created by Oracle 10g is a BTree index. So, if no specific instructions are given, a BTree index will be created.

Quiz 9: Constraints, indexes, and Other Specialized Objects

A(n) ____ index is an index that is partitioned when either the table is not partitioned or the table is partitioned in a different way than the index.