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
431. A specialist in change of the database of an organization select the best fit for answer
- Database management approach
- DBMS uses
- Database administrator
- Query language
432. This DBMS feature allows users to easily interrogate a database. Select the best fit for answer
- Database management approach
- DBMS uses
- Database administrator
- Query language
433. The .....................presents data in a way similar to an excel spreadsheet
- Datasheet view
- Design view
- Print priview
- Layout preview
434. It is used to build and modify database objects and also to create new queries
- Datasheet view
- Design view
- Print preview
- Layout preivew
435. It shows the appearance and layout of a report, table, table or form in order to confirm what will be printed.
- Datasheet view
- Design view
- Print preview
- Layout preview
436. It examines a small portion or sample of your data in a report before printing it.
- Datasheet view
- Design view
- Print preview
- Layout preview
437. A report form
- Appears on the computer monitor during data entry
- Is used during report generation to format data
- Both (A) and (B)
- All of above
438. Which of the following columns can not be found in the macro design window ?
- Arguments column
- Comment column
- Conditions column
- Actions column
439. The ascending order of data hierachy ios :
- Bit, Byte, field record, file, database
- Bit, byte, record, field, file, database
- Byte, bit, field record, file, database
- Byte, bit, record, field, file, database
440. A good query system
- Can accept English language commands
- Allows non-programers to access information stored in a database
- Can be accessed only by data prssing professionals
- Both (A) and (B)