Unit 3 : Relational Database Management System (Basic)
Session 1: Appreciate the Concept of Database Management System
Multiple Choice Question
1. A __________ is an organized collection of data.
a. Data
b. Information
c. Database
d. None of these
Answer: c. Database
2. __________ can visualize as a container of information.
a. Data
b. Information
c. Database
d. None of these
Answer: c. Database
3. The _________ is typically organized to model relevant aspects of reality (for example, the availability of rooms in hotels), in a way that supports processes requiring this information (for example, finding a hotel with facilities such as Laundry, GYM etc…).
a. Data
b. Information
c. Database
d. None of these
Answer: a. Data
4. Identify which of the following can be use as database programs to organize the data as per your business need.
a. Microsoft Access
b. OpenOffice.org Base
c. MySQL
d. All of these
Answer: d. All of these
5. DBMS stands for _____________.
a. Data Management System
b. Database Management System
c. Design Base Management System
d. Dual Base Management System
Answer: b. Database Management System
6. A Database Management System allows a person to ____________ from a computer.
a. organize data
b. store data
c. retrieve data
d. All of these
Answer: d. All of these
7. Who is the father of DBMS?
a. Charles W. Bachman
b. EF Code
c. Charles Babbage
d. Blaise Pascal
Answer: a. Charles W. Bachman
8. The database concept has evolved since _________.
a. 1960
b. 1971
c. 1980
d. 1991
Answer: a. 1960
9. A __________ is a software package with computer programs that controls the creation, maintenance, and use of a database.
a. database management system
b. word processor
c. spreadsheet
d. text editor
Answer: a. database management system
10. A _________ is an integrated collection of data records, files, and other objects.
a. data
b. information
c. database
d. All of these
Answer: c. database
11. A database is an _________ collection of data records, files, and other objects.
a. integrated
b. distributed
c. centralized
d. None of these
Answer: a. integrated
12. A ________ allows different user application programs to concurrently access the same database.
a. Server
b. Client
c. DBMS
d. None of these
Answer: c. DBMS
13. Identify which one of the is not a DBMS software.
a. Oracle,
b. IBM DB2
c. Microsoft SQL Server
d. None of these
Answer: d. None of these
14. Identify which one of the is not a DBMS software.
a. Microsoft Word
b. Microsoft Access
c. PostgreSQL
d. MySQL
Answer: a. Microsoft Word
15. Identify which one of the is not a DBMS software.
a. FoxPro
b. Microsoft Access
c. PostgreSQL
d. Corel Draw
Answer: d. Corel Draw
16. Data can be organized into ______ types.
a. 2
b. 3
c. 4
d. 1
Answer: a. 2
