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
12. Can objects of the same Schema reside in different tablespaces
- yes
- no
- can
- none
13. Does the Schema objects directly refer to the database's data?
- yes
- no
- can
- none
14. Schema objects include i)tables ii)views iii)sequences iv)synonyms v)indexes
- i) , ii) only
- i) and iv) and v) only
- i),ii) and iii) only
- i),ii), iii), iv) and v)
15. Which generates a serial list of unique numbers for numerical columns of a database's tables
- Sequence
- Synonym
- Degree
- Order
16. Alias for a table, view, sequence or program unit is
- Sequence
- Synonym
- Degree
- Order
17. What are the type of Synonyms i) Public ii) Private iii) Constant
- i) only
- ii) only
- i) and ii)
- none
18. public synonym
- can be accessed only by the owner on the database
- can be accessed by any user on the database
- can be accessed only by the DBA
- none
19. Private Synonym
- can be accessed only by the owner on the database
- can be accessed by any user on the database
- can be accessed only by the DBA
- none
20. What are the types of Database Links
- Private Database Link
- Public Database Link
- Network database Link.
- All the above