DBMS MCQ Questions and Answers

Practice Mode
Showing 10 of 527 questions
Q521
How do you update Pivot Table report data after changes are made to the source data?
  • A Save your changes, close the workbook, and then reopen it.
  • B Select the Pivot Table worksheet and press F9 on the keyboard
  • C Click the report, and on the Pivot Table toolbar, click the refresh data button
  • D All of the above
Answer: Option C
Q522
In access, the best types of queries to use for data analysis are:
  • A Select queries
  • B Parameter queries
  • C Action queries
  • D All of the above
Answer: Option A
Q523
How can you add a table to the relationship window ?
  • A Select Tool>Add table from the menu
  • B Select the table from the table list on the toolbar
  • C Click the show table button on the toolbar
  • D Select Edit>Add table from the menu
Answer: Option B
Q524
What is the first step in creating  a form or report with the form wizard or report wizard ?
  • A Selecting the fields that you want to appear in the form or report
  • B Selecting the underlying table or query on which you want to base the form or report
  • C Reading several screens of mostly useless information and clicking next
  • D Selecting how the form or report should be formatted
Answer: Option B
Q525
Which action wil optimize your database performance ?
  • A Set the record set type to snapshot
  • B Use the compact and repair database tool
  • C Create a replica of the database
  • D All of the above
Answer: Option B
Q526
If a piece of data is stored in two places in the database then a
  • A Storage, space is wasted
  • B Changing the data is one spot will cause data inconsistency
  • C it can be more easily accessed
  • D Both (A) and (B)
Answer: Option D
Q527
A relational database management (RDBMS) package manages data in more than one file at once. Hoe does it organize these file?As
  • A Tables
  • B Relations
  • C Tuple
  • D Both (A) and (B)
Answer: Option D

📚 More from Database

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