DBMS MCQ Questions & Answers
1. A collection of related data is known as ____________ .
a) Information
b) Valuable Information
c) Database
d) Metadata
2. DBMS stands for _______________.
a) Daily Management System
b) Database Management System
c) Database Master System
d) Database Management Structure
3. Which is a place where data can be stored in a structured manner?
a) CPU
b) Database
c) ALU
d) All of these
4. A database is complex ___________ .
a) Data Structure
b) Memory
c) Both
d) None
5. Administrative Supervision of database is the responsibility of _____ .
a) DP Administrator
b) DP Manager
c) DB Manager
d) Database Administrator
6. DBA stands for ______________ .
a) Database Associated
b) Database Administrator
c) Database Application
d) None of these
7. Data Dictionary tells _________ to the DBMS.
a) What files are in the database
b) What these files contain
c) What attributes are possessed by the data
d) All of the above
8. Before Use of DBMS information was stored using ___________.
a) Cloud Storage
b) Data System
c) File Management System
d) None of Above
9. ___________ is a collection of programs performing all necessary action associated with a database.
a) Database Administrator
b) Database Application
c) Database Associated
d) Database Management System
10. Database is an organized collection of related ……….
a) Data
b) Modules
c) Programs
d) None of Above
11. DBMS is a software that interacts with the _____________ and the database.
a) User’s application programs
b) User’s system programs
c) User’s system database
d) None of Above
12. Keys involved in relationship between tables is called ____________ .
a) Primary Key
b) Secondary Key
c) Foreign Key
d) A and B
13. How many Primary keys can have in a table?
a) Only 1
b) Only 2
c) Depends on number of columns
d) Depends on DBA
14. Related fields in a database are grouped to form a
a) Data File
b) Data Record
c) Menu
d) None of Above
15. DBMS helps to achieve
a) Data independence
b) Centralized control of data
c) Both A and B
d) None of the above
16. A software system that enables users to define, create, maintain, and control Access to the database.
a) Database Management System
b) Data Management
c) Filing system
d) Record
17. Which data model define how the data is actually stored
a) Logical model
b) External model
c) Internal model
d) none of these
18. Data about data is called
a) Directory
b) Data Bank
c) Meta Data
d) None of the above
19. Select the DBMS, which provide supports full-fledged client server application development
a) dBASEIV
b) Ingress
c) FoxPro 2.1
d) Oracle 7.1
20. In database a top-to-bottom relationship between the items is formed by a
a) Relational schema
b) Network schema
c) Hierarchical schema
d) All of the above
21. Which level of data abstraction define how the data is actually stored is
a) Conceptual level
b) File level
c) Physical level
d) None of these
22. Which statement is correct about data model:
a) Set of basic operations on the database
b) Used to describe structure of a database
c) Both A and B
d) All of the above
23. Identify property of an entity
a) Attribute
b) Table
c) Groups
d) Switch Boards
24. DBMS will act as an __________ between the users and the database
a) Barrier
b) Obstacle
c) Referee
d) Interface
25. An advantage of the database management approach is
a) Data is dependent on programs
b) Data redundancy increases
c) Data is integrated and can be accessed by multiple programs
d) None of the above
26. Which type of information is used by the top level managers
a) Operational information
b) Strategic information
c) Both [A] and [B]
d) Technical information