DBMS MCQ Questions and Answers

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

📚 More from Database

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Database
Back to Database
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test