Question 1

CHECK constraints cannot contain queries or any references to other tables.

Accepted Answer

CHECK constraints can only contain scalar expressions, which do not involve any queries or references to other tables.

Question 2

A(n)____ constraint appears immediately next to the column to which it applies.
A) single column
B) multiple column
C) inline
D) out of line

Accepted Answer

An inline constraint is a constraint that appears immediately next to the column to which it applies. This type of constraint is commonly used in SQL to enforce data integrity rules. Other types of constraints, such as single column and multiple column constraints, can also be used in SQL, but they do not necessarily appear immediately next to the column they apply to. Out of line constraints do not exist in SQL.

Question 3

By default,the initial value of a sequence when it is first created is 0.

Accepted Answer

The initial value of a sequence is 0 by default.

Question 4

The ____ constraint is similar to the PRIMARY KEY constraint because both enforce unique values;the difference is that it allows null values in the column or columns that are named in the constraint.
A) CHECK
B) FOREIGN KEY
C) UNIQUE
D) NOT NULL

Accepted Answer

The UNIQUE constraint enforces unique values in a column or group of columns, similar to the PRIMARY KEY constraint. The difference is that it allows NULL values in the column(s) that are named in the constraint. The CHECK constraint is used to ensure that values in a column meet a certain condition, the FOREIGN KEY constraint is used to ensure referential integrity between tables, and the NOT NULL constraint is used to ensure that a column cannot have NULL values.

Question 5

You can use ALTER INDEX to change the column order of an existing index.

Accepted Answer

ALTER INDEX can be used to modify certain properties of an existing index such as its name, storage location, and filtering options, but it cannot change the column order. To change the column order of an index, you would need to drop and recreate the index with the desired column order.

Question 6

An index does not store an entry for a row when all the indexed columns are null except if the index is a bitmap index.

Accepted Answer

This is true for non-bitmap indexes. Null values are not included in the index, except for bitmap indexes, which do store null entries in the index.

Question 7

A ____ is a program that runs when a certain event occurs.
A) stored procedure
B) constraint
C) trigger
D) PL / SQL

Accepted Answer

A trigger is a type of code in a database that automatically runs when a certain event occurs. This event could be inserting, deleting, or updating a record in a table. Triggers are commonly used to enforce business rules, audit changes to data, or integrate with other systems.

Question 8

It is possible to create an index owned by one user on a table owned by another user,provided that the creating user has either the CREATE ANY INDEX privilege or the INDEX privilege on the target table,or the user has been granted specific privileges for creating an index on that table.

Accepted Answer

It is possible for a user to create an index on a table owned by another user if certain privileges are granted or if the user has the necessary permissions. Therefore, the statement is true.

Question 9

A bitmap index stores ROWID values and key values.

Accepted Answer

A bitmap index stores bitmaps for each distinct key value, not ROWID values directly. It uses bits to represent the presence or absence of a key value in a row.

Question 10

A(n)____ constraint appears after the full list of columns in the CREATE TABLE command and is usually used to define constraints to multiple columns.
A) single column
B) multiple column
C) inline
D) out of line

Accepted Answer

Out of line constraints are defined after the full list of columns in the CREATE TABLE command and can apply to multiple columns, making them suitable for defining complex constraints that involve more than one column.

Question 11

The ____ constraint enforces a predefined list of values for a column.
A) CHECK
B) FOREIGN KEY
C) UNIQUE
D) NOT NULL

Accepted Answer

The CHECK constraint enforces a specific condition to be met for a column, including a predefined list of values. ForeignKey constraints ensure referential integrity between two tables, Unique constraints ensure a column has unique values, and Not Null constraints enforce the column cannot be null.

Question 12

____ checking performs faster than other methods of constraint enforcement,because the optimizer has been programmed to handle them efficiently.
A) Trigger
B) Integrity constraint
C) Application constraint
D) Index

Accepted Answer

Integrity constraints are handled more efficiently by database management systems because they are built into the system, allowing the optimizer to enforce them more quickly than triggers or application-level constraints.

Question 13

____ integrity is the integrity,or soundness of data,maintained between two values,which reference each other.
A) Constraint
B) Spatial
C) Normalization
D) Referential

Accepted Answer

