Database Systems Questions

MCQ bookmark_border

61.

In a large DBMS

A

each user can "see" only a small part of the entire database

B

each user can access every sub

C

each subschema contains every field in the logical schema

D

All of the above

E

None of the above

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

62.

Which of the following command(s) is(are) used to recompile a stored procedure in SQL?

A

COMPILE PROCEDURE

B

ALTER PROCEDURE

C

MODIFY PROCEDURE id) All of the above

D

None of the above

E

None of the above

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

63.

Internal auditors should review data system design before they are

A

developed

B

implemented

C

modified

D

All of the above

E

None of the above

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

64.

A _____ means that one record in a particular record type may be related to more than 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: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

65.

Which command(s) is(are) used to redefine a column of the table in SQL ?

A

ALTER TABLE

B

DEFINE TABLE

C

MODIFY TABLE

D

All of the above

E

None of the above

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

66.

Which command(s) is(are) used to enable/disable/drop an integrity constraint in SQL?

A

DEFINE TABLE

B

MODIFY TABLE

C

ALTER TABLE

D

All of the above

E

None of the above

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

67.

In SQL, the ALTER TABLESPACE command is used

A

to add/rename data files

B

to change storage characteristics

C

to take a tablespace online/offline

D

to begin/end a backup

E

All of the above

Correct Answer: E

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

68.

The language used in application programs to request data from the DBMS is referred to as the

A

DML

B

DDL

C

query language

D

All of the above

E

None of the above

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

69.

A database management system might consist of application programs and a software package called

A

FORTRAN

B

AUTOFLOW

C

BPL

D

TOTAL

E

None of the above

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

70.

An audit trail

A

is used to make back-up copies

B

is the recorded history of operations performed on a file

C

can be used to restore lost information

D

All of the above

E

None of the above

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion