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
471. A notation for defining the form and structure of data is known as
- Data description language
- Binary language
- Data channels
- Data definition language
472. A data item, which is not broken down into smaller units, is
- Data element
- Elementary data item
- Data entry
- Database management
473. Which of the following terms refers to the degree to which data in database system are accurate and correct ?
- Data security
- Data validaity
- Data independence
- Data integrity
474. A repository for data, usually covering specific topic is
- Database
- Data requisition
- Data bank
- Data collection
475. A set of programs tht handle firm's data base responsibilities is called a
- Database Management system (DBMS)
- Database processing System (DBPS)
- Data management System (DMS)
- All of above
476. Which is used to provide the sight information to the right person at the right time for proper decision making ?
- DBMS
- MIS
- ISO
- PSO
478. Which of the following database objects asks a question of information in a database and then displays the result ?
- Tables
- Reports
- Queries
- Forms
479. What data type should you choosefor a zip code field in a table ?
- Text
- Number
- Memo
- All of above
480. A list consists of last names, first names, address and pin codes if all people in the list have the same last and the samepin code, a useful key would be
- The pin Code
- The last name
- A compound key consisting of the first name and the last name
- All of the above