McqMate
These multiple-choice questions (MCQs) are designed to enhance your knowledge and understanding in the following areas: Computer Science Engineering (CSE) , Bachelor of Science in Computer Science FY (BSc CS) , Bachelor of Science in Information Technology SY (BSc IT) , Bachelor of Computer Applications (BCA) , Common Topics in Competitive and Entrance exams .
| 151. |
What are the columns in a Microsoft Access table called? |
| A. | Rows |
| B. | Fields |
| C. | Cells |
| D. | Records |
| Answer» B. Fields | |
| 152. |
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» C. Click the report, and on the Pivot Table toolbar, click the refresh data button | |
| 153. |
In access, the best types of queries to use for data analysis are: |
| A. | Select querie |
| B. | Parameter queries |
| C. | Action queries |
| D. | All of the above |
| Answer» A. Select querie | |
| 154. |
How can you add a table to the relationship window? |
| A. | Select Tools>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» B. Select the table from the table list on the toolbar | |
| 155. |
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» B. Selecting the underlying table or query on which you want to base the form or report | |
| 156. |
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 |
| Answer» B. Use the compact and repair database tool | |
| 157. |
The arranging of data in a logical sequence is called |
| A. | Sorting |
| B. | Classifying |
| C. | Reproducing |
| D. | Summarizing |
| Answer» A. Sorting | |
| 158. |
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» D. Both (A) and (B) | |
| 159. |
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) |
| Answer» D. Both (A) and (B) | |
Done Studing? Take A Test.
Great job completing your study session! Now it's time to put your knowledge to the test. Challenge yourself, see how much you've learned, and identify areas for improvement. Don’t worry, this is all part of the journey to mastery. Ready for the next step? Take a quiz to solidify what you've just studied.