MS Access MCQ Questions and Answers – Part 4
MS Access MCQ questions and answers for the preparation of tests, exams, and certifications. So you will find questions about Access Relational Database Management System. and much more. This systematic learning method will easily prepare anyone to pass their exam.
1. The fact of classifying the data in an order, is called ________
A Ordering
B Search
C Sorting
D Ascendant
2. A composite key is ________
A The primary key with AutoNumber as field type.
B Is a foreign key that uniquely identifies records.
C Consists of two or more fields to uniquely identify records.
D None of the above
3. An organized set of logically related data is called ________
A Database
B Metadata
C Information
D None of the above
4. HSAM means ________
A Hierarchic Standard and Method
B Hierarchic Sequential and Method
C Hierarchic Standard Access Method
D Hierarchic Sequential Access Method
5. In a data sheet, what does each row represent?
A Field
B Database
C Record
D All the answers are true
6. How you call a primary key field included in another table?
A Child key
B Composite key
C Parent key
D Foreign key
7. What is the full form of SQL?
A Structured Query Language
B Structured Question List
C Sophisticated Question List
D None of the above
8. What type of data is best used to store the price of an item?
A Number
B Text
C Financial
D Hypertext link
9. Which of the following data types is used to store a logical value in MS Access?
A Yes/No
B On/Off
C True/False
D None of the above
10. A query can be used to select data from _________
A From a single table
B From several tables
C Both A and B are true.
D None of the above
11. Data can be imported into the Access Database from _________
A Notepad files
B PowerPoint files
C Word files
D Excel files
12. In a query, using the keyword ______ returns records in which the field value is between two numbers.
A IS NUL
B LIKE
C AND
D BETWEEN
13. Using the keyword ______ returns records in which the field value is equal to a defined text.
A IS NUL
B LIKE
C AND
D BETWEEN
