Computer Table and Query Test Online

Q: How can I prepare for Computer Table and Query Test Online?

You can prepare for Computer Table and Query Test Online by attempting the free online quizzes at Gotest.com.pk. We provide instant results, performance reports, and detailed explanations for every question.

Question 1

1. Which of the following views allows you to create or modify a query using SQL?

Answer

Datasheet View

Answer

Design View

Question 2

2. Which of the following helps filter data in a query?

Answer

SELECT clause

Answer

WHERE clause

Question 3

3. What is the function of a query in MS Access?

Answer

To update table structures

Answer

To define primary keys

Answer

To retrieve specific data

Answer

To create forms

Question 4

4. Which of the following statements is true?

Answer

One table can only have one field

Answer

Queries can only access one table at a time

Answer

Queries do not require tables

Answer

A table can have multiple records and multiple fields

Question 5

5. What is the purpose of the "LIKE" operator in a query?

Answer

To perform arithmetic

Answer

To filter numeric values only

Answer

To check for NULL values

Answer

To match patterns in text fields

Question 6

6. Which symbol is used as a wildcard for any number of characters in Access queries?

Question 7

7. Which field property is used to display a user-friendly name instead of the actual field name?

Answer

Field Size

Answer

Validation Rule

Question 8

8. What does the "Is Null" condition in a query do?

Answer

Finds empty or missing values

Answer

Finds text fields only

Answer

Sorts values in descending order

Answer

Finds fields that contain numbers

Question 9

9. Which field type should you use to store URLs or email addresses?

Answer

Attachment

Answer

Short Text

Question 10

10. Which field type allows automatic incrementing of values?

Answer

Short Text

Answer

AutoNumber

Question 11

11. Which query would you use to combine fields from two or more tables?

Answer

Delete query

Answer

Append query

Answer

Update query

Answer

Select query with JOIN

Question 12

12. Which wildcard symbol represents a single character?

Question 13

13. What is the effect of the DISTINCT keyword in a query?

Answer

Limits records to 10

Answer

Filters out duplicate records in the result

Answer

Highlights unique data in red

Answer

Deletes duplicate tables

Question 14

14. Which type of join returns all records from one table and matching records from another?

Answer

Inner join

Answer

Right join

Question 15

15. What is a foreign key?

Answer

A field with numeric values

Answer

A unique key for each record

Answer

A key that can be left blank

Answer

A key that refers to the primary key in another table

Question 16

16. Which of the following can be used to restrict the number of records returned in a query?

Question 17

17. Which of the following is not a valid data type in Access tables?

Answer

Short Text

Question 18

18. Which of the following is used to add new records to a table using a query?

Answer

Update query

Answer

Append query

Answer

Crosstab query

Answer

Select query

Question 19

19. What type of query is used to delete data from a table?

Answer

Make Table query

Answer

Delete query

Answer

Crosstab query

Answer

Parameter query

Question 20

20. Which key uniquely identifies each record in a table?

Answer

Candidate key

Answer

Foreign key

Answer

Primary key

Question 21

21. Which of the following query types allows user input at runtime?

Answer

Make Table query

Answer

Delete query

Answer

Parameter query

Answer

Append query

Question 22

22. Which type of join returns only the matching records from both tables?

Answer

Cross join

Answer

Outer join

Answer

Inner join

Question 23

23. Which of the following is a calculated field?

Answer

A manually entered number

Answer

A lookup field

Answer

A form field

Answer

A field created by combining other fields using expressions

Question 24

24. Which query type is used to retrieve and view data?

Answer

Update query

Answer

Select query

Answer

Delete query

Answer

Append query

Question 25

25. What is the result of a null value in a field?

Answer

The field has a space

Answer

The field is zero

Answer

The field is text

Answer

The field is empty (no data)

Question 26

26. Which feature ensures that each record is uniquely identified?

Answer

Lookup Field

Answer

Foreign Key

Answer

Primary Key

Question 27

27. Which view is used to design the structure of a table?

Answer

Datasheet View

Answer

Layout View

Answer

Design View

Question 28

28. What is the primary purpose of a table in MS Access?

Answer

To create reports

Answer

To filter data

Answer

To format data

Answer

To store data

Question 29

29. Which data type is suitable for storing phone numbers?

Answer

Short Text

Answer

AutoNumber

Question 30

30. In a query, which function returns the average value?

Question 31

31. Which of the following queries is used to create a new table from an existing one?

Answer

Update query

Answer

Crosstab query

Answer

Delete query

Answer

Make Table query

Question 32

32. What does the expression builder in Access help you do?

Answer

Rename tables

Answer

Create queries

Answer

Print reports

Answer

Write and insert formulas or expressions

Question 33

33. Which of the following clauses is used to sort query results?

Question 34

34. Which of these fields is automatically indexed in Access?

Answer

Any Long Text field

Answer

AutoNumber (Primary Key)

Answer

Caption field

Answer

Foreign key

Question 35

35. Which of the following allows you to join data from multiple tables?

Question 36

36. What happens when you set a field as Required?

Answer

It becomes read-only

Answer

It becomes the primary key

Answer

It cannot be left empty

Answer

It only accepts numbers

Question 37

37. What is the purpose of setting a default value for a field in a table?

Answer

To reduce storage size

Answer

To automatically insert a preset value when none is entered

Answer

To allow null values

Answer

To disable the field

Question 38

38. Which of the following query types cannot be used to edit data?

Answer

Delete query

Answer

Crosstab query

Answer

Append query

Answer

Update query

Question 39

39. In MS Access, what does a field represent in a table?

Question 40

40. What is the default view when you open a table?

Answer

Pivot View

Answer

Datasheet View

Answer

Design View

Question 41

41. What does the Total row in a query allow you to do?

Answer

Set primary keys

Answer

Apply formatting

Answer

Apply joins

Answer

Use aggregate functions like Sum, Count

Question 42

42. Which query is used to modify existing records?

Answer

Delete query

Answer

Append query

Answer

Make Table

Answer

Update query

Question 43

43. Which property in a table defines the data type and length of a field?

Answer

Field Name

Answer

Field Size

Question 44

44. Which of the following is a valid aggregate function in Access queries?

Question 45

45. What is a Crosstab query used for?

Answer

To apply validation rules

Answer

To change field names

Answer

To group and summarize data in a matrix format

Answer

To delete data

Question 46

46. What is the function of a lookup field?

Answer

To allow selection from a predefined list

Answer

To apply queries

Answer

To sort table records

Answer

To enter unique values

Question 47

47. What is a record in a table?

Answer

A column of data

Answer

A query result

Answer

A complete row of data

Question 48

48. Which field property is used to limit the type of data entered?

Answer

Field Size

Answer

Validation Rule

Question 49

Loading...

Total Questions:	50
Time Allowed:	25 Minutes
Total Marks:	50
How to Attempt Test:	Please choose the right Option in MCQ-type question.
Test Helpful For:	ECAT Entry Test Computer Online Test Interview Questions about Computer All Universities Entrance Test Recruitments Tests

Computer Table and Query Test Online

Important Table and Query Question and Answer

Computer Table and Query Practice Test Online With Explanation

Uncategorized

Study Plan for Computer Table and Query Test Online

How to Use GoTest for Preparation:

More Related Resources

Mustansar Khan

Leave a Reply Cancel reply

Important Table and Query Question and Answer

Computer Table and Query Practice Test Online With Explanation

Uncategorized

Study Plan for Computer Table and Query Test Online

How to Use GoTest for Preparation:

More Related Resources

Latest Updates

Mustansar Khan

Leave a Reply Cancel reply