Database MCQ

Database MCQ

1-The database management system (DBMS) is the software that interacts with ___ to capture and analyze the data.

(A) end users

(B) applications

(C) the database

(D) all of the above

 

2- ___ is the creation, modification and removal of definitions that define the organizations of the data.

(A) Data definition

(B) Update

(C) Retrieval

(D) Administration

 

3- ___ is insertion, modification, and deletion of the actual data.

(A) Data definition

(B) Update

(C) Retrieval

(D) Administration

 

4- ___ refers collectively to the Database model, database management system, and database, collectively refers to

(A) Database system

(B) Database management

(C) Database administration

(D) None of the above

 

5-Database servers are

(A) dedicated computers

(B) multiprocessor computers

(C) computers with generous memory and RAID disk arrays

(D) all of the above

 

6-Which of the following is (are) Database management system (DBMS)

(A) Oracle

(B) Microsoft SQL Server

(C) MySQL

(D) All of the above

 

7-In which of the databases, both the database and most of its DBMS reside remotely

(A) in-memory database

(B) active database

(C) cloud database

(D) all of the above

 

8-Which of the following is (are) the major parallel DBMS architecture?

(A) Shared memory architecture

(B) Shared disk architecture

(C) Shared nothing architecture

(D) all of the above

 

9-Which of the following databases employ fuzzy logic to draw inferences from imprecise data.

(A) Real-time database

(B) spatial database

(C) probabilistic database

(D) temporal database

 

10-OODBMS stands for

(A) Object Oriented Database management system

(B) Object Operational Database management system

(C) Open Oriented Database management system

(D) none of the above

 

ANSWERS:

1-(D), 2-(A), 3-(B), 4-(A), 5-(D), 6-(D), 7-(C), 8-(D), 9-(C), 10-(A)