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
171. In which of the model(s) strictly require the relationships be predefined
- Network model
- Hierarchial model
- Relational model
- none
172. The type of the datastrucure that is used in relational model is
- Table
- Tree
- Node
- none of the above
173. The data in the database that cannot be removed by other process until and unless it is requested is
- Persistent data
- Transient data
- In consistent data
- none
174. Data integrity in a relational database requires that 1.)it is not permitted to delete a record from a secondary table if there is corresponding record in the primary table 2.)no key can be null 3.)the key in a record must be unique 4.)a foreign key must match an existing record in the primary table
- 1 only
- 2 only
- 2,3,4
- 1,2,3 and 4
175. Which of the following statements is true?
- A database must contain two or more tables
- A database must contain two data tables
- A database must contain at least one data table
- A database must contain one data table
176. A COMPLEX KEY FIELD is one which
- Is capable of storing more than one data type in it
- Ensures that there cannot be more than one record in a table with the same key field values
- Is made up of more than one field
- Is a numerical data type
177. Data Validation is
- The practice of ensuring that only valid data is input into a database
- The practice of running a check on existing data to confirm that there is no invalid data
- A separate program that checks existing data for errors
- A process of filtering out invalid data on a weekly or monthly basis
178. A field is
- can store any type of data at any time
- capable of storing many facts
- the smallest amount of data DBMS can store
- either true or false
179. Which of the following is a valid key field.
- Initials+family name
- Student name
- Car registration number
- Streetname
180. Which of the following is a valid database. 1.A telephone directory 2.The northern college record system 3.box of flowers 4.none
- 2 only
- 1 and 2
- 2 and 3
- 4