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?

Make Table

Delete query

Update query

Append query

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

ORDER BY

JOIN

TOP

WHERE

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

Required

Field Size

Caption

Field Name

4. What is a Crosstab query used for?

To group and summarize data in a matrix format

To apply validation rules

To delete data

To change field names

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

The field is empty (no data)

The field has a space

The field is text

The field is zero

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

Datasheet View

Pivot View

Design View

SQL View

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

To check for NULL values

To match patterns in text fields

To filter numeric values only

To perform arithmetic

8. What is the function of a lookup field?

To enter unique values

To allow selection from a predefined list

To apply queries

To sort table records

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

To retrieve specific data

To define primary keys

To update table structures

To create forms

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

Design View

Form View

SQL View

Datasheet View

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

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

Update query

Delete query

Select query

Append query

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

Short Text

Hyperlink

Memo

Attachment

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

To filter data

To create reports

To store data

To format data

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

Append query

Select query

Update query

Crosstab query

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

Append query

Update query

Delete query

Select query with JOIN

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

Format

Caption

Field Size

Validation Rule

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

AutoNumber (Primary Key)

Foreign key

Caption field

Any Long Text field

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

To disable the field

To allow null values

To automatically insert a preset value when none is entered

To reduce storage size

20. Which field type allows automatic incrementing of values?

Number

AutoNumber

Currency

Short Text

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

ADD

MAX

CAST

INSERT

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

Finds text fields only

Finds empty or missing values

Finds fields that contain numbers

Sorts values in descending order

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

Right join

Self join

Inner join

Left join

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

Self join

Outer join

Cross join

Inner join

25. Which wildcard symbol represents a single character?

Page 2 of 2

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

AVG

MAX

COUNT

SUM

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

Caption

Field Size

Format

Validation Rule

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

SQL View

Design View

Datasheet View

Layout View

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

Make Table query

Delete query

Crosstab query

Parameter query

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

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

WHERE clause

SELECT clause

ORDER BY

GROUP BY

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

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

Make Table query

Append query

Delete query

Parameter query

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

A row

A cell

A form

A column

35. Which of the following statements is true?

Queries can only access one table at a time

Queries do not require tables

One table can only have one field

A table can have multiple records and multiple fields

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

Number

Currency

AutoNumber

Short Text

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

Report

Query

Form

Macro

38. What is a record in a table?

A complete row of data

A column of data

A query result

A field

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

Write and insert formulas or expressions

Rename tables

Create queries

Print reports

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

It only accepts numbers

It becomes the primary key

It becomes read-only

It cannot be left empty

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

Lookup Field

Primary Key

Caption

Foreign Key

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

Foreign key

Primary key

Super key

Candidate key

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

Apply joins

Apply formatting

Set primary keys

Use aggregate functions like Sum, Count

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

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

Delete query

Crosstab query

Update query

Make Table query

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

JOIN

ORDER BY

WHERE

GROUP BY

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

Append query

Delete query

Crosstab query

Update query

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

Image

Number

Short Text

Currency

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

ECAT Introduction to Computers Online Test
ECAT Physics Optical Instruments 1 Test Online
ECAT Computer File Handling in “C” Test Online
ECAT Computer Functions in “C” Test Online
ECAT Computer Loop Constructs Test Online
ECAT Computer Decision Constructs Test Online
ECAT Computer Input Output Test Online
ECAT Computer Elements of “C” Test Online
ECAT Computer Getting Started with “C” Test Online
ECAT Computer Science Microsoft Access-Forms and Reports Tes...

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 Mathematics Application of Trigonometry Online Test

ECAT English Antonyms 1 Test Online

ECAT Physics Nuclear Physics Test Online

NUST-Rawalpindi ECAT Maths Entry Test Preparation Online

ECAT Mathematics Introduction to Analytic Geometry Online Test

ECAT Physics Force and motion Online Test

Leave a Reply Cancel reply