MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 10 Mcqs, each offering curated multiple-choice questions to sharpen your Computer Science knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
To define AND condition while entering criteria in a query design window we write _______ |
| A. | Criteria values vertically one in a row |
| B. | Criteria values horizontally |
| C. | Write criteria values separated by AND |
| D. | Write criteria values using & ( anchor and ) sign |
| Answer» C. Write criteria values separated by AND | |
| 2. |
Thecommandcenter of Access File thatappearswhen wecreateor open the MSAccess databaseFile. |
| A. | Database Window |
| B. | Query Window |
| C. | Design View Window |
| D. | Switchboard |
| Answer» B. Query Window | |
| 3. |
The upper part of the query design window in MS Access has two parts shows ____________ |
| A. | Fields name with field size |
| B. | Fields name with relationships |
| C. | Fields and Criteria |
| D. | Sorting Options |
| Answer» C. Fields and Criteria | |
| 4. |
The small button with three dots displayed at the right of field properties box is called : |
| A. | Make Button |
| B. | Expression Button |
| C. | Build Button |
| D. | None Of Above |
| Answer» D. None Of Above | |
| 5. |
The size of yes/no field is always ________ |
| A. | 1 Bit |
| B. | 1 Byte |
| C. | 1 Character |
| D. | 1 KB |
| Answer» B. 1 Byte | |
| 6. |
The size of a field with number data type can not be _____ |
| A. | 2 |
| B. | 4 |
| C. | 8 |
| D. | 16 |
| Answer» E. | |
| 7. |
The columns in a microsoft access table are also called _______ |
| A. | Rows |
| B. | Records |
| C. | Fields |
| D. | Columns |
| Answer» D. Columns | |
| 8. |
Queries in MS Access can be used ____________ |
| A. | To view data |
| B. | As source for Forms |
| C. | As source for Reports |
| D. | All of These |
| Answer» E. | |
| 9. |
If you write criteria values one in a row in query design window, that means you are specifying _____ |
| A. | OR conditions |
| B. | AND conditions |
| C. | NOT condition |
| D. | ALL conditions |
| Answer» B. AND conditions | |
| 10. |
A search value in SQL query can be a specific value or it can be ________ |
| A. | Logical Operator |
| B. | Relationship |
| C. | Wild card character |
| D. | Comparison operation |
| Answer» D. Comparison operation | |