computer general knowledge MCQs

By: Prof. Dr. Fazal Rehman | Last updated: May 2, 2025

1. Which database object holds data?
(A) Tables
(B) Reports
(C) Queries
(D) Forms

2. Which button on the toolbox displays data from a related table?
(A) More controls
(B) Relationships
(C) Select objects
(D) Sub form sub report

3. The Expression Builder in Access controls and enters expressions in a:
(A) Box
(B) Table
(C) Cell
(D) Palette

4. Which tool enables you to view data from a table based on a specific criterion?
(A) Form
(B) Macro
(C) Query
(D) Report

5. Which database object produces the final result to present?
(A) Forms
(B) Queries
(C) Reports
(D) Tables

6. What is the default and maximum size of a text field in Access?
(A) 266 characters & 64000 characters
(B) 8 and 1 GB
(C) 50 and 255 Characters
(D) All of these

7. What is the Cascade Update option used for?
(A) Change all related records in child tables if the record in the parent table is changed
(B) Do not change the primary key if related records exist
(C) Both of above
(D) All of these

8. How can you set a control’s border type to make the border invisible in MS Access?
(A) Do not display
(B) Transparent
(C) No border
(D) None of these

9. Which database language allows you to access or maintain data in a database?
(A) DML
(B) DCL
(C) DDL
(D) Both A and C

10. What does Referential Integrity mean in MS Access?
(A) Do not enter a value in the foreign key field of a parent table if that value does not exist in the primary key of the child table
(B) Do not enter a value in the primary key field of a child table if that value does not exist in the primary key of the parent table
(C) Do not enter a value in the foreign key field of a child table if that value does not exist in the primary key of the parent table
(D) All of above

11. Which name must be unique within a database in MS Access?
(A) Record
(B) Field
(C) Table
(D) Character

12. What is the association built between common fields of two tables called?
(A) Relationship
(B) Line
(C) Primary key
(D) Records

13. Which of the following is not a field type in Access?
(A) Lookup Wizard
(B) Hyperlink
(C) OLE Object
(D) Memo

14. What is the maximum number of characters allowed in a field name?
(A) 64
(B) 60
(C) 68
(D) Any number of characters

15. Which database object is used to view, change, and analyze data in different ways?
(A) Report
(B) Form
(C) Query
(D) None of the above

16. Which is used to create a drop-down list of values?
(A) OLE Object
(B) Lookup Wizard
(C) Memo
(D) Hyperlink

17. The search value can be an exact value or it can be a:
(A) Wild card character
(B) Relationship
(C) Logical Operator
(D) Comparison operation

18. What is a form in MS Access?
(A) It is an input screen designed to make the viewing and entering data easier
(B) It is a printed page where users will write their data to fill it up
(C) This is an important part of database used by analysts to draw conclusions
(D) All of these

19. How can you automatically insert all of the fields in a table in a query?
(A) Double clicking
(B) Right clicking
(C) Clicking
(D) All of the above

20. How can we remove a relationship defined between two tables in MS Access?
(A) Select the relationship line and press Delete
(B) From Edit menu choose Delete Relationship
(C) Choose Delete option from Relationship menu
(D) All of above

21. Which data type can store up to a maximum of 65,535 characters?
(A) Number
(B) Date/Time
(C) Memo
(D) All of the above

22. Which operator is used to select records only if two or more conditions are satisfied?
(A) And
(B) If or
(C) Range
(D) Or

23. Which field type can store photos in MS Access?
(A) Hyperlink
(B) Access tables can’t store photos
(C) Both of these can be used
(D) OLE

24. Queries in Access can be used as:
(A) A source of records for forms and reports
(B) View, change and analyze data in different ways
(C) Only A
(D) Both A and B

25. When designing a relationship, dragging a field into another table causes the mouse pointer to be a:
(A) Outline rectangle
(B) Thin + sign
(C) A doctor’s sign
(D) All of the above

26. What is a method to create a new table in MS Access?
(A) Create table in Design View
(B) Create table by Entering data
(C) Create table using Wizard
(D) All of above

27. What is the most common type of query used to retrieve and display records?
(A) Select
(B) Parameter
(C) Crosstab
(D) All of above

28. What differentiates ‘Open’ from ‘Open Exclusively’ in MS Access?
(A) Open statement opens Access database files and Open Exclusively opens files of other programs like Oracle
(B) Both Open and Open Exclusively are same
(C) Open Exclusive locks the whole database; Open locks only the record being accessed
(D) Open Exclusive command does not exist in MS Access

29. Which of the following statements is true?
(A) Queries can include calculated fields that do not exist in a table
(B) Queries can be printed in well formatted manner and presented as the information
(C) Reports can be used to retrieve data from tables and calculate
(D) Reports and forms are similar but forms are used to print and reports to display

30. Which query prompts you for information when run?
(A) Select
(B) Parameter
(C) Crosstab
(D) Append

31. Which query type is used to calculate and restructure data for easier analysis?
(A) Crosstab
(B) Select
(C) Parameter
(D) Append