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