MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 839 Mcqs, each offering curated multiple-choice questions to sharpen your C++ Programming knowledge and support exam preparation. Choose a topic below to get started.
| 101. |
Which of the following columns can not be found in the macro design window? |
| A. | Arguments column |
| B. | Comment column |
| C. | Conditions column |
| D. | Actions column |
| Answer» C. Conditions column | |
| 102. |
New record is added using |
| A. | Append record from browse menu |
| B. | Append record into from browse menu |
| C. | Add record from edit menu |
| D. | All of above |
| Answer» B. Append record into from browse menu | |
| 103. |
When a customer makes an online hotel booking, the database is updated in |
| A. | Batch mode |
| B. | Pseudo real-time |
| C. | One month |
| D. | All of above |
| Answer» C. One month | |
| 104. |
An integrated collection of all of the data about your customers. Select the best fit for answer |
| A. | Record |
| B. | File |
| C. | Database |
| D. | Key field |
| Answer» C. Database | |
| 105. |
The framework for storing records in database is a |
| A. | Form |
| B. | Report |
| C. | Query |
| D. | Table |
| Answer» D. Table | |
| 106. |
In a relational schema, each tuple is dividedinto fields called |
| A. | Relations |
| B. | Domains |
| C. | Queries |
| D. | All of the above |
| Answer» C. Queries | |
| 107. |
The number of logical records in a physical record is |
| A. | group |
| B. | blocking factor |
| C. | sector |
| D. | field |
| Answer» E. | |
| 108. |
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» D. The query uses the records from the table without displaying them | |
| 109. |
RDBMS stands for |
| A. | Relational Database Management System |
| B. | Relation Data Module System |
| C. | Right Data Base Management System |
| D. | None of the above |
| Answer» B. Relation Data Module System | |
| 110. |
The term refers to a collection of related information |
| A. | Database |
| B. | List |
| C. | Outline |
| D. | Record |
| Answer» D. Record | |
| 111. |
List command is used to get |
| A. | List of database contents |
| B. | List of database contents |
| C. | List of variables used in database file |
| D. | None of the above |
| Answer» B. List of database contents | |
| 112. |
Users who store data about real people for marketing purposes must register the data and its potential use with |
| A. | The computer misuse controller |
| B. | The data protection controller |
| C. | HM customs and excise |
| D. | None of above |
| Answer» C. HM customs and excise | |
| 113. |
What is a Grouped Report? |
| A. | A type of report that can be generated by the Report Wizard |
| B. | A report that displays data that has been sorted in ascending or descending order |
| C. | A report that displays data grouped by fields you specify |
| D. | None |
| Answer» D. None | |
| 114. |
A large collections of files are called |
| A. | Fields |
| B. | Records |
| C. | Databases |
| D. | File system |
| Answer» C. Databases | |
| 115. |
The following term applies to a collection ofrelated records in a database |
| A. | File |
| B. | Layout |
| C. | File |
| D. | Field |
| Answer» B. Layout | |
| 116. |
APPEND command is used to |
| A. | Add record to the end of active database file and starts full screen data entry |
| B. | Add Record to the start of active database file |
| C. | Add record to the start of active database file and starts full screen data entry |
| D. | Add record to the end of database file |
| Answer» B. Add Record to the start of active database file | |
| 117. |
The following command is used to search the record that satisfies the specified criteria |
| A. | FOUND |
| B. | SEARCH |
| C. | GET |
| D. | LOCATE |
| Answer» B. SEARCH | |
| 118. |
Which of the following is not a command to find specific word or phrases in a database? |
| A. | Click the find button on the toolbar |
| B. | Click the find button on the record navigation button area |
| C. | Press Ctrl+F |
| D. | Select Edit>Find from the menu. |
| Answer» C. Press Ctrl+F | |
| 119. |
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» C. It displays a title for the Pivot Table report | |
| 120. |
Records are deleted using |
| A. | DELETE command followed by pack |
| B. | DELETE command without pack |
| C. | DELETE command followed by zap |
| D. | DELETE command without zap |
| Answer» B. DELETE command without pack | |
| 121. |
Which of the following is not a Access database object ? |
| A. | table |
| B. | form |
| C. | query |
| D. | datasheet |
| Answer» E. | |
| 122. |
The Query is a statement requesting for |
| A. | Insertion of information |
| B. | Deletion of information |
| C. | Update of information |
| D. | Retrieval of information |
| Answer» E. | |
| 123. |
It shows the appearance and layout of a report, table or form in order to confirm what will be printed. |
| A. | Datasheet view |
| B. | Design view |
| C. | Print preview |
| D. | Layout preview |
| Answer» C. Print preview | |
| 124. |
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» C. Display records whose dates equaled 1/1/99 or 12/31/99 | |
| 125. |
What is a largest collection of data stored in a computer? You might use this type of program to keep a record of all the friends in your address book. |
| A. | Information Processing |
| B. | Spreadsheet |
| C. | Operating system |
| D. | Database |
| Answer» E. | |
| 126. |
You can switch back and forth betweendesign and datasheet view by clicking the |
| A. | queries object tab |
| B. | switch command on the view menu |
| C. | view button |
| D. | select query title bar |
| Answer» D. select query title bar | |
| 127. |
Data items groped together for storage purposes are called a |
| A. | Record |
| B. | Title |
| C. | List |
| D. | string |
| Answer» B. Title | |
| 128. |
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» E. | |
| 129. |
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» C. Type Library Spy | |
| 130. |
A form that is used to collect data in a structured manner for entry to a database is called a |
| A. | Database deign form |
| B. | Systems flowchart |
| C. | Data capture form |
| D. | None of above |
| Answer» D. None of above | |
| 131. |
The data in a record is of the following types |
| A. | four text fields and three numeric fields |
| B. | two integer fields and five text fields |
| C. | three text fields and four numeric fields |
| D. | none of the above |
| Answer» C. three text fields and four numeric fields | |
| 132. |
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» D. None of the above | |
| 133. |
The largest unit of a database is |
| A. | A record |
| B. | A field |
| C. | A subfield |
| D. | None of above |
| Answer» C. A subfield | |
| 134. |
What’s the best Access object for an invoice you’ll mail to customers? |
| A. | A report |
| B. | A form |
| C. | A table |
| D. | All of the above |
| Answer» B. A form | |
| 135. |
The following command is used for inserting records |
| A. | INSERT |
| B. | ADD |
| C. | Both of the above |
| D. | None of the above |
| Answer» B. ADD | |
| 136. |
The data in a Pivot Table report is categorized using |
| A. | Column headings |
| B. | Items from the Pivot Table field list |
| C. | Header rows |
| D. | All of above |
| Answer» C. Header rows | |
| 137. |
Data owners must protect their data against corruption or loss. One sensible method to achieving this is to |
| A. | Take regular backups |
| B. | Keep a hardcopy printout of all data |
| C. | Keep fingers crossed at all times |
| D. | None of above |
| Answer» B. Keep a hardcopy printout of all data | |
| 138. |
The way a particular application views thedata from the database that the applicaton uses is a |
| A. | Module |
| B. | Relational model |
| C. | Schema |
| D. | Sub-schema |
| Answer» E. | |
| 139. |
Which custom date format displays the numeric day of the year when a date is entered? |
| A. | YY |
| B. | YYYY |
| C. | Y |
| D. | All of above |
| Answer» D. All of above | |
| 140. |
In Form view, which command displays records alphabetically? |
| A. | Find |
| B. | Advanced Filter/Sort |
| C. | Sort |
| D. | All of the above |
| Answer» D. All of the above | |
| 141. |
Which of the following criterion would find records whose personality field does not equal “Nice”? |
| A. | <>Nice |
| B. | NOT Nice |
| C. | <>”Nice” |
| D. | IS NOT Nice |
| Answer» D. IS NOT Nice | |
| 142. |
The following language used by most of the DBMSs for helping their users to access data |
| A. | High level language |
| B. | Query language |
| C. | SQL |
| D. | 4GL |
| Answer» B. Query language | |
| 143. |
Which action will optimize your databaseperformance? |
| 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» C. Create a replica of the database | |
| 144. |
The following devices can be used to input data into a database |
| A. | Keyboard, fax roller ball |
| B. | Mouse, keyboard, monitor |
| C. | Mouse, keyboard, touch screen |
| D. | None of the above |
| Answer» D. None of the above | |
| 145. |
The following statement is not valid about indexing |
| A. | it stores the index fields |
| B. | it stores the corresponding record number |
| C. | it maintains the alphabetically order |
| D. | it duplicate the database file |
| Answer» E. | |
| 146. |
If you are entering data in a form, a quick way to cpy a value from the previous record is to press |
| A. | Ctrl+’ |
| B. | F6 |
| C. | Ctrl+D |
| D. | None of the above |
| Answer» B. F6 | |
| 147. |
What did the first Table Analyzer do? |
| A. | Analyze the data in a set of flat files and automatically create a relational database system from that information |
| B. | Provide a graphic way to design relational databases |
| C. | Automate process of connecting tables to SQL Server |
| D. | None |
| Answer» B. Provide a graphic way to design relational databases | |
| 148. |
What is a stored question about information in a database? |
| A. | Record |
| B. | Field |
| C. | Report |
| D. | Query |
| Answer» E. | |
| 149. |
Facilities offered by databases are |
| A. | The ability to store a large amount of data in a structured format, easy update, sort, query, production of reports |
| B. | Easy editing, spell check, perform calculations, library of mathematical functions, replication |
| C. | The ability to rotate images, copy and paste, fill scale |
| D. | None of above |
| Answer» B. Easy editing, spell check, perform calculations, library of mathematical functions, replication | |
| 150. |
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» B. Parameter queries | |