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
181. Assume you are extending the design of The Northern College Student Records System to include details on each classroom. The college is never likely to have more than ten classrooms and definitely not ever going to have more than 25 classrooms. What data type would you select
- Numeric- Integer
- Numeric
- Numeric
- Numeric
182. A Database Management System can 1.Delete data 2. Retrieve data 3.Add new data 4.Edit Data
- 1 and 2
- 1,2 and 4
- 1,2 and 3
- 1,2,3 and 4
183. A unique key field is
- Is a special field that has to be a unique number
- Is a special field that identifies a particular record in a data table
- Is a special field that each database has to have.
- none
184. Input Masks are
- only used with a RDBMS
- Used to force user input into a particular form.
- Used to prevent any data at all being entered into a particular field
- Use to ensure that numbers are kept within expected bounds
185. A flat file Database management system is
- A DBMS that can only have one table in it
- A DBMS that contains records that have a large number of fields in them
- A DBMS that can only have simple data tables in it
- none of these
186. A table
- Cannot be empty
- consists of rows and columns
- Consists of Alphanumeric data
- can only store data of one type
187. Which of the following statements are true 1.A character data type can contain 0,1,2,3,4,5,6,7,8,9 2.Some DBMS
- 1 and 2
- 1,2 and 3
- 1,2 and 4
- 1,2,3 and 4
188. Which of the following statements are true
- All records in a data table need not necessarily have the same fields in them
- A data table is made up of records
- Fields must contain specified types of data
- A record is made up of fields
189. The person who is having central control over data and programs accessing that data
- DBA
- Database Designer
- Developer
- none
190. The users who use the database by writing special database application programs are called
- Sophisticated end user
- Specialized end user
- Na
- Native end user