(A) It is on a set of fields that include the primary key
(B) It is on a set of fields that form a candidate key
(C) The data records of the file are organized in the same order as the data entries of the index.
(D) None of the above
Tag: DBMS Mcq
A file is organized so that the ordering of data records is the same as or close to the ordering of data entries in some index. Then that index is called?
(A) Clustered
(B) Unclustered
(C) Sparse
(D) Dense
Indexes whose search key specifies an order different from the sequential order of the file are called __ indexes.
(A) Secondary
(B) Non clustered
(C) Both of the above
(D) None of the above
Fast access to data items can be provided through?
(A) Data files
(B) Indexes
(C) Meta data files
(D) Data dictionary
Data which improves the performance and accessibility of the database are called?
(A) User data
(B) Indexes
(C) Data Dictionary
(D) Application Metadata
A clustering index is defined on the fields which are of type?
(A) Non key and ordering
(B) Non key and non ordering
(C) Key and ordering
(D) Key and non ordering
Which database object does not physically exist?
(A) Index
(B) View
(C) Base table
(D) None of the above
Report generator is used to?
(A) Delete files
(B) Data entry
(C) Update files
(D) Print files on paper