McqMate
| 101. |
A repository for data, usually covering some specific topic is called |
| A. | Data acquisition |
| B. | Data bank |
| C. | Real time |
| D. | Database |
| Answer» B. Data bank | |
| 102. |
A notation for defining the form and structure of data is known as |
| A. | Data description language |
| B. | Binary language |
| C. | Data channels |
| D. | Data definition language |
| Answer» D. Data definition language | |
| 103. |
A data item, which is not broken down into smaller units, is |
| A. | Data element |
| B. | Elementary data item |
| C. | Data entry |
| D. | Database management |
| Answer» B. Elementary data item | |
| 104. |
Which of the following terms refers to the degree to which data in database system are accurate and correct? |
| A. | Data security |
| B. | Data validaity |
| C. | Data independence |
| D. | Data integrity |
| Answer» D. Data integrity | |
| 105. |
A repository for data, usually covering specific topic is |
| A. | Database |
| B. | Data requisition |
| C. | Data bank |
| D. | Data collection |
| Answer» C. Data bank | |
| 106. |
A set of programs that handle firm’s data base responsibilities is called a |
| A. | Database Management System (DBMS) |
| B. | Database Processing System (DBPS) |
| C. | Data Management System (DMS) |
| D. | All of above |
| Answer» D. All of above | |
| 107. |
Which of the following is not a relational database? |
| A. | dBase IV |
| B. | 4th Dimension |
| C. | FoxPro |
| D. | Reflex |
| Answer» D. Reflex | |
| 108. |
Which is used to provide the sight information to the right person at the right time for proper decision making ? |
| A. | DBMS |
| B. | MIS |
| C. | ISO |
| D. | PSO |
| Answer» B. MIS | |
| 109. |
Dbase-III was developed by |
| A. | Dec |
| B. | IBM |
| C. | Ashton-tate |
| D. | All of the above |
| Answer» C. Ashton-tate | |
| 110. |
Which of the following database objects asks a question of information in a database and then displays the result? |
| A. | Tables |
| B. | Reports |
| C. | Queries |
| D. | Forms |
| Answer» C. Queries | |
| 111. |
What data type should you choose for a zip code field in a table? |
| A. | Text |
| B. | Number |
| C. | Memo |
| D. | All of above |
| Answer» A. Text | |
| 112. |
A list consists of last names, first names, address and pin codes if all people in the list have the same last and the same pin code, a useful key would be |
| A. | The pin code |
| B. | The last name |
| C. | A compound key consisting of the first name and the last name |
| D. | All of the above |
| Answer» C. A compound key consisting of the first name and the last name | |
| 113. |
What happens when you add the asterisk (() from any field list ot a query? |
| A. | The table will not include any fields from the table |
| B. | The query sorts the table’s record in the order you specify |
| C. | The query will include every field from the table* |
| D. | The query uses the records from the table without displaying them |
| Answer» C. The query will include every field from the table* | |
| 114. |
The modify operation is likely to be done after |
| A. | delete |
| B. | look up |
| C. | insert |
| D. | all of above |
| Answer» B. look up | |
| 115. |
The criteria BETWEEN 1/1/99 and 12/31/99 would which is proper |
| A. | Display records between the dates 1/2/ 99 and 1/1/00 |
| B. | Display records between the dates 1/1/ 99 and 12/31/99 |
| C. | Display records whose dates equaled 1/1/99 or 12/31/99 |
| D. | All of the above |
| Answer» B. Display records between the dates 1/1/ 99 and 12/31/99 | |
| 116. |
DDP stands for |
| A. | Distributed Double Processing |
| B. | Double Decimal Processing |
| C. | Distributed Data Programming |
| D. | Distributed Data Processing |
| Answer» D. Distributed Data Processing | |
| 117. |
To see sales amount figures totaled, into which drop area would you drag that field? |
| A. | Drop column fields here |
| B. | Drop row fields here |
| C. | Drop data items here |
| D. | None of the above |
| Answer» C. Drop data items here | |
| 118. |
Which access feature do you use to develop applications that host access data on the web? |
| A. | Dynamic web data |
| B. | Data access pates |
| C. | Html data pages |
| D. | None of the above |
| Answer» B. Data access pates | |
| 119. |
What is the common name for a column of data within an Access table? |
| A. | Field |
| B. | Record |
| C. | Row |
| D. | None of the above |
| Answer» A. Field | |
| 120. |
A data structure consisting of several fields, some or all of which are instances of the same data structure, is called |
| A. | Field |
| B. | Bead |
| C. | Database |
| D. | Data collection |
| Answer» B. Bead | |
| 121. |
A group of characters used to identiry a given low level instruction is |
| A. | File |
| B. | Record |
| C. | Key field |
| D. | Label |
| Answer» D. Label | |
| 122. |
One or more characters used to identify a data field in a computer program is |
| A. | File name |
| B. | Database |
| C. | Label |
| D. | Group |
| Answer» C. Label | |
| 123. |
In Form view, which command displays records alphabetically? |
| A. | Find |
| B. | Advanced Filter/Sort |
| C. | Sort |
| D. | All of the above |
| Answer» C. Sort | |
| 124. |
Where do report and forms get their information form? |
| A. | Forms |
| B. | Modules |
| C. | Tables |
| D. | Queries |
| Answer» C. Tables | |
| 125. |
The number of logical records in a physical record is |
| A. | group |
| B. | blocking factor |
| C. | sector |
| D. | field |
| Answer» D. field | |
| 126. |
A top to bottom relationship among the items in a database is established by a |
| A. | Hierarchical schema |
| B. | Network Schema |
| C. | Relational schema |
| D. | All of the above |
| Answer» A. Hierarchical schema | |
| 127. |
A command that lets you cange one or more fields in a record is |
| A. | Insert |
| B. | Modify |
| C. | Look up |
| D. | All of the above |
| Answer» B. Modify | |
| 128. |
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» B. Is a standard way of organizing information into accessible parts | |
| 129. |
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 the Pivot Table report to be filtered |
| C. | It displays a title for the Pivot Table report |
| D. | None of the above |
| Answer» B. It allows the data within the the Pivot Table report to be filtered | |
| 130. |
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» C. It applies a 30d effect to a selected control | |
| 131. |
Pivot Table report data must meet which of the following criteria? |
| A. | It must be in tabular form, have unique column 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» D. Both (A) and (B) | |
| 132. |
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» C. One-to-many | |
| 133. |
Which control does access use to link data access page components to access data? |
| A. | Microsoft Dynamic Data Control |
| B. | Microsoft Data Connection Control |
| C. | Microsoft Office Data Source Control |
| D. | None of the above |
| Answer» C. Microsoft Office Data Source Control | |
| 134. |
Which program do you use to edit code for data access pages? |
| A. | Microsoft script editor |
| B. | Microsoft code editor |
| C. | Microsoft data access pages editor |
| D. | None of above |
| Answer» A. Microsoft script editor | |
| 135. |
The way a particular application views the data from the database that the applicaton uses is a |
| A. | Module |
| B. | Relational model |
| C. | Schema |
| D. | Sub-schema |
| Answer» D. Sub-schema | |
| 136. |
Which of the following is a database management system? |
| A. | Ms-Word |
| B. | Lotus 1-2-3 |
| C. | Oracle |
| D. | None of above |
| Answer» C. Oracle | |
| 137. |
What is the corresponding text for the <#1/1/ 95# validation rule setting? |
| A. | Neter a value less or more than 1,195 |
| B. | Value must be less than 95 characters |
| C. | Enter a date before 1995 |
| D. | All of above |
| Answer» A. Neter a value less or more than 1,195 | |
| 138. |
What is the name of the Visual Basic Editor utility that allows you to view the Microsoft Access type library’s available objects and members? |
| A. | Object Viewer |
| B. | Object Browser |
| C. | Type Library Spy |
| D. | None of above |
| Answer» B. Object Browser | |
| 139. |
A computer language for informing the DBMS regarding the data structure used is |
| A. | PASCAL |
| B. | DDL |
| C. | PROLOG |
| D. | FORTRAN |
| Answer» B. DDL | |
| 140. |
Which of the following is not a data type ? |
| A. | Picture/graphic |
| B. | Data/time |
| C. | Texst |
| D. | Number |
| Answer» A. Picture/graphic | |
| 141. |
The executive responsible for the data processing function in an organization is |
| A. | PM |
| B. | DBMS |
| C. | DP |
| D. | DPM |
| Answer» B. DBMS | |
| 142. |
Which of the following is NOT a type of Microsoft Access database object? |
| A. | Queries |
| B. | Workbooks |
| C. | Forms |
| D. | Tables |
| Answer» B. Workbooks | |
| 143. |
A file containing relatively permanent data is |
| A. | Random file |
| B. | Transaction file |
| C. | Master file |
| D. | Sequential file |
| Answer» C. Master file | |
| 144. |
The complete picture of data stored in database is known as |
| A. | Record |
| B. | Scheme |
| C. | System flowchart |
| D. | DBMS |
| Answer» B. Scheme | |
| 145. |
A subset of characters within a data field is known as |
| A. | Record |
| B. | File |
| C. | Data string |
| D. | Byte |
| Answer» C. Data string | |
| 146. |
Data items groped together for storage purposes are called a |
| A. | Record |
| B. | Title |
| C. | List |
| D. | string |
| Answer» A. Record | |
| 147. |
Which of the following terms does not describe a database structure used by a DBMS to link data from several files? |
| A. | Relational |
| B. | Structural |
| C. | Network |
| D. | All of the above |
| Answer» B. Structural | |
| 148. |
In a relational schema, each tuple is divided into fields called |
| A. | Relations |
| B. | Domains |
| C. | Queries |
| D. | All of the above |
| Answer» B. Domains | |
| 149. |
How do you filter by selection? |
| A. | Right click the field value and select filter by selection from the shortcut menu |
| B. | Find and double click the value on which you want to base the filter |
| C. | Find and select the value on which you want to base the filter and select tools>filter by selection from the menu |
| D. | None of the above |
| Answer» A. Right click the field value and select filter by selection from the shortcut menu | |
| 150. |
What is a fast way to adjust the width of a column? |
| A. | Right click the left side of the column heading |
| B. | Double click the left side of the column heading |
| C. | Double click the right side of the column heading |
| D. | Select tools>adjust column width from the menu |
| Answer» C. Double click the right side of the column heading | |
| 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 Reading?