Home/ECAT/ECAT Computer Science Table and Query Test Online

ECAT Computer Science Table and Query Test Online

Mustansar KhanLast Updated: May 1, 2025

ECAT Computer Science Table and Query Test

ECAT Computer Science Chapter 16 Table and Query Online Test

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

ECAT Table and Query Test Online MCQs

Please wait...

Page 1 of 2

Uncategorized

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

COUNT

SUM

MAX

AVG

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

Caption

Field Size

Format

Validation Rule

3. Which field type allows automatic incrementing of values?

AutoNumber

Number

Short Text

Currency

4. What is a foreign key?

A key that can be left blank

A unique key for each record

A key that refers to the primary key in another table

A field with numeric values

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

Make Table query

Parameter query

Delete query

Append query

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

To filter numeric values only

To check for NULL values

To match patterns in text fields

To perform arithmetic

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

Lookup Field

Foreign Key

Primary Key

Caption

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

To store data

To create reports

To filter data

To format data

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

The field is empty (no data)

The field is zero

The field is text

The field has a space

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

Finds fields that contain numbers

Sorts values in descending order

Finds empty or missing values

Finds text fields only

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

A form

A cell

A row

A column

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

Field Name

Required

Field Size

Caption

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

ORDER BY

JOIN

WHERE

GROUP BY

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

Foreign key

Any Long Text field

Caption field

AutoNumber (Primary Key)

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

Short Text

Number

Currency

Image

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

Design View

SQL View

Datasheet View

Pivot View

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

Query

Macro

Form

Report

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

Delete query

Append query

Update query

Crosstab query

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

GROUP BY

ORDER BY

WHERE clause

SELECT clause

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

To update table structures

To define primary keys

To retrieve specific data

To create forms

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

Update query

Append query

Crosstab query

Select query

22. What is the function of a lookup field?

To allow selection from a predefined list

To apply queries

To sort table records

To enter unique values

23. Which of the following is a calculated field?

A form field

A manually entered number

A lookup field

A field created by combining other fields using expressions

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

It becomes the primary key

It only accepts numbers

It becomes read-only

It cannot be left empty

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

Apply formatting

Apply joins

Use aggregate functions like Sum, Count

Set primary keys

Page 2 of 2

26. Which query is used to modify existing records?

Make Table

Append query

Update query

Delete query

27. Which wildcard symbol represents a single character?

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

Memo

Short Text

Attachment

Hyperlink

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

Rename tables

Create queries

Print reports

Write and insert formulas or expressions

30. What is a record in a table?

A query result

A column of data

A complete row of data

A field

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

Delete query

Update query

Select query with JOIN

Append query

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

INSERT

MAX

ADD

CAST

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

Highlights unique data in red

Deletes duplicate tables

Filters out duplicate records in the result

Limits records to 10

34. What is a Crosstab query used for?

To delete data

To apply validation rules

To change field names

To group and summarize data in a matrix format

35. Which of the following statements is true?

Queries do not require tables

Queries can only access one table at a time

One table can only have one field

A table can have multiple records and multiple fields

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

SQL View

Design View

Datasheet View

Form View

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

Append query

Delete query

Update query

Select query

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

Crosstab query

Update query

Delete query

Make Table query

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

Field Size

Validation Rule

Format

Caption

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

SQL View

Layout View

Design View

Datasheet View

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

JOIN

WHERE

TOP

ORDER BY

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

Delete query

Make Table query

Parameter query

Crosstab query

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

Self join

Left join

Right join

Inner join

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

Number

Currency

AutoNumber

Short Text

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

To allow null values

To reduce storage size

To automatically insert a preset value when none is entered

To disable the field

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

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

Super key

Primary key

Candidate key

Foreign key

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

Self join

Outer join

Inner join

Cross join

You Can Learn and Gain more Knowledge through our Online Quiz and Testing system Just Search your desired Preparation subject at Gotest.

UET Peshawar Entry Test 2025 Registration Online ETEA Test D...
ECAT Statistics Test Set 17
ECAT Statistics Test Set 16
ECAT Statistics Test Set 15
ECAT Statistics Test Set 14
ECAT Statistics Test Set 13
ECAT Statistics Test Set 12
ECAT Statistics Test Set 11
ECAT Statistics Test Set 10
ECAT Statistics Test Set 9

Mustansar KhanLast Updated: May 1, 2025

Facebook Twitter Reddit WhatsApp Share via Email Print

ECAT Computer Science Table and Query Test Online

ECAT Computer Science Table and Query Test

ECAT Computer Science Chapter 16 Table and Query Online Test

ECAT Table and Query Test Online MCQs

Uncategorized

You Might Also Like

Mustansar Khan

Leave a Reply Cancel reply