DBMS Important Questions and Answers Set - 12
31. What are the columns in a Microsoft Access table called ?
A. Rows
B. Fields
C. Cells
D. Records
Ans- B.Fields
32. 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. Slick the report ,and on the pivot table toolbar , click the refresh data
button
D. All of the above
Ans- C.Slick the report ,and on the pivot table toolbar , click the refresh
data button
33. In access , the best types of queries too use for data analysis are :
A. Select queries
B. Parameter queries
C. Action queries
D. All of the above
Ans- A.Select queries
34. How can you add a table to the relationship window ?
A. Select tools > add a 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
Ans- B.Select the table from the table list on the toolbar
35. 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 screen of mostly useless information and clicking next
D. Selecting how the form or report should be formatted
Ans- B.Selecting the underlying table or query on which you want to
base the form or report
36. Which action will 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
Ans- B. Use the compact and repair database tool
37. The arranging of data in a logical sequence is called
A. Sorting
B. Classifying
C. Reproducing
D. Summarizing
Ans- A. Sorting
38. 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
Ans- D.Both A and B
39. A relational database management ( RDBMS ) package manages data in
more than one file at once . How does it organize these file ? As
A. Tables
B. Relations
C. Tuple
D. Both A and B
Ans- D. Both A and B
