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 .
| 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 | |
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.