Which of the following query would limit the output to 5 rows?
Correct
Incorrect
Question 5 of 25
5. Question
Which of the following is not a part of CRUD operations in SQL?
Correct
Incorrect
Question 6 of 25
6. Question
Which of the following shows comment in SQL?
Correct
Incorrect
Question 7 of 25
7. Question
Which of the following query depicts the correct Select statement?
Correct
Incorrect
Question 8 of 25
8. Question
Which of the following query finds employees with an experience more than 5?
Correct
Incorrect
Question 9 of 25
9. Question
Which of the following is used to modify the data stored in the database?
Correct
Incorrect
Question 10 of 25
10. Question
Which of the following is not an aggregate function in SQL?
Correct
Incorrect
Question 11 of 25
11. Question
Which of the following is not true about SQL Subqueries?
Correct
Incorrect
Question 12 of 25
12. Question
Which of the following operator is used to extract pattern matching data from the database?
Correct
Incorrect
Question 13 of 25
13. Question
Which of the following is true about a cursor in SQL?
Correct
Incorrect
Question 14 of 25
14. Question
SQL database follows which of the following principles?
Correct
Incorrect
Question 15 of 25
15. Question
Which of the following is not a data type in SQL?
Correct
Incorrect
Question 16 of 25
16. Question
Which of the following join extracts data of matching rows from both tables?
Correct
Incorrect
Question 17 of 25
17. Question
Which keyword allows us to find the unique values in the database?
Correct
Incorrect
Question 18 of 25
18. Question
Which of the following clause allows us to extract data in a range?
Correct
Incorrect
Question 19 of 25
19. Question
Which of the following is not true about views?
Correct
Incorrect
Question 20 of 25
20. Question
Which of the following statements about the MAX function in SQL are true?
Correct
Incorrect
Question 21 of 25
21. Question
Which of the following is true about the RDBMS?
Correct
Incorrect
Question 22 of 25
22. Question
Which of the following is true about NULL values in SQL?
Correct
Incorrect
Question 23 of 25
23. Question
BLOB in SQL stands for?
Correct
Incorrect
Question 24 of 25
24. Question
Which data type of SQL is used to store a JSON object?
Correct
Incorrect
Question 25 of 25
25. Question
Which of the following is true about a view?
Correct
Incorrect
Summary
In this SQL quiz, we have tried to cover almost all topics from our tutorials.
We have covered all the important topics and we will be rolling out more quizzes soon. We recommend attempting the quiz once you are well aware of all the topics.
You give me 15 seconds I promise you best tutorials Please share your happy experience on Google
DataFlair Team creates expert-level guides on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our goal is to empower learners with easy-to-understand content. Explore our resources for career growth and practical learning.
Nice mixing of question, some were so easy and some were confusing. Nice to have Quiz. It will be more interesting if result will be shown as pie graph in percentage. Thank you.
8. Question Which of the following join extracts data of matching rows from both tables?
Full Outer Join Left Join Right Join None of these.
The answer to this should be INNER JOIN, but if selected none of the above, it gives wrong answer, googling the same question gives the answer as INNER JOIN too.
Quiz
up love a lone
Mistake in the question.
Which of the following is not true about views?
“Can be created only from one table.” is not true
Why can’t you create a view using only one table
My bad on reading that question. Don’t consider my earlier comment
Nice mixing of question, some were so easy and some were confusing.
Nice to have Quiz. It will be more interesting if result will be shown as pie graph in percentage.
Thank you.
Which of the following join extracts data of matching rows from both tables?
answer is none of these, but you mention that full outer join
8. Question
Which of the following join extracts data of matching rows from both tables?
Full Outer Join
Left Join
Right Join
None of these.
The answer to this should be INNER JOIN, but if selected none of the above, it gives wrong answer, googling the same question gives the answer as INNER JOIN too.
Which of the following join extracts data of matching rows from both tables?
Full Outer Join
Left Join
Right Join
None of these.
The answer to this should be INNER JOIN
exactly, the answer here is incorrect 🙁
so easy 92%