Database Systems MCQ Questions & Answers

1

A report generator is used to

A) update files B) print files on paper C) data entry D) All of the above E) None of the above

Discuss

Answer & Solution

Answer: Option B

No explanation is given for this question. Let's Discuss on Board

2

Which of the following is not a logical data-base structure?

A) tree B) relational C) network D) chain E) All of the above

Discuss

Answer & Solution

Answer: Option D

No explanation is given for this question. Let's Discuss on Board

3

Which of the following is a database administrator's function?

A) database design B) backing up the database C) performance monitoring D) user coordination E) All of the above

Discuss

Answer & Solution

Answer: Option E

No explanation is given for this question. Let's Discuss on Board

4

Primitive operations common to all record management systems include

A) Print B) Sort C) Look-up D) All of the above E) None of the above

Discuss

Answer & Solution

Answer: Option C

No explanation is given for this question. Let's Discuss on Board

5

Each of data files has a _____ that describe the way the data is stored in the file.

A) File structure B) Records C) Fields D) Database E) None of the above

Discuss

Answer & Solution

Answer: Option A

No explanation is given for this question. Let's Discuss on Board

6

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

Discuss

Answer & Solution

Answer: Option B

No explanation is given for this question. Let's Discuss on Board

7

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

Discuss

Answer & Solution

Answer: Option B

No explanation is given for this question. Let's Discuss on Board

8

Data item characteristics that are important in data management include

A) punctuation B) language C) spelling D) width E) None of the above

Discuss

Answer & Solution

Answer: Option D

No explanation is given for this question. Let's Discuss on Board

9

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

Discuss

Answer & Solution

Answer: Option C

No explanation is given for this question. Let's Discuss on Board

10

Periodically adding, changing and deleting file records is called file

A) Updating B) upgrading C) restructuring D) renewing E) None of the above

Discuss

Answer & Solution

Answer: Option A

No explanation is given for this question. Let's Discuss on Board

Database Systems MCQ Questions & Answers | Computer Science