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
491. In Form view, which command displays records alphabetically ?
- Find
- Advanced Filter/Sort
- Sort
- All of the above
492. Where do report and forms get their information form ?
- Forms
- Modules
- Tebles
- Queries
493. The number of logical records in a physical record is
- Group
- Blocking factor
- sector
- field
494. A top to bottom relationship among the items in a database is established by a
- Hierachical schema
- Network Schema
- Relational schema
- All of the above
495. A command that lets you change one more fields in a record is
- Insert
- Modify
- Lookup
- All of the above
496. A logical schema
- Is the entire database
- is a standard way of organizing information into accessible parts
- Describes how data is actually stored on disk
- All of the above
497. What is the purpose of the page field on a pivot table report ?
- It creates a new page for each type of data
- It allows the data within the pivot table report to be filtered
- It displays a title for the Pivot Table report
- None of the above
498. What does the Special Effect button on the formatting toolbar do?
- It lets you add animation to your forms and reports to make them more entertaining and amusing
- It lets you select a transitional effect for how a form opens and closes.
- It applies a 30d effect to a selected control
- None of these
499. Pivot Table report data must meet which of the following criteria?
- it must be in tabular form, have unique coumn labels, and each row must represent a unique piece of data
- Any dates should be formatted with the data format and blank rows or columns should be removed
- it must be in tabular form, have unique column lagels, and all rows must be sorted
- Both (A) and (B)
500. Customers Orders, What's their best relationship ?
- Many-to-many
- One-to-one
- One-to-many
- All of the above