DBMS MCQ Questions and Answers
DBMS MCQ questions with answers form a vital part of technical exams and campus interviews. This topic explores database concepts, normalization, SQL queries, transaction management, and ER models. Practicing programming questions and answers from this section strengthens your database design and query optimization skills. These questions are frequently asked in GATE, Infosys, TCS, and Wipro assessments, making them essential for students and professionals alike. Detailed solutions and explanations make this section perfect for both beginners and advanced learners aiming to master database management fundamentals.
DBMS MCQ
Showing 10 of
527 questions
81. When using the multiple table to query information , in which clause we specify the names of tables
- having
- grouping
- where
- from
82. With out any join condition the join becomes
- eqi join
- self join
- outer join
- Cartesian join
83. The query given bellow is SELECT E.ENAME=
- inner join
- outer join
- self join
- none
85. The advantages that using the aliases are
- It can used to refer the table
- It effectively improve the query performance
- It allows to join two tables
- None of these
86. What is true regarding the co-related sub queries
- Execution is slow when compared to nested queries
- First the outer query and next the inner query executed
- Based on inner query result the outer query executes
- None of the above
87. If we delete the record from the table DEPT is
- Delete records for the table DEPT
- Delete the record from both tables
- Referential integrity error occurs
- All the above
89. Collectively, a course number, course title, and course description would be called
- record
- field
- file
- database