DBMS-QUIZ

The database administrator is, in effect, the coordinator between them ____ and the ____

• (A) Database, users

• (B) Application program; database

• (C) DBMS; database

• (D) Application programs; users

Where will we find the referential integrity command?

• (A) Table

• (B) Tools

• (C) Format

• (D) None of these

Which of the following component of a computer system is the most important to a database management system?

• (A) High speed, large capacity disk

• (B) High resolution video display

• (C) Mouse

• (D) Printer

In a relational schema, each tuple is divided into fields called

• (A) Domains

• (B) Queries

• (C) Relations

• (D) None of these

An indexing operation

• (A) Establishes an index for a file

• (B) Sorts a file using two keys

• (C) Sorts a file using a single key

• (D) Both (b) and (c)

The modify operation is likely to be done after

• (A) Insert

• (B) Delete

• (C) Look-up

• (D) None of these

The method of file organization in which data records in a file are arranged in a specified order according to key field is known as the

• (A) Sequential access method

• (B) Queuing method

• (C) Predetermined method

• (D) Direct access method

External database is

• (A) Database created using DBMS package

• (B) Database created in MS-Word

• (C) Database created in EXCEL

• (D) All of the above

ROLLBACK in a database is ____ statement.

• (A) DDL

• (B) DML

• (C) DCL

• (D) TCL

The logical data structure with a one-to-many relationship is a

• (A) Tree

• (B) Chain

• (C) Network

• (D) All of these