4 Jul 2014

Smu mba database management system sample paper set three











Question: The main disadvantage of the index-sequential file organization isResponse:
The deleted entry may appear ina a non-leaf node.
Application program & DBMS
Should have chosen
Performance degrades as the file grows.
The deleted eltry always appears in aleaf.
Question: What is database index?Response:
A set of programs to access the data in the database.
Should have chosen
A data structure that improves the speed of operations in a table
An index specified by ordering key field.
pointer to a disk block.
Unit-04-4Mark
Question: Suppose we need to insert a record ina a B+ tree of the order n=3 and pleaf = 2. what are the things we observe here?Response:
Every value must exist at the leaf level
Root is the only node in the tree
Should have chosen
both a & b
only b
Question: Response:
Match
Correct Answer
User answer
Feedback

Match
Correct Answer
User answer
Feedback
Secondary Index
An ordered file with two fields.
An ordered file with two fields.
correct
Clustering Index
specified by ordering non-key field of a data.
Indexes with two or more levels
incorrect
Primary Index
Specified by ordering key field
Specified by ordering key field
correct
Multilevel Index
Indexes with two or more levels
specified by ordering non-key field of a data.
incorrect
Question: The first field is of same data type as some non-ordering field of the data file. i.e., indexing field. The second field is either a block pointer or a record pointer. In this case there is one index entry for each record in the data file, which contains the value of the secondary key or record; pointer points to the block in which the record is stored or to the record itself. This is an example ofResponse:
multilevel index
B+tree index files
clustering index
Should have chosen
dense index
Question: _____________ is a pointer to s disk blockResponse:
Correct
second field
first field
clustering index
secondary index
Question: ______________ is of the same data type as the primary key field of the data file.Response:
second field
Should have chosen
first field
clustering index
secondary index
Unit-04-2Mark
Question: A clustering index is an index specified by ordering non-key field of a data. That field is called ________________Response:
First field
Should have chosen
clustering field
second field
dense field
Question: This may have duplicate values.Response:
Secondary index
Correct
clustering index
primary index
multilevel index

No comments:

Post a Comment