Introduction to database systems: Approaches to building a database, Three-tier

architecture of a database, Challenges in building a DBMS, DBMS Architecture, Various

components of a DBMS, Types of Data models.

Sr. Question Options Answer

No.
1. Which of the following is a. DML(Data Manipulation d. DDL(Data
generally used for performing
tasks like creating the structure Language) Definition
of the relations, deleting b. b. Query Language)
relation? c. Relational Schema
d. DDL(Data Definition
Language)

2. Which of the following a. DML(Data Manipulation a. DML(Data

provides the ability to query
information from the database Language) Manipulation
and insert tuples into, delete b. DDL(Data Definition Language)
tuples from, and modify tuples
in the database? Language)
c. Query
d. Relational Schema

3. What is DBMS? a. DBMS is a d.DBMS stores,

collection of queries modifies and
b. DBMS is a high- retrieves data
level language
c. DBMS is a
programming
language
d. DBMS stores,
modifies and
retrieves data
4. A collection of tables to a. Entity b. relational model
represent both data and the relationship
relationships among data, is model
known as b. Relationship
c. Object based
data model
 d. Semi structured
model
5. The preface that converts the a. DML pre- d. DML precompiler
DML statements to normal executer
procedure calls in the host b. DML
language is known as executer
c. DML
compiler
d. DML
precompiler
6. The storage manager a. Buffer manager a. Buffer
component who decides what b. File manager manager
data to cache in main memory c. Transaction manager
is referred as d. Authorization and
integrity manager
7. Who created the first DBMS? a. Edgar Frank Codd b. Charles
b. Charles Bachman Bachman
c. Charles Babbage
d. Sharon B. Codd
8. In which of the following a. Image c. Table
formats data is stored in the b. Text
database management system? c. Table
d. Graph
9. Which of the following can be c. data
used to extract or filter the data a. Data redundancy mining
& information from the data b. Data recovery tool
warehouse? c. Data mining
d. Both B and C

10. Which one of the following

refers to the copies of the same a. Data Repository d. Data Redundancy
data (or information) occupying b. Data Inconsistency
the memory space at multiple
places. c. Data Mining
d. Data Redundancy

11. Which of the following refers

to the level of data abstraction a. Conceptual Level b. Physical
that describes exactly how the b. Physical Level Level
data actually stored?
c. File Level
 d. Logical Level

12. To which of the following the

term "DBA" referred? a. Data Bank b. Database
Administrator Administrator
b. Database
Administrator
c. Data Administrator
d. None of the above

13. In general, a file is basically a

collection of all related______. a. Rows & Columns d. Records
b. Fields
c. Database
d. Records

14. The term "Data" refers to:

a. The electronic c. Row Facts and
representation of the figures
information( or data)
b. Basic information
c. Row Facts and
figures
d. Both A and C

15. Rows of a relation are known as

the _______. a. Degree d. All of the above
b. Tuples
c. Entity
d. All of the above
16. Which of the following refers
to the number of tuples in a a. Entity c. Cardinality
relation? b. Column
c. Cardinality
d. None of the above

17. Which one of the following is a

type of Data Manipulation a. Create c. delete
Command? b. Alter
c. Delete
d. All of the above

18. Which of the following

command is a type of Data a. Create a. Create
Definition language command? b. Update
c. Delete
d. Merge

19. Which of the following is a top-

down approach in which the a. Aggregation c. Specialization
entity's higher level can be b. Generalization
divided into two lower sub-
entities? c. Specialization
d. All of the above

20. The term "TCL" stands

for_____. a. Ternary Control d. Transaction
Language Control Language
b. Transmission
Control Language
c. Transaction Central
Language
 d. Transaction Control
Language

21. Which of the following is used

in the application programs to a. Data Manipulation a. Data
request data from the database language Manipulation
management system? language
b. Data Definition
Language
c. Data Control
Language
d. All of the above

22. The term "SQL" stands for

a. Standard query c. Structured query
language language
b. Sequential query
language
c. Structured query
language
d. Server-side query
language

23. The term "Data independence"

refers to____ a. Data is defined d. Both B & C
separately and not included
in the programs
b. Programs are not
dependent on the
logical attributes of
the data
c. Programs are not
dependent on the
 physical attributes of
the data
d. Both B & C

24. Which one of the following

refers to the total view of the a. Conceptual view a. Conceptual
database content? b. Physical view view

c. Internal view
d. External view

25. The architecture of a database

can be viewed as the ________ a. One level c. Three-level
b. Two-level
c. Three-level
d. Four level

26. Which of the following levels is

considered as the level closed a. Internal Level b. External
to the end-users? b. External Level Level

c. Conceptual Level
d. Physical Level

27. Which one of the following is

commonly used to define the a. Application program c. schema
overall design of the database? b. Data definition
language
c. Schema
d. Source code

28. DDL stands for what a. Database Definition a. Database

Level Definition
Level
 b. Data Definition
Language
c. Data Device Latency
d. None of the above

29. An advantage of the database a. Data is dependent on c. Data is integrated

management approach is programs and can be accessed
b. Data by multiple programs
redundancy increases
c. Data is integrated and
can be accessed by
multiple programs
d. None of the above

30. Which two files are used during a. Query languages and c. Data
operation of the DBMS utilities dictionary and
b. DML and query transaction log
language
c. Data dictionary and
transaction log
d. None of the above