DBMS MCQ Multiple Choice Questions Answers | Quiz for Practice

Q: 2. Which of the operations constitute a basic set of operations for manipulating relational data?

Correct Answer is: Relational algebra

Q: 4. Relational calculus is a

Correct Answer is: Non- Procedural language.

Q: 5. Transaction processing is associated with everything below except

Correct Answer is: confirming an action or triggering a response.

Q: 12. Which of the following is a legal expression in SQL?

Correct Answer is: SELECT NAME FROM EMPLOYEE;

Q: 13. AS clause is used in SQL for

Correct Answer is: Rename operation.

Q: 14. The users who use easy-to-use menu are called

Correct Answer is: NaÃ¯ve users.

Q: 15. It is better to use files than a DBMS when there are

Correct Answer is: Multiple users wish to access the data.

Q: 16. An entity set that does not have sufficient attributes to form a primary key is a

Correct Answer is: weak entity set.

Q: 17. A DBMS query language is designed to

Correct Answer is: all of the above.

Q: 18. The DBMS language component which can be embedded in a program is

Correct Answer is: The data manipulation language (DML).

Welcome to our DBMS MCQs section, where you can test your knowledge and prepare for exams, interviews, and more. These multiple-choice questions are designed to help students and exam aspirants master the fundamentals of Database Management Systems.

About DBMS MCQ Questions

DBMS MCQs cover a wide range of topics, including database design, SQL queries, normalization, transaction management, and more. These questions are structured to assess your understanding of core concepts and practical applications in database management.

Why Practice DBMS Objective Questions?

Practicing DBMS MCQs can significantly enhance your preparation for various exams and interviews. They help reinforce your knowledge, improve your problem-solving skills, and boost your confidence. Regular practice also aids in quick revision and ensures you are well-prepared for any challenge.

Who Should Use These MCQs?

Students preparing for school or college exams
Competitive exam aspirants
Candidates preparing for interviews

DBMS MCQ Questions for Practice

1. _____________ function divides one numeric expression by another and returns theremainder.

POWER
MOD
ROUND
REMAINDER

2. Which of the operations constitute a basic set of operations for manipulating relational data?

Predicate calculus
Relational calculus
Relational algebra
None of the above

3. Key to represent relationship between tables is called

Primary key
Secondary Key
Foreign Key
None of these

4. Relational calculus is a

Procedural language.
Non- Procedural language.
Data definition language.
High level language.

5. Transaction processing is associated with everything below except

producing detail, summary, or exception reports.
recording a business activity.
confirming an action or triggering a response.
maintaining data.

6. Which of the following operation is used if we are interested in only certain columns of atable?

PROJECTION
SELECTION
UNION
JOIN

7. _________ data type can store unstructured data

RAW
CHAR
NUMERIC
VARCHAR

8. In an E-R diagram attributes are represented by

rectangle.
square.
ellipse.
triangle.

9. In an E-R diagram an entity set is represent by a

rectangle.
ellipse.
diamond box.
circle.

10. A file manipulation command that extracts some of the records from a file is called

SELECT
PROJECT
JOIN
PRODUCT

11. A data manipulation command the combines the records from one or more tables is called

SELECT
PROJECT
JOIN
PRODUCT

12. Which of the following is a legal expression in SQL?

SELECT NULL FROM EMPLOYEE;
SELECT NAME FROM EMPLOYEE;
SELECT NAME FROM EMPLOYEE WHERE SALARY = NULL;
None of the above

13. AS clause is used in SQL for

Selection operation.
Rename operation.
Join operation.
Projection operation.

14. The users who use easy-to-use menu are called

Sophisticated end users.
NaÃ¯ve users.
Stand-alone users.
Casual end users.

15. It is better to use files than a DBMS when there are

Stringent real-time requirements.
Multiple users wish to access the data.
Complex relationships among data.
All of the above.

16. An entity set that does not have sufficient attributes to form a primary key is a

strong entity set.
weak entity set.
simple entity set.
primary entity set.

17. A DBMS query language is designed to

support end users who use English-like commands.
support in the development of complex applications software.
specify the structure of a database.
all of the above.

18. The DBMS language component which can be embedded in a program is

The data definition language (DDL).
The data manipulation language (DML).
The database administrator (DBA).
A query language.

19. Which one of the following statements is false?

The data dictionary is normally maintained by the database administrator.
Data elements in the database can be modified by changing the data dictionary.
The data dictionary contains the name and description of each data element.
The data dictionary is a tool used exclusively by the database administrator.

20. A subschema expresses

the logical view.
the physical view.
the external view.
all of the above.

21. A data dictionary is a special file that contains:

The name of all fields in all files.
The width of all fields in all files.
The data type of all fields in all files.
All of the above.

22. NULL is

the same as 0 for integer
the same as blank for character
the same as 0 for integer and blank for character
not a value

23. Hierarchical model is also called

Tree structure
Plex Structure
Normalize Structure
Table Structure

24. The RDBMS terminology for a row is

tuple.
relation.
attribute
degree

25. In a relational model, relations are termed as

Tuples.
Attributes
Tables.
Rows.

26. Architecture of the database can be viewed as

two levels.
four levels.
three levels.
one level.

27. What is a relationship called when it is maintained between two entities?

Unary
Binary
Ternary
Quaternary

28. Cross Product is a:

Unary Operator
Ternary Operator
Binary Operator
Not an operator

29. Which of the following operations need the participating relations to be unon compatible?

UNION
INTERSECTION
DIFFERENCE
All of the above

30. To delete a particular column in a relation the command used is:

UPDATE
DROP
ALTER
DELETE