Selection Operation

1.

Which algorithm uses equality comparison on a key attribute with a primary index to retrieve a single record that satisfies the corresponding equality condition.

   A.) A2
   B.) A4
   C.) A5
   D.) A6

Answer: Option 'A'

A2

2.

Index structures are referred to as ____________, since they provide a path through which data can be located and accessed.

   A.) Index Search
   B.) Linear search
   C.) File scan
   D.) Access paths

Answer: Option 'D'

Access paths

3.

The ___ algorithm scans each index for pointers to tuples that satisfy an individual condition.

   A.) A2
   B.) A4
   C.) A9
   D.) A6

Answer: Option 'C'

A9

4.

The strategy can retrieve a single record if the equality condition is on a key;multiple records may be retrieved if the indexing field is not a key is

   A.) A2
   B.) A4
   C.) A5
   D.) A6

Answer: Option 'B'

A4

5.

In a _______________, the system scans each file block and tests all records to see whether they satisfy the selection condition.

   A.) Index Search
   B.) Linear search
   C.) File scan
   D.) Access paths

Answer: Option 'B'

Linear search

Selection Operation Download Pdf