Database Systems Questions

MCQ bookmark_border

111.

One data dictionary software package is called

A

DB/DC dictionary

B

TOTAL

C

ACCESS

D

any of the above

E

None of the above

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

112.

One approach to standardizing storing of data

A

MIS

B

structured programming

C

CODASYL specifications

D

All of the above

E

None of the above

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

113.

What software packages are commonly used for businesses that have to track extensive lists of clients and inventory?

A

Special purpose packages

B

Custom made programs

C

Single function application packages

D

Data management packages

E

None of the above

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

114.

A multiple-form file management system

A

lets you define different forms for different operations

B

lets you create a look-up form with an associated read-only password to prevent access by unauthorized users

C

both (a) and (b)

D

allow you to entry data in all the forms

E

None of the above

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

115.

The term _____ is sometimes used to refer to a data file in which all the records have the same record format, that is, the same field names, field lengths, and data types.

A

Database

B

Table

C

Flat file

D

Data structure

E

None of the above

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

116.

A _____ Contains fields of data about one entity.

A

Record

B

File

C

Fields

D

Document

E

None of the above

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

117.

A condition that led to the development of databases was

A

a demand for more data to support information needs

B

an increase in the amount of data handled by organizations

C

the proliferation of data 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

118.

The _____ command is used to allocates an extent for the table in SQL

A

MODIFY ALLOCATES

B

MODIFY TABLE

C

ALTER TABLE

D

REDEFINE TABLE

E

None of the above

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

119.

Embedded pointer provide

A

a secondary access path

B

a physical record key

C

an inverted index

D

All of the above

E

None of the above

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

120.

Which of the following is a type of DBMS software?

A

database manipulation language

B

query language

C

utilities

D

report writer

E

All of the above

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion