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 of the following views allows you to create or modify a query using SQL?

Datasheet View

Design View

SQL View

Form View

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

Left join

Inner join

Right join

Self join

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

Pivot View

SQL View

Design View

Datasheet View

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

Primary Key

Foreign Key

Caption

Lookup Field

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

Caption

Field Name

Required

Field Size

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

Crosstab query

Make Table query

Delete query

Update query

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

A row

A cell

A form

A column

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

Print reports

Rename tables

Write and insert formulas or expressions

Create queries

9. What is a foreign key?

A field with numeric values

A unique key for each record

A key that can be left blank

A key that refers to the primary key in another table

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

Layout View

Design View

SQL View

Datasheet View

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

To create forms

To retrieve specific data

To update table structures

To define primary keys

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

Currency

Short Text

Image

Number

13. Which field type allows automatic incrementing of values?

Number

Currency

Short Text

AutoNumber

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

To perform arithmetic

To check for NULL values

To filter numeric values only

To match patterns in text fields

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

AutoNumber (Primary Key)

Any Long Text field

Foreign key

Caption field

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

Sorts values in descending order

Finds fields that contain numbers

Finds empty or missing values

Finds text fields only

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

Field Size

Caption

Validation Rule

Format

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

SUM

MAX

AVG

COUNT

19. What is the function of a lookup field?

To sort table records

To apply queries

To allow selection from a predefined list

To enter unique values

20. Which of the following is a calculated field?

A lookup field

A field created by combining other fields using expressions

A form field

A manually entered number

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

ORDER BY

GROUP BY

WHERE

JOIN

22. What is a record in a table?

A complete row of data

A column of data

A field

A query result

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

ADD

CAST

MAX

INSERT

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

To store data

To create reports

To format data

To filter data

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

Append query

Delete query

Select query with JOIN

Update query

Page 2 of 2

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

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

Set primary keys

Apply formatting

Apply joins

Use aggregate functions like Sum, Count

28. Which wildcard symbol represents a single character?

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

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

Delete query

Append query

Select query

Update query

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

Self join

Outer join

Cross join

Inner join

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

Crosstab query

Delete query

Update query

Append query

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

ORDER BY

WHERE clause

GROUP BY

SELECT clause

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

Format

Validation Rule

Field Size

Caption

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

JOIN

TOP

WHERE

ORDER BY

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

To allow null values

To reduce storage size

To disable the field

To automatically insert a preset value when none is entered

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

Candidate key

Super key

Primary key

Foreign key

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

It only accepts numbers

It becomes read-only

It becomes the primary key

It cannot be left empty

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

Crosstab query

Update query

Append query

Select query

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

Parameter query

Make Table query

Append query

Delete query

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

The field is text

The field is empty (no data)

The field has a space

The field is zero

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

Memo

Hyperlink

Attachment

Short Text

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

Delete query

Parameter query

Crosstab query

Make Table query

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

Number

AutoNumber

Short Text

Currency

45. What is a Crosstab query used for?

To group and summarize data in a matrix format

To change field names

To delete data

To apply validation rules

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

47. Which query is used to modify existing records?

Delete query

Update query

Append query

Make Table

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

Form

Query

Macro

Report

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 English Correction Test Online

UET Lahore Combined Entrance Test 2025 – Apply Online

ECAT English Spotting Errors 3 Online Test Preparation

ECAT Mathematics Number System Test Online

ECAT English Vocabulary 6 Online Test

ECAT Chemistry Macro-Molecules Test Online

Leave a Reply Cancel reply