MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 657 Mcqs, each offering curated multiple-choice questions to sharpen your Testing Subject knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
What does the expression [detail]! [product] * 1.30 do? |
| A. | a. multiplies the contents of detail and product fields by 1.3 |
| B. | b. First divides detail by product and then multiplies by 1.3 |
| C. | c. multiplies the contents of detail in the product table by 1.3 |
| D. | d. multiplies the contents of product in the detail table by 1.3 |
| Answer» E. | |
| 2. |
A disadvantage to a file is that there is no easy way to tell which fields are numbers, text, dates, or currency. |
| A. | a. standardized |
| B. | b. fixed |
| C. | c. delimited |
| D. | d. text |
| Answer» E. | |
| 3. |
The content and application of the Search tool CANNOT be retained when you_______. |
| A. | a. format an object |
| B. | b. resize a column |
| C. | c. use Datasheet View |
| D. | d. close an object |
| Answer» E. | |
| 4. |
The insertion point looks like a(n)__. |
| A. | a. H pointer |
| B. | b. I pointer |
| C. | c. H beam |
| D. | d. I beam |
| Answer» E. | |
| 5. |
what is the corresponding text for the |
| A. | a. Neter a value less or more than 1,195 |
| B. | b. Value must be less than 95 characters |
| C. | c. Enter a date before 1995 |
| D. | d. All of above |
| Answer» B. b. Value must be less than 95 characters | |
| 6. |
In the Relationship window, related fields from each table are connected by a(n)_____________. |
| A. | a. default field |
| B. | b. linking tables |
| C. | c. index |
| D. | d. join line |
| Answer» E. | |
| 7. |
The two form layout types will display multiple records at one time are tabular and |
| A. | a. columnar |
| B. | b. justified |
| C. | c. date sheet |
| D. | d. pivot table |
| Answer» C. c. date sheet | |
| 8. |
When you add fields in _____, a Field List pane displays. |
| A. | a. Design View |
| B. | b. Layout View |
| C. | c. Print Preview |
| D. | d. Report View |
| Answer» C. c. Print Preview | |
| 9. |
A_is a major database object used to display information in an attractive, easy to read screen format. |
| A. | a. form |
| B. | b. query |
| C. | c. report |
| D. | d. table |
| Answer» B. b. query | |
| 10. |
HTML stands for____. |
| A. | a. High Text Mail List |
| B. | b. Hyperlink Markup Language |
| C. | c. HyperText Markup Language |
| D. | d. Hyperlink Transfer Markup Language |
| Answer» D. d. Hyperlink Transfer Markup Language | |
| 11. |
Relationships between tables can be graphically viewed in the window. |
| A. | a. Design |
| B. | b. Joins |
| C. | c. Relationships |
| D. | d. Tables |
| Answer» D. d. Tables | |
| 12. |
Access file operations can be found by clicking the______. |
| A. | a. Access Button |
| B. | b. Database Button |
| C. | c. Office Button |
| D. | d. Window Button |
| Answer» D. d. Window Button | |
| 13. |
In a module, a(n)____is a series of commands and properties that perform a specific task. |
| A. | a. event |
| B. | b. property |
| C. | c. procedure |
| D. | d. macro |
| Answer» D. d. macro | |
| 14. |
An enterprise solution with data storage, a client interface and a security system is a(n)_________system. |
| A. | a. 2 tier |
| B. | b. 3 tier |
| C. | c. 4 tier |
| D. | d. n tier |
| Answer» C. c. 4 tier | |
| 15. |
The VB Name used to display the warning message icon is |
| A. | a. vbCritical |
| B. | b. vbInformation |
| C. | c. vbExclamation |
| D. | d. vbQuestion |
| Answer» D. d. vbQuestion | |
| 16. |
The______field is used to hold a yes or no answer. |
| A. | a. object |
| B. | b. number |
| C. | c. text |
| D. | d. logical |
| Answer» E. | |
| 17. |
Which of the following is not a database application ? |
| A. | a. dBase |
| B. | b. Flash |
| C. | c. FoxPro |
| D. | d. Access |
| Answer» C. c. FoxPro | |
| 18. |
The_operator will cause a record to be selected only if two or more conditions are satisfied |
| A. | a. Or |
| B. | b. If or |
| C. | c. Range |
| D. | d. And |
| Answer» E. | |
| 19. |
In Access 2007, to make changes in the Trust Center, you need to go to the__. |
| A. | a. Microsoft Office button |
| B. | b. Navigation Pane |
| C. | c. Quick Access toolbar |
| D. | d. Database Tools command tab |
| Answer» B. b. Navigation Pane | |
| 20. |
In a module, the VB Name used to display a warning query icon is_____. |
| A. | a. vbCritical |
| B. | b. vbInformation |
| C. | c. vbExclamation |
| D. | d. vbQuestion |
| Answer» E. | |
| 21. |
A(n)_________is dynamic mathematical calculation that displays a single value for a specific field. |
| A. | a. format row |
| B. | b. criteria row |
| C. | c. aggregate function |
| D. | d. format layout |
| Answer» D. d. format layout | |
| 22. |
A(n)____is major object that completes an action or a set of actions. |
| A. | a. event |
| B. | b. property |
| C. | c. procedure |
| D. | d. macro |
| Answer» E. | |
| 23. |
Before printing a datasheet, you can use_to determine whether to change the page orientation from portrait to vertical orientation. |
| A. | a. Design View |
| B. | b. Datasheet View |
| C. | c. Office View |
| D. | d. Print Preview |
| Answer» E. | |
| 24. |
Which of the following dialog boxes enables users to enforce referential integrity in a One To Many relationship? |
| A. | a. Edit Relationships |
| B. | b. Indexes |
| C. | c. Option |
| D. | d. Show Table |
| Answer» B. b. Indexes | |
| 25. |
To store your picture in a database requires a(n)____ field. |
| A. | a. BLOB |
| B. | b. text |
| C. | c. image |
| D. | d. logical |
| Answer» B. b. text | |
| 26. |
The_________determines how long you must hold down an alphanumeric key before the keyboard will repeat the character. |
| A. | a. strike rate |
| B. | b. repeat rate |
| C. | c. default rate |
| D. | d. threshold rate |
| Answer» C. c. default rate | |
| 27. |
A .is a flash memory storage device that plugins into a USB port |
| A. | a. USB snap drive |
| B. | b. USB flash drive |
| C. | c. USB memory maker drive |
| D. | d. None of above |
| Answer» C. c. USB memory maker drive | |
| 28. |
This type of query summarizes large amounts of data in easy to read, row and column format. |
| A. | a. Crosstab |
| B. | b. Columnar |
| C. | c. Select |
| D. | d. Action |
| Answer» B. b. Columnar | |
| 29. |
The_Smart Tag launches Microsoft Outlook to schedule an appointment or display a calendar. |
| A. | a. Date |
| B. | b. Time |
| C. | c. Calendar |
| D. | d. Appointment |
| Answer» B. b. Time | |
| 30. |
____is used to build 'intuitive' queries. |
| A. | a. SQL |
| B. | b. Xbase |
| C. | c. QBE |
| D. | d. XML |
| Answer» D. d. XML | |
| 31. |
To set a password for the database, select_________in the Microsoft Access open window. |
| A. | a. Open read only |
| B. | b. Open write only |
| C. | c. Open explicit |
| D. | d. Open exclusive |
| Answer» E. | |
| 32. |
________is the clear leader for personal databases. |
| A. | a. Microsoft Access |
| B. | b. Microsoft FoxPro |
| C. | c. Borland dBase |
| D. | d. MySQL |
| Answer» B. b. Microsoft FoxPro | |
| 33. |
To create a new table, in which method you don't need to specifythe field type and size? |
| A. | a. Create table in Design View |
| B. | b. Create Table using wizard |
| C. | c. Create Table by Entering data |
| D. | d. All of above |
| Answer» D. d. All of above | |
| 34. |
The Table_________Wizard analyzes a database and recommends changes for normalization. |
| A. | a. Analyzer |
| B. | b. Documenter |
| C. | c. Cleanup |
| D. | d. Normalization |
| Answer» B. b. Documenter | |
| 35. |
The expression builder is an access tool that controls an expression____for entering an expression |
| A. | a. Table |
| B. | b. Box |
| C. | c. Cell |
| D. | d. Palette |
| Answer» C. c. Cell | |
| 36. |
When creating an input mask this character does not require an entry, but if an entry is made it must be a letter from a z |
| A. | a. ? |
| B. | b. ! |
| C. | c. # |
| D. | d. \ |
| Answer» B. b. ! | |
| 37. |
The______function returns a string that has been converted to uppercase text. |
| A. | a. AllCap |
| B. | b. UCase |
| C. | c. UpCase |
| D. | d. Upper |
| Answer» C. c. UpCase | |
| 38. |
Both conditions display on the same row in the design grid when operator is in use |
| A. | a. OR |
| B. | b. IN |
| C. | c. AND |
| D. | d. LIKE |
| Answer» D. d. LIKE | |
| 39. |
___ allows you to resize controls, adjust column widths, move columns, and change labels while viewing the actual data in the report. |
| A. | a. Design View |
| B. | b. Layout View |
| C. | c. Print Preview |
| D. | d. Report View |
| Answer» C. c. Print Preview | |
| 40. |
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. | a. 5 |
| B. | b. 8 |
| C. | c. 24 |
| D. | d. Not enough information to tell |
| Answer» D. d. Not enough information to tell | |
| 41. |
You can automatically include all of the field in a table in a query by__ a strike that appear list box in query design view |
| A. | a. Clicking |
| B. | b. Right clicking |
| C. | c. Double clicking |
| D. | d. None of the above |
| Answer» D. d. None of the above | |
| 42. |
In the Field List of a table, the primary key appears |
| A. | a. bold |
| B. | b. italicized |
| C. | c. underlined |
| D. | d. with key icon |
| Answer» E. | |
| 43. |
In a table, _(s) are displayed in the order in which they were entered. Most often this order is not useful. |
| A. | a. formula |
| B. | b. format |
| C. | c. layout |
| D. | d. record |
| Answer» E. | |
| 44. |
To print information from a table, the____tool is the best choice. |
| A. | a. form |
| B. | b. report |
| C. | c. query |
| D. | d. macro |
| Answer» C. c. query | |
| 45. |
What happens when a user double clicks an object in the Project pane of the Visual Basic Editor? |
| A. | a. The associated code is displayed in the Code pane. |
| B. | b. The associated code is displayed in a new window. |
| C. | c. The object is deleted from the Project pane. |
| D. | d. The object\'s property sheet opens. |
| Answer» B. b. The associated code is displayed in a new window. | |
| 46. |
The______performs document tracking. |
| A. | a. distributed application |
| B. | b. enterprise software |
| C. | c. Oracle software |
| D. | d. EDM software |
| Answer» E. | |
| 47. |
In a query, using the keyword_________will return records in which the field value is between two numbers. |
| A. | a. Between |
| B. | b. Is Null |
| C. | c. Like |
| D. | d. Not |
| Answer» B. b. Is Null | |
| 48. |
The Search tool is best used when searching for_____data. |
| A. | a. simple |
| B. | b. multiple |
| C. | c. unique |
| D. | d. formatted |
| Answer» B. b. multiple | |
| 49. |
What is the difference between ‘Open'and ‘Open Exclusively'? |
| A. | a. Open statement opens access database files and Open Exclusively opens database files of other program like Oracle |
| B. | b. Open Exclusive locks whole database so that no one can access it whereas Open locks only the record that is being accessed |
| C. | c. Both Open and Open Exclusively are same |
| D. | d. Open Exclusive command does not exist in MS Access |
| Answer» C. c. Both Open and Open Exclusively are same | |
| 50. |
In a database table, the category odf information is called |
| A. | a. Tuple |
| B. | b. Field |
| C. | c. Record |
| D. | d. All of above |
| Answer» C. c. Record | |