Indexes 2

It ensures that all the values in a column satisfy certain conditions.

• check constraints

• unique constraints

• null constraints

• default constraints

It is an index defined on a primary key column(s) of a relation with unique constraint which guarantees that the field will not contain duplicate values and determine the order of how the records are physically stored on the disk.

• clustered index

• dense index

• Primary index

• Seconary

It is another name given to an index

• Data structure

• Data entity

• Data table

• Query table

Which of these keys is generated automatically when the table is created?

• Primary key

• Secondary key 

• Dense key

• Sparse key

The attribute or set of attributes used to look up a record in a file is called

• Primary key

• Search key

• Candidate key

• Secondary key

In a file containing records which are sequentially ordered, the index whose search key specifies the sequential order of the file is called the

• Primary index

• Secondary index

• Inverted index

• Composite index

Primary indexes, secondary indexes and cluster indexes are all types of 

• ordered indexes

• unordered indexes

• linear indexes

• relative search indexes 

File which has a secondary index for its every field is classified as

• fully inverted file

• fully indexed file

• secondary indexed file

• primary indexed file

Indexes which specify the address of records on disk with a physical pointer are classified as

• structural index

• hashing index

• physical index

• logical index 

The first field in the primary index having the same data type as in ordering field is

• indexed key

• ternary key 

• secondary key

• primary key