Welcome to your Unmasking The Best of SQL: Test Your Expertise! This quiz has multiple choice questions and each has only one correct answer.
Total Questions : 25
You have 30 Minutes to complete this quiz
To pass this quiz you need to score 80% or above
Today's Date : 30 July 2026
All the best!!
Name
Email
1. What does a relational database consists of?
2. What is returned by function MOD(2024,30)?
3. Which of the following function the DBMS is not responsible for?
4. Which of the following values is returned in case of a false value if the ELSE block in the CASE statement is undefined?
5. Which statement is/are true?
The OR operator displays a record if ANY conditions listed are true The AND operator displays a record if ALL of the conditions listed are true The OR operator displays a record if ALL conditions listed are true The AND operator displays a record if ANY conditions listed are true Deselect Answer
6. What is the output of coalesce(NULLIF(4500.00,4500),1)?
7. Which of the following sentence is true?
8. Which of the following SQL clauses specifies a search condition?
9. Which of the following string satisfies the condition 'A_B%'?
10. What does SQL stand for?
11. Assuming the SYSDATE is 01-JAN-24, what will be the outcome of the following query?
12. Which of the following is NOT a valid implicit conversion performed by Oracle?
13. For removing extra space at last of name 'Techy Buddy ', which function should be used?
14. A table is having some NULL values in a column name "Customer_Name", What condition will return all rows where "Customer_Name" is NULL?
15. What does RDBMS stand for?
16. How many input parameters are mandatory in NVL function?
17. If we don't specify ASC or DESC after the ORDER BY clause, the following is used by default
18. Which of the following options is true if more than one WHEN..THEN levels present in a CASE statement?
19. With this condition :where last_name like '%ria'; row is not displayed when last_name is equal to?
20. All aggregate functions except _____ ignore null values in their input collection.
21. What is true about the COALESCE function?
22. What will be the output of below SQL?
23. In SQL, which of the following is not a Data Manipulation Language (DML) Commands?
24. Which operator can be used for appending two strings?
25. Which statement do we use to have null values to return at the top in my query result?
