DBMS MCQ Question and Answer
DBMS MCQ Question and Answer
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