![Mcqmate logo](https://mcqmate.com/images/logos/logo-black.png)
![Mcqmate logo](https://mcqmate.com/images/logos/logo-white.png)
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?