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. Which query is used to modify existing records?

Update query

Make Table

Delete query

Append query

2. What is a record in a table?

A column of data

A complete row of data

A query result

A field

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

GROUP BY

ORDER BY

JOIN

WHERE

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

Number

AutoNumber

Currency

Short Text

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

Self join

Inner join

Left join

Right join

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

Filters out duplicate records in the result

Limits records to 10

Deletes duplicate tables

Highlights unique data in red

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

Number

Image

Short Text

Currency

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

It cannot be left empty

It only accepts numbers

It becomes read-only

It becomes the primary key

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

Query

Report

Form

Macro

10. What is the function of a lookup field?

To enter unique values

To allow selection from a predefined list

To sort table records

To apply queries

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

Validation Rule

Format

Field Size

Caption

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

SQL View

Datasheet View

Pivot View

Design View

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

Update query

Append query

Crosstab query

Delete query

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

COUNT

SUM

AVG

MAX

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

AutoNumber (Primary Key)

Any Long Text field

Caption field

Foreign key

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

Cross join

Outer join

Inner join

Self join

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

Delete query

Make Table query

Append query

Parameter query

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

Set primary keys

Apply joins

Use aggregate functions like Sum, Count

Apply formatting

19. Which of the following statements is true?

Queries do not require tables

One table can only have one field

A table can have multiple records and multiple fields

Queries can only access one table at a time

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

Caption

Required

Field Size

Field Name

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

Layout View

Datasheet View

Design View

SQL View

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

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

Create queries

Print reports

Write and insert formulas or expressions

Rename tables

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

Crosstab query

Select query

Update query

Append query

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

A row

A form

A column

A cell

Page 2 of 2

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

Delete query

Update query

Crosstab query

Make Table query

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

Append query

Select query with JOIN

Delete query

Update query

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

29. Which field type allows automatic incrementing of values?

Currency

AutoNumber

Short Text

Number

30. Which wildcard symbol represents a single character?

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

Finds empty or missing values

Finds fields that contain numbers

Finds text fields only

Sorts values in descending order

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

Primary key

Candidate key

Super key

Foreign key

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

Make Table query

Crosstab query

Parameter query

Delete query

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

To define primary keys

To create forms

To retrieve specific data

To update table structures

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

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

JOIN

ORDER BY

WHERE

TOP

37. What is a Crosstab query used for?

To apply validation rules

To delete data

To group and summarize data in a matrix format

To change field names

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

Caption

Format

Validation Rule

Field Size

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

WHERE clause

GROUP BY

SELECT clause

ORDER BY

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

Foreign Key

Lookup Field

Caption

Primary Key

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

Hyperlink

Attachment

Short Text

Memo

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

To reduce storage size

To allow null values

To automatically insert a preset value when none is entered

To disable the field

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

To format data

To store data

To create reports

To filter data

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

45. What is a foreign key?

A unique key for each record

A key that can be left blank

A key that refers to the primary key in another table

A field with numeric values

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

Design View

SQL View

Form View

Datasheet View

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

Append query

Update query

Delete query

Select query

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

INSERT

MAX

CAST

ADD

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

UET Lahore, Taxila ECAT Chemistry Entry Test Online…
UET Lahore Combined Entry Test 2025 ECAT Schedule…
NED-Karachi ECAT Physics Entry Test Online Preparation
NED-Karachi ECAT Maths Entry Test Online Preparation
NED-Karachi ECAT Chemistry Entry Test Online Preparation
UET Lahore, Taxila ECAT Physics Entry Test Online…
UET Lahore Combined Entrance Test 2025 - Apply Online
Mehran University Sindh ECAT Physics Entry Test…

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

Related:

You Might Also Like

Mustansar Khan

Leave a Reply Cancel reply