Introduction to Database MCQ
1. _______refers
to the basic facts and entities, such as names and numbers.
a. Data
b. Information
c. Input
d. Output
2. Information
is processed from __________
a. Output
b. Data
c. Memory
d. None
of these
3. MIS
stands for:
a. Management
Information Server
b. Management
Information Service
c.
Management
Information System
d. Master
Information System
4. Which
is the false statement:
a. A
database is ordered collection of data.
b. A
database is systematic compilation of records in a computer.
c. DBMS
manages the database
d.
Data helps
in making decisions.
5. Which
is the data model
a. Relational
b. Object-Relational
c. Network
d.
All of these
6. Which
is not the feature of database:
a.
Data
redundancy
b. Independence
c. Flexibility
d. Data
Integrity
7. Which
is the type of data independence:
a. Physical
data independence
b. Logical
data independence
c.
Both
d. None
of these
8. Which
is the feature of database:
a. Query
Language
b. Multi
user access
c. Data
Dictionary
d. All
of these
9. Which
is the advantage of database:
a. Prevents
Data redundancy
b. Restricts
unauthorized access
c. Persistent
storage
d. Backup
and recovery
e. Integrity
Constraints
f.
All of these
10. Which is
the database language:
a. C
b. C++
c.
SQL
d. None
of these
11. Which
person is responsible for overall activities for database:
a. Database
designer
b. Database
analyst
c.
Database
Administrator
d. Database
manager
12. Which level
of database is viewed by user:
a. Internal
level
b.
External
Level
c. Conceptual
Level
d. All
of these
13. Internal
level has:
a. Individual
Users View of the database
b. Community
view of the database
c.
Physical
Representation of the database
d. All
of these
14. Which is
the component of database management system:
a. Query
Language
b. Database
Manager
c. File
manager
d.
All of these
15. ______is
the structure of the database.
a. Table
b. Relation
c.
Schema
d. None
of these
16. Schema is
usually stored in____________.
a. Tables
b.
Data
Dictionary
c. Both
d. None
of these
17. Schema is
defined by:
a. DML
b.
DDL
c. DCL
d. DQL
18. DML language is used to:
a. Define
schema
b. Define
internal level
c.
Access Data
d. All
of these
19. DBMS is the
bridge between operating system and ___________.
a. User
b. Database
administrator
c.
Application
program
d. None
of these
20. Which is
the most popular database model:
a. Network
Model
b.
Relational
Model
c. Hierarchical
Model
d. Object
Oriented
21. Which is
the schema object:
a. Database
links and clusters
b. Packages
and Indexes
c. Procedures
and functions
d.
All of these
22. In database
records are called:
a. Attributes
b. Entity
c.
Tuples
d. Relations
23. An entity
has a set of ___________ that describe it.
a.
Attributes
b. Entity
c. Tuples
d. Relations
24. In ER model
rectangle represents:
a. Attributes
b.
Entity set
c. Relationships
d. None
of these
25. Date is the
type of attribute:
a. Simple
b.
Composite
c. Single
values
d. Multi
valued
26. __________is
the attribute or group of attributes that uniquely identify occurrence of each
entity.
a. Foreign
key
b. Super
Key
c.
Primary Key
d. All
of these
27. _________is the real world object, such as a
person, place etc.
a. Attribute
b.
Entity
c. Records
d. All
of these
28. Grant and
revoke is the type of command:
a. DDL
b. DML
c.
DCL
d. DQL
29. A user that
manages the files of application in DBMS is called:
a. Administrator
b. Database
analyst
c.
File Manager
d. None
of these
30. ________is
the information about data.
a. Data
b.
Meta-Data
c. Entity
d. Relations
