Question # 1

What is the alternate name of Data Dictionary?

Choose an answer

Index

Metadata

Data

System Catalog

Which feature of database provides conversion from inconsistent state of DB to a consistent state ensuring minimum data loss?

Choose an answer

User accessible catalog

Data processing

Authorization service

Recovery service

_______ records data by burning microscopic holes in the surface of the disk with a laser.

Choose an answer

Hard disk

RAM

Optical disk

Floppy disk

Which of the following is disadvantage of chaining technique to handle the collisions?

Choose an answer

Unlimited Number of elements

Fast re-hashing

Overhead of multiple linked lists

Maximum number of elements must be known

In SQL queries, while creating tables or relations in database, key columns may be specified by

Choose an answer

Data type

Null

Not Null

Owner

A ____ relationship exists when an association is maintained within a single entity.

Choose an answer

unary

ternary

binary

weak

In which of the following situations, Clustering is suitable:

Choose an answer

Frequently updating

Relatively static

Relatively deletion

Relatively dynamic

Which of the following is true about relational schema?

Choose an answer

The sequence of columns is significant

The sequence of rows is significant.

Contains only derived attributes.

Values are atomic

Which of the following is NOT a feature of HASH ACCESS?

Choose an answer

indexes to search or maintain

Very fast direct access

Inefficient sequential access

Use when direct access is needed, but sequential access is not.

Which of the following is correct?

Choose an answer

The relation Interview is in 3NF

The relation Interview is in BCNF.

The FD3 violates 3NF.

The FD2 violates 2NF

What is the maximum limit of keys in context with Indexed sequential files?

Choose an answer

7

255

1

235

More Classes

Other Links

CS-403 Final Term Exams Preparation Virtual University MCQs With Answers

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer