database mcq5

Question: 1

A collection of interrelated records is called a

(A) Database

(B) Spreadsheet

(C) Management information system

(D) Text file

Ans: A

Database

Question: 2

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

Ans: A

Sequential access method

Question: 3

Unlike filters queries can be saved as in a database.

(A) Database

(B) Filters

(C) Objects

(D) Any of the above

Ans: C

Objects

Question: 4

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

Ans: A

Database created using DBMS package

Question: 5

ROLLBACK in a database is ____ statement.

(A) DDL

(B) DML

(C) DCL

(D) TCL

Ans: D

TCL


Question: 6

Report generators are used to

(A) Store data input by a user

(B) Retrieve information from files

(C) Answer queries

(D) Both (b) and (c)

Ans: D

Both (b) and (c)

Question: 7

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

(A) Tree

(B) Chain

(C) Network

(D) All of these

Ans: A

Tree

Question: 8

In a database, related fields are grouped to

(A) File

(B) Bank

(C) Menu

(D) Data record

Ans: D

Data record

Question: 9

The database environment has all the following components except

(A) Database administrator

(B) Database

(C) Users

(D) Separate files

Ans: D

Separate files

Question: 10

Which database handles full text data, image, audio and video?

(A) Multimedia database

(B) Video on demand database

(C) Graphics database

(D) Transaction database

Ans: A

Multimedia database