MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 496 Mcqs, each offering curated multiple-choice questions to sharpen your Computer Fundamentals knowledge and support exam preparation. Choose a topic below to get started.
| 201. |
The _____ function returns a string that has been converted to uppercase text. |
| A. | AllCap |
| B. | UCase |
| C. | UpCase |
| D. | Upper |
| Answer» C. UpCase | |
| 202. |
In Access press UP ARROW or CTRL+UP ARROW |
| A. | Move the selected control to the right (except controls that are part of a layout) |
| B. | Move the selected control to the left (except controls that are part of a layout) |
| C. | Move the selected control up |
| D. | None of these |
| Answer» D. None of these | |
| 203. |
Which of the following is the file extension for an Extensible Markup Language? |
| A. | EML |
| B. | HTML |
| C. | XML |
| D. | XSD |
| Answer» D. XSD | |
| 204. |
__________ will answer questions you did not think to ask of your data. |
| A. | data mining |
| B. | data extrapolation |
| C. | knowledge discovery |
| D. | data enlightenment |
| Answer» D. data enlightenment | |
| 205. |
When using Access Database, use this feature to have Access select only certain records in the database to prepare form letters. |
| A. | Report |
| B. | Table |
| C. | Query |
| D. | Tools |
| Answer» D. Tools | |
| 206. |
Which of the following store command to retrieve data from database? |
| A. | Forms |
| B. | Reports |
| C. | Queries |
| D. | Tables |
| Answer» D. Tables | |
| 207. |
Which of the following statements about criteria in a query is NOT true? |
| A. | Criteria can contain wildcard characters. |
| B. | Criteria in a query selects or excludes certain records. |
| C. | Criteria cannot be specified as an expression. |
| D. | Multiple criteria can be specified using AND, OR, and relational operators. |
| Answer» D. Multiple criteria can be specified using AND, OR, and relational operators. | |
| 208. |
This type of database contains multiple tables that are connected to produce combined output from all tables. |
| A. | Bound |
| B. | Linked |
| C. | Relational |
| D. | Joined |
| Answer» D. Joined | |
| 209. |
Press the following keys in Access to Print the current or selected object |
| A. | CTRL+P |
| B. | P or CTRL+P |
| C. | S |
| D. | C or ESC |
| Answer» B. P or CTRL+P | |
| 210. |
Cascade delete option |
| A. | Is used to delete all the records of all tables in a database |
| B. | Will repeat the recent delete operation to all the records of current table |
| C. | Is available in edit relatiionship dialog box which makes sure that all the related records will be deleted automatically whn the record from parent table is deleted |
| D. | None of above |
| Answer» D. None of above | |
| 211. |
A(n) __________ is an Extensible Scheme Standard file that is an approved W3C standard design as a basic infrastructure. |
| A. | HTML |
| B. | XML |
| C. | XSD |
| D. | XSL |
| Answer» D. XSL | |
| 212. |
In Access to Increase the height of the selected control |
| A. | SHIFT+RIGHT ARROW |
| B. | SHIFT+DOWN ARROW |
| C. | DOWN ARROW or CTRL+DOWN ARROW |
| D. | None of these |
| Answer» C. DOWN ARROW or CTRL+DOWN ARROW | |
| 213. |
The Input Mask wizard does NOT include the ability to do which of the following? |
| A. | Force all uppercase |
| B. | Define placeholder |
| C. | Store symbols with data |
| D. | Use preset masks |
| Answer» B. Define placeholder | |
| 214. |
This type of query summarizes large amounts of data in easy-to-read, row-and-column format. |
| A. | Crosstab |
| B. | Columnar |
| C. | Select |
| D. | Action |
| Answer» B. Columnar | |
| 215. |
Which is NOT a method of creating a table? |
| A. | Datasheet View |
| B. | Design View |
| C. | Layout View |
| D. | Template |
| Answer» D. Template | |
| 216. |
What is the propose to a sub datasheet? |
| A. | To provide a hierarchial view of related tables or queries in a single window |
| B. | To display grouped data in a report |
| C. | To display summarized data. |
| D. | All of the above |
| Answer» B. To display grouped data in a report | |
| 217. |
What do you mean by one to many relationship between student and class table? |
| A. | One student can have many classes |
| B. | One class may have many student |
| C. | Many classes may have many students |
| D. | Many students may have manu classes |
| Answer» B. One class may have many student | |
| 218. |
In this form, a single record may appear in multiple rows in the form window in order to fully display the field name label and data. |
| A. | Datasheet |
| B. | Tabular |
| C. | Justified |
| D. | Columnar |
| Answer» D. Columnar | |
| 219. |
This is not one of the sections of the form design window |
| A. | Form footer |
| B. | Form content |
| C. | Form header |
| D. | Form detail |
| Answer» C. Form header | |
| 220. |
Which of the following is not a selection technique |
| A. | To select a word, double click the word |
| B. | To select an entire table click the empty bosx to the left of the field names |
| C. | To select a row, click the record selector box to the left of the row |
| D. | To select a column, double click anywhere in the column |
| Answer» E. | |
| 221. |
In Access to Move down one line |
| A. | F4 or ALT+DOWN ARROW |
| B. | DOWN ARROW |
| C. | PAGE DOWN |
| D. | F9 |
| Answer» C. PAGE DOWN | |
| 222. |
What is a form in MS Access |
| A. | It is a printed page where users will write their data to fill it up |
| B. | It is an input screen designed to make the viewing and entering data easier |
| C. | This is an important part of database used by analysts to draw conclusions |
| D. | All of above |
| Answer» C. This is an important part of database used by analysts to draw conclusions | |
| 223. |
When adding an image, which size mode will change the height or width of the image fit the control? |
| A. | Clip |
| B. | Stretch |
| C. | Zoom |
| D. | Crop |
| Answer» C. Zoom | |
| 224. |
What happens when you release mouse pointer after you drop the primary key of a table into foreign key of another table? |
| A. | A relationship is created |
| B. | Edit relationship dialog box appears |
| C. | Error occurs |
| D. | Nothing happens |
| Answer» C. Error occurs | |
| 225. |
The filter by selection feature allows you to filter |
| A. | Those records that match an entity in a field |
| B. | Records based on a criterion you specify |
| C. | Records that meet any of several criteria you specify |
| D. | All of above |
| Answer» B. Records based on a criterion you specify | |
| 226. |
Which of the following creates a drop down list of values to choose from a list? |
| A. | OLE Object |
| B. | Hyperlink |
| C. | Memo |
| D. | Lookup Wizard |
| Answer» E. | |
| 227. |
Search engines use a(n) __________ to automatically index sites. |
| A. | crawler |
| B. | query |
| C. | enterprise |
| D. | sitebuilder |
| Answer» B. query | |
| 228. |
This form displays data in a table layout with field name labels across the top of the page and the corresponding data in rows and columns under each heading. |
| A. | Columnar |
| B. | Justified |
| C. | Datasheet |
| D. | Tabular |
| Answer» E. | |
| 229. |
What data type should yo choose for a zip code field in a table? |
| A. | Text |
| B. | Number |
| C. | Memo |
| D. | All of above |
| Answer» B. Number | |
| 230. |
In the second subform wizard dialog box you specify the table to use as the data source and the |
| A. | Records from the selected form |
| B. | Form from the selected table |
| C. | Fields from the selected table |
| D. | Content from the selected form |
| Answer» D. Content from the selected form | |
| 231. |
To align controls in rows and columns like a spreadsheet, with labels across the top, which layout should be used? |
| A. | Datasheet |
| B. | Justified |
| C. | Stacked |
| D. | Tabular |
| Answer» E. | |
| 232. |
Which of the following is the default join between two recordsets? |
| A. | Inner join |
| B. | Left outer join |
| C. | Right outer join |
| D. | Self join |
| Answer» B. Left outer join | |
| 233. |
What is the difference between ‘open’ and ‘open exclusively’ |
| A. | Open statement opens access database files and open exclusively opens database files of other program like oracle |
| B. | Open exclusive locks whole database so that no one can access it whereas open locks only the record that is being accessed |
| C. | Both open and open exclusively are same |
| D. | Open exclusive command does not exist in MS Access |
| Answer» C. Both open and open exclusively are same | |
| 234. |
To print information from a table, the __________ tool is the best choice. |
| A. | form |
| B. | report |
| C. | query |
| D. | macro |
| Answer» C. query | |
| 235. |
Saving a database in access is done |
| A. | At the beginning of the database |
| B. | The first time you save data |
| C. | When closing the application |
| D. | During auto save |
| Answer» B. The first time you save data | |
| 236. |
Queries are based on this, allowing you to use a query as the source for forms and reports |
| A. | Filters |
| B. | Tables |
| C. | Records |
| D. | Fields |
| Answer» C. Records | |
| 237. |
In access press to Move to the next page of the wizard |
| A. | TAB |
| B. | ALT+N |
| C. | ALT+B |
| D. | ALT+F |
| Answer» C. ALT+B | |
| 238. |
It is a database object to view, change, and analyze data in different ways |
| A. | query |
| B. | form |
| C. | report |
| D. | None of the above |
| Answer» B. form | |
| 239. |
Using the keyword _______________ will return records in which the field value equals a defined text. |
| A. | Between |
| B. | Is Null |
| C. | Like |
| D. | Not |
| Answer» D. Not | |
| 240. |
Which of the following functions is used to all the values in a numeric field? |
| A. | Num |
| B. | Count |
| C. | Sum |
| D. | Total |
| Answer» C. Sum | |
| 241. |
Which of the following field properties is an expression that specifies criteria or requirements for entering data? |
| A. | Field Size |
| B. | Format |
| C. | Input Mask |
| D. | Validation Rule |
| Answer» E. | |
| 242. |
The result of a query is displayed in a |
| A. | Record |
| B. | Query datasheet |
| C. | Query table |
| D. | Form |
| Answer» C. Query table | |
| 243. |
When you add fields in ____, a Field List pane displays. |
| A. | Design View |
| B. | Layout View |
| C. | Print Preview |
| D. | Report View |
| Answer» C. Print Preview | |
| 244. |
The __________ is used to access one record at a time. |
| A. | query |
| B. | filter |
| C. | form |
| D. | report |
| Answer» D. report | |
| 245. |
You created a query with two tables that have relationship of One-To-Many with referential rules applied. The first table has 3 records and the second has 8. With using a right outer join, how many records will the resulting recordset have? |
| A. | 5 |
| B. | 8 |
| C. | 24 |
| D. | Not enough information to tell |
| Answer» D. Not enough information to tell | |
| 246. |
In a database table, the category of information is called ____________ |
| A. | tuple |
| B. | field |
| C. | record |
| D. | All of above |
| Answer» C. record | |
| 247. |
Press the following keys in Access to Open the Print dialog box from Print Preview |
| A. | CTRL+P |
| B. | P or CTRL+P |
| C. | S |
| D. | C or ESC |
| Answer» C. S | |
| 248. |
In Access press PAGE UP |
| A. | Move up one line |
| B. | Move up one page |
| C. | Exit the combo box or list box |
| D. | None of these |
| Answer» C. Exit the combo box or list box | |
| 249. |
Which of the following is not one of the methods available in the new query dialog box to create queries? |
| A. | Design view |
| B. | Crosstab query wizard |
| C. | Simple query wizard |
| D. | Datasheet view |
| Answer» E. | |
| 250. |
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» E. | |