Referential integrity refers to the accuracy and consistency of the relationships between data in different tables in a database. This is maintained through the use of a reference or link (such as a foreign key) between two values in different tables. Therefore, referential integrity is the most appropriate choice for this scenario. Constraints ensure that certain rules or conditions are followed when entering or editing data, spatial integrity relates to the accuracy and consistency of spatial data, and normalization is a process for organizing data to minimize redundancy and improve efficiency. None of these fully capture the concept of maintaining the integrity of data between two values that reference each other.

Question 14

You can use expressions in function-based indexes.

Accepted Answer

Yes, we can use expressions in function-based indexes. This allows us to create indexes on computed columns or on columns with transformed data. The expressions used in function-based indexes can include arithmetic operations, mathematical functions, and string manipulations. This helps to speed up querying and improve performance.

Question 15

A bitmap index can be a UNIQUE index.

Accepted Answer

A bitmap index is not suitable for unique indexing because it is designed to efficiently query data with a limited number of distinct values, such as gender or boolean flags, rather than unique values like IDs or unique keys.

Question 16

Placing the ____ constraint on a column indicates that all rows in the table must contain a value in the column.
A) CHECK
B) FOREIGN KEY
C) UNIQUE
D) NOT NULL

Accepted Answer

The NOT NULL constraint indicates that the column cannot contain NULL values, which means that all rows in the table must contain a value in that column. Therefore, option D is the best choice. The other options (CHECK, UNIQUE, and FOREIGN KEY) do not necessarily require all rows in the table to contain a value in the column.

Question 17

The syntax for adding a CHECK constraint with CREATE TABLE and ALTER TABLE is quite different.

Accepted Answer

The syntax for adding a CHECK constraint in both CREATE TABLE and ALTER TABLE statements is similar, involving specifying the CHECK keyword followed by the condition in parentheses. The main difference is in the context of their use, where one is used during table creation and the other for modifying an existing table.

Question 18

A(n)____ integrity constraint is the column or set of columns that define a unique identifying value for every row in the table.
A) primary key
B) foreign key
C) unique
D) not null

Accepted Answer

A primary key is a type of integrity constraint that ensures a unique identifying value for every row in the table. It is a column or set of columns that uniquely identifies each row in the table and must be unique and not null.

Question 19

Oracle 10g supports ____ types of integrity constraints.
A) three
B) four
C) five
D) six

Accepted Answer

Oracle 10g supports five types of integrity constraints: 1) NOT NULL, 2) UNIQUE, 3) PRIMARY KEY, 4) FOREIGN KEY, and 5) CHECK.

Question 20

An index does not have its own storage specification,so it has to be in the same tablespace as the associated table.

Accepted Answer

Indexes can be stored in a different tablespace from the table they are associated with, allowing for more flexible storage management and optimization.

Quiz 9: Constraints, indexes, and Other Specialized Objects

CHECK constraints cannot contain queries or any references to other tables.

A(n) ____ constraint appears immediately next to the column to which it applies.

By default,the initial value of a sequence when it is first created is 0.

The ____ constraint is similar to the PRIMARY KEY constraint because both enforce unique values;the difference is that it allows null values in the column or columns that are named in the constraint.

You can use ALTER INDEX to change the column order of an existing index.

An index does not store an entry for a row when all the indexed columns are null except if the index is a bitmap index.

A ____ is a program that runs when a certain event occurs.

It is possible to create an index owned by one user on a table owned by another user,provided that the creating user has either the CREATE ANY INDEX privilege or the INDEX privilege on the target table,or the user has been granted specific privileges for creating an index on that table.

A bitmap index stores ROWID values and key values.

A(n) ____ constraint appears after the full list of columns in the CREATE TABLE command and is usually used to define constraints to multiple columns.

The ____ constraint enforces a predefined list of values for a column.

____ checking performs faster than other methods of constraint enforcement,because the optimizer has been programmed to handle them efficiently.

____ integrity is the integrity,or soundness of data,maintained between two values,which reference each other.

You can use expressions in function-based indexes.

A bitmap index can be a UNIQUE index.

Placing the ____ constraint on a column indicates that all rows in the table must contain a value in the column.

The syntax for adding a CHECK constraint with CREATE TABLE and ALTER TABLE is quite different.

A(n) ____ integrity constraint is the column or set of columns that define a unique identifying value for every row in the table.

Oracle 10g supports ____ types of integrity constraints.

An index does not have its own storage specification,so it has to be in the same tablespace as the associated table.