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

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

 0%

Page 1 of 2

Uncategorized

1. What is a record in a table?

2. What is a foreign key?

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

4. Which of the following statements is true?

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

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

7. Which wildcard symbol represents a single character?

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

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

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

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

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

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

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

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

16. Which field type allows automatic incrementing of values?

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

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

19. Which of the following is a calculated field?

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

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

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

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

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

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


 

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

Mustansar Khan

Hey Exam Warriors! I'm Mustansar Khan, your ally in conquering tests. Uncover strategies, real-time experiences, and expert advice to turn your study sessions into victories. Let's gear up for success!

Your Related

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top button
error: