Manipulation & processing of database.

Description of logical structure of database.

Addition of new structures in the database system.

Definition of physical structure of database system.

DBMS MCQ Multiple Choice Questions Answers for Practice

Q: 2. Which of the following is correct:

Correct Answer is: None of these

Q: 3. Cartesian product in relational algebra is

Correct Answer is: a Binary operator.

Q: 4. The result of the UNION operation between R1 and R2 is a relation that includes

Correct Answer is: all the tuples of R1 and R2 which have common columns

Q: 10. _______ produces the relation that has attributes of R1 and R2

Correct Answer is: Cartesian product

Q: 11. The natural join is equal to :

Correct Answer is: Combination of projection and Cartesian product

Q: 12. Which of the following is a valid SQL type?

Correct Answer is: All of the above

Q: 14. The view of total database content is

Correct Answer is: Conceptual view.

Q: 15. Relational Algebra is

Correct Answer is: Procedural query Language

Q: 16. Related fields in a database are grouped to form a

Correct Answer is: data record.

Q: 17. An advantage of the database management approach is

Correct Answer is: data is integrated and can be accessed by multiple programs.

1. A relational database developer refers to a record as

a criteria.
a relation.
a tuple.
an attribute.

2. Which of the following is correct:

a SQL query automatically eliminates duplicates.
SQL permits attribute names to be repeated in the same relation.
a SQL query will not work if there are no indexes on the relations
None of these

3. Cartesian product in relational algebra is

a Unary operator.
a Binary operator.
a Ternary operator.
not defined.

4. The result of the UNION operation between R1 and R2 is a relation that includes

all the tuples of R1
all the tuples of R2
all the tuples of R1 and R2
all the tuples of R1 and R2 which have common columns

5. The statement in SQL which allows to change the definition of a table is

Alter.
Update.
Create.
select.

6. A set of possible data values is called

attribute.
degree.
tuple.
domain.

7. Which of the following database object does not physically exist?

base table
index
view
none of the above

8. The ______ operator is used to compare a value to a list of literals values that have beenspecified.

BETWEEN
ANY
IN
ALL

9. The physical location of a record is determined by a mathematical formula that trAnsformsa file key into a record location is :

B-Tree File
Hashed File
Indexed File
Sequential file.

10. _______ produces the relation that has attributes of R1 and R2

Cartesian product
Difference
Intersection
Product

11. The natural join is equal to :

Cartesian Product
Combination of Union and Cartesian product
Combination of selection and Cartesian product
Combination of projection and Cartesian product

12. Which of the following is a valid SQL type?

CHARACTER
NUMERIC
FLOAT
All of the above

13. Which of the following is another name for weak entity?

Child
Owner
Dominant
All of the above

14. The view of total database content is

Conceptual view.
Internal view.
External view.
Physical View.

15. Relational Algebra is

Data Definition Language .
Meta Language
Procedural query Language
None of the above

16. Related fields in a database are grouped to form a

data file.
data record.
menu.
bank.

17. An advantage of the database management approach is

data is dependent on programs.
data redundancy increases.
data is integrated and can be accessed by multiple programs.
none of the above.

18. Which of the following is an advantage of view?

Data security
Derived columns
Hiding of complex queries
All of the above

19. The conceptual model is

dependent on hardware.
dependent on software.
dependent on both hardware and software .
independent of both hardware and software.

20. DML is provided for

Description of logical structure of database.
Addition of new structures in the database system.
Manipulation & processing of database.
Definition of physical structure of database system.

21. The method of access which uses key trAnsformation is known as

Direct
Hash
Random
Sequential

22. The method of access which uses key transformation is known as

direct.
hash.
random.
sequential.

23. The language used in application programs to request data from the DBMS is referred to as the

24. E-R model uses this symbol to represent weak entity set ?

Dotted rectangle.
Diamond
Doubly outlined rectangle
None of these

25. The full form of DDL is

Dynamic Data Language
Detailed Data Language
Data Definition Language
Data Derivation Language

26. In E-R Diagram derived attribute are represented by

Ellipse
Dashed ellipse
Rectangle
Triangle

27. In E-R Diagram relationship type is represented by

Ellipse
Dashed ellipse
Rectangle
Diamond

28. In E-R diagram generalization is represented by

Ellipse
Dashed ellipse
Rectangle
Triangle

29. Which of the following is a comparison operator in SQL?

Equals To
LIKE
BETWEEN
All of the above

30. Which database level is closest to the users?

External
Internal
Physical
Conceptual

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