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.
| 51. |
It examines a small portion or sample of your data in a report before printing it. |
| A. | Datasheet view |
| B. | Design view |
| C. | Print preview |
| D. | Layout preview |
| Answer» E. | |
| 52. |
The purpose of the Add-in Manager is to |
| A. | Create macros and automate data processing |
| B. | Add or remove data in an existing database |
| C. | Add or remove templates, macros, and wizards |
| D. | All of above |
| Answer» D. All of above | |
| 53. |
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» D. Select tools>adjust column width from the menu | |
| 54. |
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» D. All of the above | |
| 55. |
A field that uniquely identifies a record is called a |
| A. | Main field |
| B. | Header |
| C. | Key field |
| D. | None of above |
| Answer» D. None of above | |
| 56. |
What is the term to ask the computer to pt information in order numerically or alphabetically ? |
| A. | Crop |
| B. | Report |
| C. | Sort |
| D. | Organize |
| Answer» D. Organize | |
| 57. |
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» D. All of the above | |
| 58. |
Which field allow to select items from drop down list? |
| A. | An OLE field |
| B. | A Memo Field |
| C. | A lookup Field |
| D. | A hyperlink field |
| Answer» D. A hyperlink field | |
| 59. |
The use of integrated collections of database records and files for data storage and processing. The best fit for answer: |
| A. | Database management approach |
| B. | DBMS uses |
| C. | Database administrator |
| D. | Query language |
| Answer» E. | |
| 60. |
This DBMS feature allows users to easily interrogate a database. Select the best fit for answer |
| A. | Database management approach |
| B. | DBMS uses |
| C. | Database administrator |
| D. | Query language |
| Answer» D. Query language | |
| 61. |
When you save an Access project, what fileformat do you use? |
| A. | .adp |
| B. | .xm. |
| C. | .mdb |
| D. | All of above |
| Answer» B. .xm. | |
| 62. |
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» B. Record | |
| 63. |
Append from command is used to |
| A. | Add records from information in an array |
| B. | Adds records from a file |
| C. | Add records from a variable |
| D. | Add records from stock |
| Answer» B. Adds records from a file | |
| 64. |
One of the type libraries that you can use to programmatically connect to Microsoft Access data is |
| A. | Collaborative Data Objects |
| B. | ActiveX Data Objects |
| C. | Dynamic Data Interfaces |
| D. | None of the above |
| Answer» C. Dynamic Data Interfaces | |
| 65. |
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» D. All of the above | |
| 66. |
Sub-schema can be used to |
| A. | Create very different, personalized views of the same data |
| B. | Present information in different formats |
| C. | Hide sensitive information by omitting fields from the subschema’s description |
| D. | All of the above |
| Answer» E. | |
| 67. |
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» B. Microsoft code editor | |
| 68. |
Examples of centralized multi-user databases are |
| A. | Barclays’ Bank customer accounts |
| B. | Supermarket stock control, organ donor database, client database |
| C. | Airline reservations and other national global booking systems |
| D. | None of above |
| Answer» D. None of above | |
| 69. |
What is the abbreviation used for a software package that permits the user to create, retrieve and maintain records in a database? |
| A. | DASD |
| B. | FMS |
| C. | EMMS |
| D. | DBMS |
| Answer» E. | |
| 70. |
Checks that are added to databases to detect unsuitable data on inpt are called |
| A. | validation |
| B. | verification |
| C. | vegetation |
| D. | none of above |
| Answer» B. verification | |
| 71. |
A specialist in charge of the database of anorganization select the best fit for answer |
| A. | Database management approach |
| B. | DBMS uses |
| C. | Database administrator |
| D. | Query language |
| Answer» C. Database administrator | |
| 72. |
Applications that rely on databases are |
| A. | Supermarket stock control, theater bookings and payroll |
| B. | Accounts, online banking, PowerPoint presentations |
| C. | Internet shopping, robotics, computer games |
| D. | None of above |
| Answer» B. Accounts, online banking, PowerPoint presentations | |
| 73. |
Which command is used to replace ? |
| A. | REPLACE |
| B. | REPLACE ALL |
| C. | Add record from edit menu |
| D. | All of above |
| Answer» D. All of above | |
| 74. |
DDP stands for |
| A. | Distributed Double Processing |
| B. | Double Decimal Processing |
| C. | Distributed Data Programming |
| D. | Distributed Data Processing |
| Answer» E. | |
| 75. |
Each individual data items of record is called a |
| A. | Field |
| B. | Data type |
| C. | Comment |
| D. | All of the above |
| Answer» C. Comment | |
| 76. |
When you double click a query object, you open |
| A. | The object in design view |
| B. | The object in print preview |
| C. | The result of the query |
| D. | The underlying table on which the query is based |
| Answer» C. The result of the query | |
| 77. |
Modules are |
| A. | selection of commands used to automate repetitive tasks |
| B. | programs written in Visual C++ |
| C. | Object tabs |
| D. | Group of records |
| Answer» B. programs written in Visual C++ | |
| 78. |
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» B. Network Schema | |
| 79. |
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» C. ISO | |
| 80. |
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» B. Find and double click the value on which you want to base the filter | |
| 81. |
The navigation buttons enable you to |
| A. | move from record to record in a table or form |
| B. | move from page to page in report |
| C. | (A) and (B) both |
| D. | None of the above |
| Answer» D. None of the above | |
| 82. |
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» B. Number | |
| 83. |
Within Table Datasheet view, how can you display associated records from another table? |
| A. | Click the expand indicator (+) next to a record |
| B. | Double click the record. |
| C. | Apply the filter by form command |
| D. | None of the above |
| Answer» B. Double click the record. | |
| 84. |
The following part of a database that holds only one type of information |
| A. | Report |
| B. | Query |
| C. | Record |
| D. | Field |
| Answer» E. | |
| 85. |
The ascending order of a data hierarchy ios: |
| A. | Bit, byte, field, record, file, database |
| B. | Bit, byte, record, field, file, database |
| C. | Byte, bit, field, record, file, database |
| D. | Byte, bit, record, field, file, database |
| Answer» E. | |
| 86. |
The ….. presents data in a way similar to an excel spreadsheet |
| A. | Datasheet view |
| B. | Design view |
| C. | Print preview |
| D. | Layout preview |
| Answer» D. Layout preview | |
| 87. |
Pack command is used to |
| A. | Remove records permanently |
| B. | Remove records temporarily |
| C. | Restore records permanently |
| D. | Restore records temporarily |
| Answer» B. Remove records temporarily | |
| 88. |
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» D. Forms | |
| 89. |
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» E. | |
| 90. |
DBMS allows you to create, interrogate, and maintain a database, create reports, and develop application programs, select the best fit answer |
| A. | Database management approach |
| B. | DBBMS uses |
| C. | Database administrator |
| D. | Query language |
| Answer» E. | |
| 91. |
The raw facts are called |
| A. | Data |
| B. | Programs |
| C. | Commands |
| D. | Responses |
| Answer» B. Programs | |
| 92. |
A treelike structure of records in a database.Select the best fit for answer |
| A. | Hierarchical database structure |
| B. | Relational database structure |
| C. | Multidimensional database structure |
| D. | Sequential database access |
| Answer» B. Relational database structure | |
| 93. |
A command that lets you cange one or morefields in a record is |
| A. | Insert |
| B. | Modify |
| C. | Look up |
| D. | All of the above |
| Answer» C. Look up | |
| 94. |
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» C. Html data pages | |
| 95. |
Where do report and forms get their information form? |
| A. | Forms |
| B. | Modules |
| C. | Tables |
| D. | Queries |
| Answer» D. Queries | |
| 96. |
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» C. Database | |
| 97. |
Which of the following is not a data type ? |
| A. | Picture/graphic |
| B. | Data/time |
| C. | Texst |
| D. | Number |
| Answer» B. Data/time | |
| 98. |
It Is used to build and modify database objects and also to create new queries |
| A. | Datasheet view |
| B. | Design view |
| C. | Print preview |
| D. | Layout preview |
| Answer» D. Layout preview | |
| 99. |
What is part of database that holds all of the information about one item or subject? |
| A. | Record |
| B. | File |
| C. | Query |
| D. | Chart |
| Answer» B. File | |
| 100. |
Memo field in database file is used to |
| A. | Store lengthy number |
| B. | Store images |
| C. | Store audio files |
| D. | Store long textual information |
| Answer» E. | |