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. |
Any report, including a basic report, can be modified in _____. |
| A. | Print Preview |
| B. | Report View |
| C. | Layout View |
| D. | All of the above |
| Answer» D. All of the above | |
| 2. |
Which of the following data type is used to store logical value in MS Access ? |
| A. | Yes/No |
| B. | On/Off |
| C. | True/False |
| D. | All of the above |
| Answer» B. On/Off | |
| 3. |
What are the columns in a Microsoft Access table called ? |
| A. | Reports |
| B. | Rows |
| C. | Fields |
| D. | Records |
| Answer» D. Records | |
| 4. |
Which data type is better to use for storing the price of an item? |
| A. | Text |
| B. | AutoNumber |
| C. | Number |
| D. | Currency |
| Answer» E. | |
| 5. |
What does the expression [detail] ! [product] * 1.30 do? |
| A. | multiplies the contents of detail and product fields by 1.3 |
| B. | First divides detail by product and then multiplies by 1.3 |
| C. | multiplies the contents of detail in the product table by 1.3 |
| D. | multiplies the contents of product in the detail table by 1.3 |
| Answer» E. | |
| 6. |
To create relationship between two tables |
| A. | drag any field from parent table and drop on child table |
| B. | drag the foreign key of a table into the primary key of another table |
| C. | drag the primary key of a table into foreign key of another table |
| D. | None of the above |
| Answer» D. None of the above | |
| 7. |
What do you call a primary key field included in another table ? |
| A. | Child key |
| B. | Composite key |
| C. | Parent key |
| D. | Foreign key |
| Answer» E. | |
| 8. |
You have field ‘Sex’ of type Byte Number. How to limit its value to 0 and 1 only? |
| A. | By setting required to ‘Yes’ |
| B. | By using default value |
| C. | By defining validation rule |
| D. | By using format |
| Answer» D. By using format | |
| 9. |
This Is The Stage In Database Design Where One Gathers And List All The Necessary Fields For The Database Project. |
| A. | Data Definition |
| B. | Data Refinement |
| C. | Establishing Relationship |
| D. | None Of The Above |
| Answer» B. Data Refinement | |
| 10. |
In MS Access, Text Data type may contain maximum character of |
| A. | 255 Character |
| B. | 256 Character |
| C. | 1064 Character |
| D. | No Limit |
| Answer» B. 256 Character | |
| 11. |
What determines a table’s sort order? |
| A. | AutoNumber field |
| B. | Index field |
| C. | Field order |
| D. | Primary key |
| Answer» C. Field order | |
| 12. |
This Key Uniquely Identifies Each Record |
| A. | Primary Key |
| B. | Key Record |
| C. | Unique Key |
| D. | Field Name |
| Answer» B. Key Record | |
| 13. |
HSAM stands for ________ |
| A. | Hierarchic Standard and Method |
| B. | Hierarchic Sequential and Method |
| C. | Hierarchic Standard Access Method |
| D. | Hierarchic Sequential Access Method |
| Answer» E. | |
| 14. |
What is the result of ‘Select * from customer where CustID>10 and CustID |
| A. | display all customers with CustID from 10 to 100 |
| B. | display all customers with CustID above 10 |
| C. | display all customers with CustID below 100 |
| D. | display all customers with CustID from 11 to 99 |
| Answer» E. | |
| 15. |
Which object is used to create a form? |
| A. | Tables and Queries |
| B. | Tables only |
| C. | Tables and reports |
| D. | Queries and reports |
| Answer» B. Tables only | |
| 16. |
MS-Access is a type of? |
| A. | Utility software |
| B. | Application Software |
| C. | System software |
| D. | None |
| Answer» C. System software | |
| 17. |
Which query do you use to answer the question “What is the average salary of the employees”? |
| A. | Search query |
| B. | Cross tab query |
| C. | Select query |
| D. | Update query |
| Answer» D. Update query | |
| 18. |
A _______ enables you to view data from a table based on a specific criterion |
| A. | Query |
| B. | Report |
| C. | Form |
| D. | All of the above |
| Answer» B. Report | |
| 19. |
Which criteria return only those addresses beginning with the letter “K”? |
| A. | address = “K” |
| B. | address = “K*” |
| C. | address = “K?” |
| D. | address = “K#” |
| Answer» C. address = “K?” | |
| 20. |
MDE file does not contain? |
| A. | Macros |
| B. | Tables |
| C. | Queries |
| D. | Source code |
| Answer» E. | |
| 21. |
Which of the following data type is used to store logical value in MS Access? |
| A. | True/False |
| B. | On/Off |
| C. | Yes/No |
| D. | All of Above |
| Answer» D. All of Above | |
| 22. |
Which of the following the AutoCalc command on the toolbar provides in MS-Access? |
| A. | Sum |
| B. | Count |
| C. | Min |
| D. | All of the above |
| Answer» E. | |
| 23. |
A database makes it unreadable in MS-Access is called? |
| A. | Encode |
| B. | Database |
| C. | Decode |
| D. | None |
| Answer» B. Database | |
| 24. |
In MS-Access the maximum length of validation text is? |
| A. | 126 |
| B. | 129 |
| C. | 234 |
| D. | 255 |
| Answer» E. | |
| 25. |
This is the stage in database design where one gathers and lists all the necessary fields for the database project. |
| A. | data dictionary |
| B. | data refinement |
| C. | data definition |
| D. | none of the above |
| Answer» D. none of the above | |
| 26. |
The______ operator will cause a record to be selected only if two or more conditions are satisfied |
| A. | NOT |
| B. | XOR |
| C. | OR |
| D. | AND |
| Answer» E. | |
| 27. |
Following Is Not A Database Model |
| A. | Network Database Model |
| B. | Relational Database Model |
| C. | Object Oriented Database Model |
| D. | None |
| Answer» E. | |
| 28. |
Which field type can store photos ? |
| A. | Hyperlink |
| B. | OLE |
| C. | Memo |
| D. | Text |
| Answer» C. Memo | |
| 29. |
Which of the following is use to get data from user ? |
| A. | Query |
| B. | Form |
| C. | Report |
| D. | Table |
| Answer» C. Report | |
| 30. |
In which order do you place the field to sort a Dynaset first by zipcode, then by lastname and then by firstname? |
| A. | zipcode, firstname, lastname |
| B. | firstname, lastname, zipcode |
| C. | zipcode, lastname, firstname |
| D. | can’t sort by multiple fields |
| Answer» D. can’t sort by multiple fields | |
| 31. |
The Third Stage In Designing A Database Is When We Analyze Our Tables More Closely And Create A ___________ Between Tables |
| A. | Relationship |
| B. | Join |
| C. | Query |
| D. | None of these |
| Answer» B. Join | |
| 32. |
Which of the following is not a logical database structure? |
| A. | Chain |
| B. | Network |
| C. | Tree |
| D. | Relational |
| Answer» B. Network | |
| 33. |
Which of the following is not a valid relationship in MS-Access? |
| A. | One to one relationship |
| B. | One to many relationship |
| C. | One to two relationship |
| D. | Many to many relationship |
| Answer» D. Many to many relationship | |
| 34. |
Which data type is better to use for storing the price of an item ? |
| A. | Number |
| B. | Text |
| C. | Currency |
| D. | Hyperlink |
| Answer» D. Hyperlink | |
| 35. |
After right click the field selector button, which do you choose to delete a field in design view? |
| A. | Delete field |
| B. | delete rows |
| C. | remove field |
| D. | remove rows |
| Answer» C. remove field | |
| 36. |
Which of the following is not a data type in MS-Access? |
| A. | Table |
| B. | Number |
| C. | Text |
| D. | OLE object |
| Answer» B. Number | |
| 37. |
_______ is a field property that determines what kind of data a field can store? |
| A. | File type |
| B. | Data type |
| C. | Data select |
| D. | None of these |
| Answer» D. None of these | |
| 38. |
In MS-Access, minimum of _________data types can be assigned to a field? |
| A. | 2 |
| B. | 6 |
| C. | 7 |
| D. | 10 |
| Answer» E. | |
| 39. |
_______ is a component of database such as a table, query, form and macro? |
| A. | Record |
| B. | Object |
| C. | Table |
| D. | None of these |
| Answer» C. Table | |
| 40. |
Which of the following is not a layout in the form design? |
| A. | Autoform Layout |
| B. | Justified Layout |
| C. | Columnar |
| D. | Database |
| Answer» B. Justified Layout | |
| 41. |
Which of the following is not a data base application? |
| A. | Access |
| B. | dBase |
| C. | edit |
| D. | FoxPro |
| Answer» D. FoxPro | |
| 42. |
MS-Access is a |
| A. | Programming Tool |
| B. | Database Tool |
| C. | Web Page Creation Tool |
| D. | None of the Above |
| Answer» C. Web Page Creation Tool | |
| 43. |
MS-Access database files have a default extension? |
| A. | DBM |
| B. | PRG |
| C. | MDE |
| D. | BBE |
| Answer» D. BBE | |
| 44. |
How we save database file in MS Access 2007 for Ms Access 2000? |
| A. | Save As MS Access 2000 Database |
| B. | Save Only |
| C. | Save Object As |
| D. | None of these |
| Answer» B. Save Only | |
| 45. |
In MS-Access, what Are The Different Views To Display a table? |
| A. | Datasheet View |
| B. | Design View |
| C. | Pivot Table and Pivot Chart View |
| D. | All of the above |
| Answer» E. | |
| 46. |
How many save as option in MS Access 2007? |
| A. | 1 |
| B. | 2 |
| C. | 3 |
| D. | 4 |
| Answer» D. 4 | |
| 47. |
Which of the following is latest version of MS-Access? |
| A. | MS-Access 2002 |
| B. | MS-Access 2000 |
| C. | MS-Access ME |
| D. | MS-Access XP |
| Answer» E. | |
| 48. |
How do you rearrange the date in ascending or descending order? |
| A. | Data, table |
| B. | Data, sort |
| C. | Data, form |
| D. | Data, subtotals |
| Answer» C. Data, form | |
| 49. |
To merge the cells which tab do you use from the format, cells menu? |
| A. | Merge tab |
| B. | Number tab |
| C. | Alignment tab |
| D. | Font tab |
| Answer» D. Font tab | |
| 50. |
An organized collection of logically related data is known as |
| A. | Database |
| B. | Meta data |
| C. | Information |
| D. | None of the above |
| Answer» B. Meta data | |