Database Systems Questions

MCQ bookmark_border

11.

After you _____ a record, many data management the environments require you to issue a command to save the changes you made.

A

Delete

B

Update

C

Sort key

D

Index

E

None of the above

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

12.

What is the language used by most of the DBMSs for helping their users to access data?

A

High level language

B

Query language

C

SQL

D

4GL

E

None of the above

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

13.

Data item characteristics that are important in data management include

A

punctuation

B

language

C

spelling

D

width

E

None of the above

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

14.

In SQL, which command is used to make permanent changes made by statements issue since the beginning of a transaction?

A

ZIP

B

PACK

C

COMMIT

D

SAVE

E

None of the above

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

15.

Periodically adding, changing and deleting file records is called file

A

Updating

B

upgrading

C

restructuring

D

renewing

E

None of the above

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

16.

Sort/report generators

A

are faster than index/report generators

B

require more disk space than index/report generators

C

do not need to sort before generating a report

D

both (a) and (b)

E

None of the above

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

17.

The data dictionary tells the DBMS

A

what files are in the database

B

what attribute are possessed by the data

C

what these files contain

D

All of the above

E

None of the above

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

18.

In SQL, which command(s) is(are) used to enable/disable a database trigger?

A

MODIFY USER

B

CHANGE USER

C

ALTER TRIGGER

D

All of the above

E

None of the above

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

19.

If the record management system allows you to edit values before they are recorded on disk, you can

A

correct spelling changes before they are recorded

B

change the name of a field

C

change the width of a field

D

All of the above

E

None of the above

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

20.

The relational model uses some unfamiliar terminology. A tuple is equivalent to a:

A

record

B

field

C

file

D

data base

E

data item

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion