1) DML stand for?

1. Database Manipulation Language

2. Data Markup Language
3. Data Manipulation Language
4. Data Manipulation List
Answer
Correct Answer - 3

Data Manipulation Language

2) DDL stand for?

1. Data Definition Language

2. Data Design Language
3. Database Definition Language
4. Data Definition List
Answer
Correct Answer - 1

Data Definition Language

3) DCL stand for?

1. Database Control Language

2. Data Conditional Language
3. Database Conditional Language
4. Data Control Language
Answer
Correct Answer - 4

Data Control Language

4) TCL stand for?

1. Transaction Control Language

2. Transmission Control Language
3. Transfer Control Language
4. None of these
Answer
Correct Answer - 1

Transaction Control Language

5) DQL stand for?

1. Database Query Language

2. Data Query Language
3. Definition Query Language
4. None of these
Answer
Correct Answer - 2

Data Query Language

6) INSERT, UPDATE and DELETE statements belong to

1. DQL Language
2. DDL Language
3. DCL Language
4. DML Language
Answer
Correct Answer - 4

DML Language

7) CREATE, ALTER, DROP and TRUNCATE statements belong to

1. DQL Language
2. DDL Language
3. DCL Language
4. DML Language
 Answer
Correct Answer - 2

DDL Language

8) SQL QUERY statements belong to

1. DQL Language
2. DDL Language
3. DCL Language
4. DML Language
Answer
Correct Answer - 1

DQL Language

9) GRANT and REVOKE statements belong to

1. DQL Language
2. DDL Language
3. DCL Language
4. DML Language
Answer
Correct Answer - 2

DCL Language

10) COMMIT and ROLLBACK statements belong to

1. TCL Language
2. DDL Language
3. DCL Language
4. DML Language
Answer
Correct Answer - 1
 TCL Language

11) Data Dictionary contains?

1. Data about data (Meta Data)

2. SQL QUERY
3. Both 1 and 2
4. None of these
Answer
Correct Answer - 1

Data about data (Meta Data)

12) Physical Level of database contains?

1. Searching Techniques
2. Sorting Techniques
3. Data Schemas
4. All of the above
Answer
Correct Answer - 4

All of the above

13) Logical Level of database is also known as?

1. Sub Schema
2. Schema
3. Attribte set
4. All of the above
Answer
Correct Answer - 2

Schema

14) External Level of database is also known as?

1. Sub Schema
2. Schema
3. Attribte set
4. All of the above
Answer
Correct Answer - 1

Sub Schema

15) What is Schema?

1. To identify the record uniquely

2. To normalize the database
3. Overall description of the database
4. To reduce data redundancy
Answer
Correct Answer - 3

Overall description of the database

16) What is Data Independency?

1. To reduce inconsistency
2. Changes at one level of database does not reflect at other level
3. Changes at one level of database reflects at other level
4. Both 1 and 2
Answer
Correct Answer - 2

Changes at one level of database does not reflect at other level

17) What is Physical Data Independency?

1. Changes at physical level of database does not reflect at logical

level
2. Changes at physical level of database reflects at logical level
3. To view record using select statement
4. To implement normalization to remove data redundancy
Answer
Correct Answer - 1

Changes at physical level of database does not reflect at logical level

18) What is Logical Data Independency?

1. Changes at logical level of database does not reflect at view level

2. Changes at logical level of database reflects at view level
3. To handle multiple records
4. To create data dictionary
Answer
Correct Answer - 1

Changes at physical level of database does not reflect at logical level

19) Attribute is also known as?

1. Tuple
2. Entity
3. Row
4. Column
Answer
Correct Answer - 4

Column

20) Record is also known as?

1. Tuple
2. Entity
3. Row
4. Column
Answer
Correct Answer - 1

Tuple

1. A collection of related data.

a) Information
b) Valuable information
c) Database
d) Metadata
View Answer
Answer: c
Explanation: Database is the collection of related data and its metadata organized in a structured
format. It is designed for optimized information management.
2. DBMS is software.
a) True
b) False
View Answer
Answer: a
Explanation: The statement is true. DBMS stands for Database Management System. It enables
easy creation and access of the database.
3. DBMS manages the interaction between __________ and database.
a) Users
b) Clients
c) End Users
d) Stake Holders
View Answer
Answer: c
Explanation: DBMS manages the interaction between the end users and the database. End
users are the final users that interact with the database.
4. Which of the following is not involved in DBMS?
a) End Users
b) Data
c) Application Request
d) HTML
View Answer
Answer: d
Explanation: HTML isn’t involved in Database Management System. Other things like the data
and application request are a part of the DBMS.
5. Database is generally __________
a) System-centered
b) User-centered
c) Company-centered
d) Data-centered
View Answer
Answer: b
Explanation: Database is user-centered. The perspective is that the user is always right. If there
is a problem with the use of the system, the system is the problem, not the user.
6. A characteristic of an entity.
a) Relation
b) Attribute
c) Parameter
d) Constraint
View Answer
Answer: b
Explanation: An attribute is a characteristic of an entity. The association among the entities is
described by the relationship.
7. The restrictions placed on the data.
a) Relation
b) Attribute
c) Parameter
d) Constraint
View Answer
Answer: d
Explanation: Constraint is a restriction that is placed on the data. Attribute is the characteristic
and the relation describes the association.
8. IMS stands for?
a) Information Mastering System
b) Instruction Management System
c) Instruction Manipulating System
d) Information Management System
View Answer
Answer: d
Explanation: IMS stands for Information Management System. It is developed to manage large
amounts of data for complex projects.
9. A model developed by Hammer and McLeod in 1981.
a) SDM
b) OODBM
c) DDM
d) RDM
View Answer
Answer: a
Explanation: SDM stands for Semantic Data Model. It models both data and their relationships in
a single structure.
10. Object=_________+relationships.
a) data
b) attributes
c) entity
d) constraints
View Answer
Answer: c
Explanation: The answer is entity. It is a part of OODBM (Object-Oriented Database Model). It
maintains the advantages of ER-model but adds more features.

1. DBMS is a set of __________ to access the data.

a) Codes
b) Programs
c) Information
d) Metadata
View Answer
Answer: b
Explanation: Database is a set of programs designed to access the data. It contains information
about a particular enterprise.
2. DBMS provides a convenient and efficient environment.
a) True
b) False
View Answer
Answer: a
Explanation: The statement is true. DBMS stands for Database Management System. It provides
an efficient and easy to use environment.
3. Which of the following isn’t a level of abstraction?
a) physical
b) logical
c) user
d) view
View Answer
Answer: c
Explanation: There are three levels of abstraction: physical, logical and the view level. These
three levels are involved in DBMS.
4. A level that describes how a record is stored.
a) physical
b) logical
c) user
d) view
View Answer
Answer: a
Explanation: The answer is physical. The physical level describes how the record gets stored.
e.g. Customer.
5. The ______level helps application programs hide the details of data types.
a) physical
b) logical
c) user
d) view
View Answer
Answer: d
Explanation: The application programs hide details of datatypes. Views can also hide information
for security purposes.
6. A logical structure of the database.
a) Schema
b) Attribute
c) Parameter
d) Instance
View Answer
Answer: a
Explanation: A schema is the logical structure of the database. e.g A set of customers and
accounts and their relationship.
7. The actual content in the database at a particular point.
a) Schema
b) Attribute
c) Parameter
d) Instance
View Answer
Answer: d
Explanation: The answer is Instance. Instance is the actual content of the database at a
particular point of time.
8. Which of the following is not an object-based logical model?
a) ER
b) Network
c) Semantic
d) Functional
View Answer
Answer: b
Explanation: Network model is a part of record-based logical model and not object-based. Others
are object based models. ER stands for Entity-relationship.
9. SQL is _______
a) Relational
b) Network
c) IMS
d) Hierarchical
View Answer
Answer: a
Explanation: SQL or structured query language is a relational model. It comes under record-
based logical models.
10. A level that describes data stored in a database and the relationships among the data.
a) physical
b) logical
c) user
d) view
View Answer
Answer: b
Explanation: The answer is logical. The logical level describes the relationships between the
data. Physical level describes how the data is stored.