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
411. Corrupted inex file is corrected using
- Modifyindex
- Recreateindex
- reindex
- None of the above
412. The navigation buttons enable you to
- Move from record to record in a table or form
- Move from page to page in report
- (A) and (B) both
- None of the above
413. Diffferent levels of access are assigned to personnel records in the health and fitness gym. Only the system manager is able to create delete or edit records. Certain other personnel are allowed to view all the records, whereas others are not permitted to view complete records. The levels of access are controlled by
- Password
- User id's
- Status
- None of the above
414. You can switch back and forth between design and datasheet view by clicking the
- Queries object tab
- Switch command on the view menu
- View button
- select query title bar
415. The table wizard
- Quickly creates a default report
- Displays a subset of the data in a database
- Contains sample tables and fields you can use to create a table
- Automatically edits your data as you enter it
416. The names, address, and account balance of all of your customers, select the best fit for answer
- record
- file
- database
- key field
417. An integrated collection of all of the data about your customers. Select the best fit for answer
- Record
- File
- Database
- Key field
418. An identification field in a record. Select the best fit for answer
- Record
- File
- Database
- Key field
419. What is a stored question about information in a database ?
- Record
- Field
- Report
- Query
420. RDBMS stands for
- Relational Database Management System
- Relation Data Module System
- Right Data Base Management System
- None of the above