Database Systems Questions

MCQ bookmark_border

81.

In the DBM approach, application programs perform the

A

storage function

B

processing functions

C

access control

D

All of the above

E

None of the above

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

82.

In SQL, which command is used to create a database user?

A

ADD USER TO DATABASE

B

MK USER

C

CREATE USER

D

All of the above

E

None of the above

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

83.

When performing a look-up operation using a form

A

you enter the search value into the form

B

you look at each form sequentially until you see the one you want

C

you type the key in an entry line, and the correct form is displayed

D

All of the above

E

None of the above

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

84.

A _____ means that one record in a particular record type is related to only one record of another record type.

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: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

85.

A _____ database does not use pointers or physical links, but instead finds related records by examining the contents of fields.

A

Network

B

Hierarchical

C

Relational

D

Object-Oriented

E

None of the above

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

86.

In SQL, which command(s) is(are) used to redefine an index's future storage allocation

A

ALTER INDEX

B

REDEFINE INDEX

C

MODIFY INDEX

D

DO INDEX

E

None of the above

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

87.

Which of the following is a serious problem of file management systems?

A

difficult to update

B

lack of data independence

C

data redundancy

D

program dependence

E

All of the above

Correct Answer: E

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

88.

With respect to data input, the most accurate description of batch control is

A

dividing documents to be entered into batches

B

controlling the input of each input clerk

C

comparing to a pre-calculated figure the total of a data item summed across a batch records put into the system

D

All of the above

E

None of the above

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

89.

The model for a _____ resembles the hierarchical model in many respects.

A

Network database

B

Relational database

C

Distributed database

D

Hierarchical database

E

None of the above

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

90.

A set of programs that handle a firm's data base responsibilities is called a

A

Data Base Management System (DBMS)

B

Data Base Processing System (DBPS)

C

Data Management System (DMS)

D

All of the above

E

None of the above

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion