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. |
The three parts of an IIF function are separated by___. |
| A. | a. dashes |
| B. | b. asterisks |
| C. | c. semicolons |
| D. | d. commas |
| Answer» E. | |
| 2. |
A DBMS that runs on many different operating systems is said to be________. |
| A. | a. scalable |
| B. | b. robust |
| C. | c. platform independent |
| D. | d. distributed |
| Answer» D. d. distributed | |
| 3. |
The __ is a wild card that represents one or more characters. |
| A. | a. question mark |
| B. | b. asterisk |
| C. | c. exclamation mark |
| D. | d. dollar sign |
| Answer» C. c. exclamation mark | |
| 4. |
SQL stands for_____. |
| A. | a. Standard Query Language |
| B. | b. Structured Query Language |
| C. | c. Simplified Query Language |
| D. | d. Static Query Language |
| Answer» C. c. Simplified Query Language | |
| 5. |
According to access help, what's a good way to design a database? |
| A. | a. Start from data access pages and work backward |
| B. | b. Sketch the design of your database using a pencil and paper |
| C. | c. Use the table analyzer to reverse engineer your flat source data. |
| D. | d. None of above |
| Answer» C. c. Use the table analyzer to reverse engineer your flat source data. | |
| 6. |
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. | a. Object viewer |
| B. | b. Object browser |
| C. | c. Type library spy |
| D. | d. None of above |
| Answer» C. c. Type library spy | |
| 7. |
A global join will be created automatically when using tables in a(n)____. |
| A. | a. form |
| B. | b. report |
| C. | c. query |
| D. | d. field |
| Answer» C. c. query | |
| 8. |
The option button_identifies each button or check box in an option group. |
| A. | a. event |
| B. | b. frame |
| C. | c. label |
| D. | d. value |
| Answer» D. d. value | |
| 9. |
Search engines use a(n)______to automatically index sites. |
| A. | a. crawler |
| B. | b. query |
| C. | c. enterprise |
| D. | d. sitebuilder |
| Answer» B. b. query | |
| 10. |
Using the keyword______________will return records in which the field value equals a defined text. |
| A. | a. Between |
| B. | b. Is Null |
| C. | c. Like |
| D. | d. Not |
| Answer» D. d. Not | |
| 11. |
The quickest way to add a field to the selected fields list is to double click its field name in this list. |
| A. | a. Find fields |
| B. | b. Search fields |
| C. | c. Search record |
| D. | d. Available fields |
| Answer» E. | |
| 12. |
You have field 'Sex’ oftype Byte Number. How to limit its value to 0 and 1 only? |
| A. | a. By setting required to 'Yes' |
| B. | b. By using default value |
| C. | c. By defining validation rule |
| D. | d. By using format |
| Answer» D. d. By using format | |
| 13. |
To remove all Sorts in a table you can click the_ command. |
| A. | a. Clear All Sorts |
| B. | b. Delete All Sorts |
| C. | c. Eliminate All Sorts |
| D. | d. Remove All Sorts |
| Answer» B. b. Delete All Sorts | |
| 14. |
The______is used to access one record at a time. |
| A. | a. query |
| B. | b. filter |
| C. | c. form |
| D. | d. report |
| Answer» D. d. report | |
| 15. |
A_____enables you to view data from a table based on a specific criterion |
| A. | a. Form |
| B. | b. Query |
| C. | c. Macro |
| D. | d. Report |
| Answer» C. c. Macro | |
| 16. |
In a query\'s Design View, right clicking the sloping portion of the join line between two tables and selecting Delete will delete what? |
| A. | a. The join line but not the relationship between the two tables |
| B. | b. The relationship between the two tables locally |
| C. | c. The relationship between the two tables globally |
| D. | d. The primary key of the first table |
| Answer» C. c. The relationship between the two tables globally | |
| 17. |
A(n)__is an image control that displays in the background of a page on a form or report. |
| A. | a. legend |
| B. | b. icon |
| C. | c. logo |
| D. | d. watermark |
| Answer» E. | |
| 18. |
A(n)_________is an Extensible Scheme Standard file that is an approved W3C standard design as a basic infrastructure. |
| A. | a. HTML |
| B. | b. XML |
| C. | c. XSD |
| D. | d. XSL |
| Answer» D. d. XSL | |
| 19. |
Print options can be changed in the Print_. |
| A. | a. tab |
| B. | b. layout mode |
| C. | c. setup routine |
| D. | d. dialog box |
| Answer» E. | |
| 20. |
The option group_____describes the contents of the entire option group. |
| A. | a. event |
| B. | b. frame |
| C. | c. label |
| D. | d. value |
| Answer» D. d. value | |
| 21. |
A(n)___is the default controlfor a Yes/No field. |
| A. | a. check box |
| B. | b. option button |
| C. | c. toggle button |
| D. | d. list box |
| Answer» B. b. option button | |
| 22. |
A(n)________query makes changes to or moves records in a dynaset, in a single operation. |
| A. | a. select |
| B. | b. summary |
| C. | c. parameter |
| D. | d. action |
| Answer» E. | |
| 23. |
A ______ enables you to view data from a table based on a specific criterion |
| A. | a. Form |
| B. | b. Query |
| C. | c. Macro |
| D. | d. Report |
| Answer» C. c. Macro | |
| 24. |
A(n)_is a control that, when clicked, executes an action or series of actions. |
| A. | a. combo box control |
| B. | b. AutoFormat |
| C. | c. Conditional Format |
| D. | d. command button |
| Answer» E. | |
| 25. |
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 | |
| 26. |
In a junction table, the____field consists of the foreign key from both the linked tables. |
| A. | a. first defined |
| B. | b. last defined |
| C. | c. foreign key |
| D. | d. primary key |
| Answer» D. d. primary key | |
| 27. |
The_________is the software tool to store or access data. |
| A. | a. table |
| B. | b. DBMS |
| C. | c. query |
| D. | d. report |
| Answer» C. c. query | |
| 28. |
________will answer questions you did not think to ask of your data. |
| A. | a. data mining |
| B. | b. data extrapolation |
| C. | c. knowledge discovery |
| D. | d. data enlightenment |
| Answer» D. d. data enlightenment | |
| 29. |
If I create ‘Student'field in ‘Fees' table to store ‘studentjd’ of ‘Students' table, then this 'Student'field in ‘Fees' table is called: |
| A. | a. Foreign key |
| B. | b. Native key |
| C. | c. Composite key |
| D. | d. Primary key |
| Answer» B. b. Native key | |
| 30. |
Referential integrity can be enforced if both_______ belong to the same Microsoft Access database. |
| A. | a. queries |
| B. | b. fields |
| C. | c. records |
| D. | d. tables |
| Answer» E. | |
| 31. |
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. | |
| 32. |
In Access 2007, to set a table to open as a document tab, 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 | |
| 33. |
In Datasheet View, new records are added to a table___. |
| A. | a. in alphabetical order |
| B. | b. at the end of the table |
| C. | c. at the beginning of the table |
| D. | d. in numerical order |
| Answer» C. c. at the beginning of the table | |
| 34. |
All attachment fields display as a(n)____in Datasheet View. |
| A. | a. icon |
| B. | b. button |
| C. | c. thumb tack |
| D. | d. paperclip |
| Answer» E. | |
| 35. |
A(n)_in the Record Selector indicates a new record. |
| A. | a. check mark |
| B. | b. pencil |
| C. | c. asterisk |
| D. | d. arrow |
| Answer» D. d. arrow | |
| 36. |
Unlike text data type, this can store up to maximum of65, 535 characters. |
| A. | a. Memo |
| B. | b. Data/time |
| C. | c. Number |
| D. | d. All of above |
| Answer» B. b. Data/time | |
| 37. |
In one to many relationship the table in 'one'side is called and on 'many'side is called |
| A. | a. Child , Parent |
| B. | b. Parent , Child |
| C. | c. Brother , Sister |
| D. | d. Father , Son |
| Answer» C. c. Brother , Sister | |
| 38. |
_____are documents that when filled in create records. |
| A. | a. Forms |
| B. | b. Reports |
| C. | c. Tables |
| D. | d. Queries |
| Answer» B. b. Reports | |
| 39. |
A user interface that is easy to use is considered to be |
| A. | a. User happy |
| B. | b. User simple |
| C. | c. User friendly |
| D. | d. None of the above |
| Answer» D. d. None of the above | |
| 40. |
.. is the program run on a computer when the computer boots up |
| A. | a. System software |
| B. | b. Operating system |
| C. | c. System operations |
| D. | d. None |
| Answer» C. c. System operations | |
| 41. |
A ....allows you to write on screen with a digital pen and convert that writing into characters that the PC can process |
| A. | a. Monitor RS |
| B. | b. Tablet PC |
| C. | c. Database manager |
| D. | d. Media Center |
| Answer» C. c. Database manager | |
| 42. |
What determines a table's sort order? |
| A. | a. AutoNumber field |
| B. | b. Index field |
| C. | c. Field order |
| D. | d. Primary key |
| Answer» C. c. Field order | |
| 43. |
A Smart Tag can be set using the_____tab in the property sheet. |
| A. | a. Format |
| B. | b. Tag |
| C. | c. View |
| D. | d. Data |
| Answer» E. | |
| 44. |
Which of the following Operating systems is better for implementing a Client Server network |
| A. | a. MS DOS |
| B. | b. Windows 95 |
| C. | c. Windows 98 |
| D. | d. Windows 2000 |
| Answer» E. | |
| 45. |
To delete records or perform calculations on a table, the best tool to use is a_______. |
| A. | a. query |
| B. | b. filter |
| C. | c. form |
| D. | d. report |
| Answer» B. b. filter | |
| 46. |
A___is a major database object used to display information in a printable page format. |
| A. | a. form |
| B. | b. query |
| C. | c. report |
| D. | d. table |
| Answer» D. d. table | |
| 47. |
______The page count of a report can be determined by clicking the _________button. |
| A. | a. First Page |
| B. | b. Previous |
| C. | c. Next |
| D. | d. Last Page |
| Answer» E. | |
| 48. |
A(n) is a major object that can run independent of a control. |
| A. | a. event |
| B. | b. property |
| C. | c. procedure |
| D. | d. macro |
| Answer» E. | |
| 49. |
A__ name must be unique within a database |
| A. | a. Table |
| B. | b. Field |
| C. | c. Record |
| D. | d. Character |
| Answer» B. b. Field | |
| 50. |
The ability of a database to grow as the data tracking needs grow is its________. |
| A. | a. scalability |
| B. | b. expandability |
| C. | c. maintainability |
| D. | d. platform independence |
| Answer» B. b. expandability | |