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
351. the data dictionary resides in the _____________table space
- system
- scott
- user
- mdsys
352. a data base on relational model developed by
- james goosing
- kim thomson
- codd
- berkely
353. Which of the following statement(s) can be considered as a part of data dictionary?
- metadata
- The complete set of data records.
- data flow diagram of the system
- none
354. The data model in which data is represented by collection of records and relationships among data are represented by links is (are) called?
- Hierarchical
- Network
- Relational
- both a & b
355. a relation ( from relational data model) consists of set of tuples which explains that
- all tuples in a relation must be distinct.
- relational model supports multi-valued attributes whose values can be represented in
- for any two tuples, the values associated with one or more of their attributes must differ.
- both a & c
356. __________ is the implementation specific design details of indexes, files, disks, blocks, etc where the database is actually stored.
- logical design
- physical design
- conceptual design
- none
357. _____________ is the implementation independant list of database objects (tables) that represents the Conceptual model
- logical design
- physical design
- conceptual design
- none.
359. Which one of the following is NOT a characteristic of metadata?
- data about data
- self describing
- includes user data
- none
360. Which of the following statements is true?
- a) The relationship attribute
- a) The relationship attribute
- a) The relationship attribute
- The relationship attribute