Question

What is a search key in sequential file organization?

(a) A number assigned to each record

(b) Necessarily the primary key

(c) Any attribute or a set of attributes

(d) None of the mentioned

This question was addressed to me by my college professor while I was bunking the class.

My query is from Organization of Records in Files topic in section Storage and File Structure of RDBMS

Answer 1

The correct choice is (c) Any attribute or a set of attributes

Explanation: A search key in sequential file organization is any attribute or a set of attributes that need not be a primary key or even a superkey.