Database Systems Questions

MCQ bookmark_border

121.

Data items grouped together for storage purposes are called a

A

record

B

title

C

list

D

string

E

None of the above

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

122.

The activity of a file

A

is a low percentages of number of records added or deleted from a file

B

if high, reduces processing efficiency for sequential and nonsequential files

C

is a measure of the percentage of existing records updated during a run

D

refers to how closely the files fits into the allocated

E

None of the above.

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

123.

Versatile report generators can provide

A

Columnar totals

B

Subtotals

C

Calculations

D

All of the above

E

None of the above

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

124.

Related fields in a data base are grouped to form

A

data file

B

data record

C

menu

D

bank

E

None of the above

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

125.

A _____ means that one record in a particular record type can be related to many records in another record type and vice-versa.

A

One-to-one relationship

B

One-to-many relationship

C

Many-to-one relationship

D

Many-to-many relationship

E

None of the above

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

126.

In SQL, the _____ command is used to recompile a view

A

COMPILE VIEW

B

DEFINE VIEW

C

CREATE VIEW

D

ALTER VIEW

E

None of the above

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

127.

A list in alphabetical order

A

is in descending order

B

is in ascending order

C

is the result of a sort operation

D

both (b) and (c)

E

None of the above

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

128.

If a piece of data is stored in two places in the database, then

A

storage space is wasted

B

changing the data is one spot will cause data inconsistency

C

it can be more easily accessed

D

both (a) and (b)

E

None of the above

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

129.

A data dictionary is a special file that contains

A

the names of all fields in all files

B

the data types of all fields in all files

C

the widths of all fields in all files

D

All of the above

E

None of the above

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

130.

A file that is organized in uniform format is formally referred to as a _____ or a database file.

A

Document

B

Database

C

Record

D

Structured data file

E

None of the above

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion