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 MS Access, what does a field represent in a table?

A row

A column

A cell

A form

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

AutoNumber (Primary Key)

Foreign key

Any Long Text field

Caption field

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

Super key

Candidate key

Foreign key

Primary key

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

Field Size

Caption

Validation Rule

Format

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

Caption

Required

Field Name

Field Size

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

Limits records to 10

Deletes duplicate tables

Highlights unique data in red

Filters out duplicate records in the result

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

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

Field Size

Validation Rule

Caption

Format

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

JOIN

ORDER BY

WHERE

TOP

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

Datasheet View

SQL View

Design View

Pivot View

11. What is the function of a lookup field?

To sort table records

To apply queries

To enter unique values

To allow selection from a predefined list

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

Attachment

Short Text

Hyperlink

Memo

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

Select query

Append query

Update query

Crosstab query

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

MAX

INSERT

CAST

ADD

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

To update table structures

To create forms

To define primary keys

To retrieve specific data

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

Currency

Short Text

Number

Image

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

SQL View

Datasheet View

Design View

Form View

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

Select query with JOIN

Append query

Delete query

Update query

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

AVG

SUM

COUNT

MAX

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

Macro

Report

Form

Query

21. Which of the following statements is true?

A table can have multiple records and multiple fields

Queries can only access one table at a time

Queries do not require tables

One table can only have one field

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

Update query

Append query

Delete query

Select query

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

To filter numeric values only

To perform arithmetic

To check for NULL values

To match patterns in text fields

24. Which query is used to modify existing records?

Make Table

Delete query

Update query

Append query

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

The field has a space

The field is text

The field is zero

The field is empty (no data)

Page 2 of 2

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

Delete query

Crosstab query

Update query

Append query

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

Delete query

Crosstab query

Parameter query

Make Table query

28. Which field type allows automatic incrementing of values?

Short Text

AutoNumber

Number

Currency

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

Datasheet View

Design View

SQL View

Layout View

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

It cannot be left empty

It becomes read-only

It becomes the primary key

It only accepts numbers

31. What is a Crosstab query used for?

To delete data

To change field names

To apply validation rules

To group and summarize data in a matrix format

32. What is a record in a table?

A column of data

A field

A query result

A complete row of data

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

Delete query

Make Table query

Update query

Crosstab query

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

To disable the field

To automatically insert a preset value when none is entered

To allow null values

To reduce storage size

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

Create queries

Print reports

Rename tables

Write and insert formulas or expressions

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

Use aggregate functions like Sum, Count

Apply formatting

Set primary keys

Apply joins

37. Which of the following is a calculated field?

A form field

A field created by combining other fields using expressions

A manually entered number

A lookup field

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

ORDER BY

WHERE

GROUP BY

JOIN

39. 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

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

To store data

To filter data

To format data

To create reports

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

Foreign Key

Primary Key

Caption

Lookup Field

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

Make Table query

Append query

Parameter query

Delete query

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

GROUP BY

SELECT clause

ORDER BY

WHERE clause

44. What is a foreign key?

A key that can be left blank

A key that refers to the primary key in another table

A unique key for each record

A field with numeric values

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

Right join

Left join

Inner join

Self join

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

Self join

Inner join

Cross join

Outer join

47. Which wildcard symbol represents a single character?

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

AutoNumber

Number

Currency

Short Text

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

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

Your Related

ECAT Statistics Test Set 14

ECAT Statistics Test Set 3

UET Lahore, Taxila ECAT Maths Entry Test Online Preparation

ECAT Chemistry Aldehydes and Ketones Test Online

ECAT Mathematics Vectors Chapter Online Test

ECAT Chemistry Solids Online Test

Leave a Reply Cancel reply