Microsoft Access 1000+ MCQ with answer for RRB Group D
Thursday 9th of March 2023
1. To create queries in Access
A. You can drag and drop fields on query builders
B. you can type the SQL command in SQL view
C. You can use query wizard or design view
D. All of above
Answer : D
2. Which field type can store photos?
A. Hyperlink
B. OLE
C. Both of these can be used
D. Access tables cant store photos
Answer : B
3. A composite key is
A. Required when a table does not have any unique fields in it
B. The primary key with AutoNumber as the field type
C. Made up of two or more fields to uniquely identify records
D. Is a foreign key that uniquely identifies records
Answer : C
4. A database language concerned with the definition of the whole database structure and schema is ________
A. DCL
B. DML
C. DDL
D. All of above
Answer : C
5. Unlike text data type, this can store up to maximum of 65, 535 characters.
A. memo
B. data/time
C. number
D. All of above
Answer : A
6. A database object in MS Access that stores a question about the data in database?
A. Table
B. Form
C. Query
D. Report
Answer : C
7. A database can be best described as
A. Organized collection of data
B. Useful presentation of data
C. Graphical representation of data
D. All of above
Answer : A
8. What happens when you release mouse pointer after you drop the primary key of a table into foreign key of another table?
A. A relationship is created
B. Edit relationship dialog box appears
C. Error occurs
D. Nothing happens
Answer : B
9. Which of the following creates a drop down list of values to choose from a list?
A. OLE Object
B. Hyperlink
C. Memo
D. Lookup Wizard
Answer : D
10. The task of arranging data in order is called
A. Searching
B. Sorting
C. Ordering
D. Shorting
Answer : B
11. Query design window has two parts. The upper part shows
A. Name of fields, field type and size
B. Tables with fields and relationships between tables
C. Criteria
D. Sorting check boxes
Answer : B
12. How can you define a field so that when entering data for that field it will display ****** instead of actual typed text
A. Input mask
B. Validation Rule
C. Indexed
D. IME Mode
Answer : A
13. Which field type will you select when creating a new table if you require to enter long text in that field?
A. Text
B. Memo
C. Currency
D. Hyperlink
Answer : B
14. Which of the following is not a database object in MS Access?
A. Tables
B. Query
C. Report
D. Relationship
Answer : D
15. It is a query that when run displays its own dialog box prompting you for information, such as
A. Select
B. crosstab
C. Parameter
D. Append
Answer : C
16. Which of the following store command to retrieve data from database?
A. Forms
B. Reports
C. Queries
D. Tables
Answer : C
17. Each record is constituted by a number of individual data items which are called
A. Fields
B. Data Types
C. Relations
D. Tables
Answer : A
18. Two tables can be linked with relationship so that the data integrity can be enforced. Where can you find Relationship Command?
A. Home Tab
B. Create Tab
C. External Data Tab
D. Database Tab
Answer : D
19. This is the stage in database design where one gathers and lists all the necessary fields for the database project.
A. data definition
B. data refinement
C. establishing relationship
D. none of the above
Answer : A
20. The__ button on the tool box display data from a related table
A. Sub form sub report
B. Relationships
C. Select objects
D. More controls
Answer : A
21. Which of the following database object hold data?
A. Forms
B. Reports
C. Queries
D. Tables
Answer : D
22. If you need to edit a relationship
A. Right click the relationship line and choose Edit Relationship
B. Double click the relationship line
C. Both of above
D. None of above
Answer : C
23. Which of the following is a method to create a new table in MS Access?
A. Create table in Design View
B. Create Table using wizard
C. Create Table by Entering data
D. All of above
Answer : D
24. It is a database object to view, change, and analyze data in different ways
A. query
B. form
C. report
D. None of the above
Answer : A