ECAT Computer Science Basics Concepts and Terminology of Databases Test Online

ECAT Computer Science Basics Concepts and Terminology of Databases Test

ECAT Computer Science Chapter 12 Basics Concepts and Terminology of Databases 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 Basics Concepts and Terminology of Databases Test Online MCQs

 0%

Page 1 of 2

Uncategorized

1. Which SQL clause groups rows with the same values?

2. Which function returns the number of rows in a table?

3. What does NULL represent in a database?

4. What is the purpose of normalization?

5. Which key ensures uniqueness for each record in a table?

6. What is an attribute in a database?

7. What is data redundancy?

8. Which clause is used to filter records in SQL?

9. What does DBMS stand for?

10. Which of the following is not a type of DBMS?

11. Which SQL command is used to remove duplicate rows from results?

12. What is the full form of RDBMS?

13. What is a foreign key?

14. What is a database index used for?

15. Which command is used to grant user permissions in SQL?

16. Which command is used to retrieve data from a database?

17. Which SQL clause is used to rename a column or table?

18. What does the term schema refer to in databases?

19. Which SQL command is used to change existing records?

20. Which SQL keyword is used to sort the result set?

21. Which constraint ensures that a column cannot have NULL values?

22. Which of these is a relational database?

23. What is the difference between DELETE and TRUNCATE in SQL?

24. Which is the correct order of SQL execution?

25. Which SQL keyword is used to combine results from two queries?


 

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: