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 : 18 February 2025
All the best!!
Name
Email
1. What does SQL stand for?
2. With this condition :where last_name like '%ria'; row is not displayed when last_name is equal to?
3. Which of the following string satisfies the condition 'A_B%'?
4. What is returned by function MOD(2024,30)?
5. In SQL, which of the following is not a Data Manipulation Language (DML) Commands?
6. 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
7. Which operator can be used for appending two strings?
8. What is the output of coalesce(NULLIF(4500.00,4500),1)?
9. Which of the following function the DBMS is not responsible for?
10. What will be the output of below SQL?
11. Which of the following sentence is true?
12. How many input parameters are mandatory in NVL function?
13. All aggregate functions except _____ ignore null values in their input collection.
14. Which of the following is NOT a valid implicit conversion performed by Oracle?
15. Which of the following options is true if more than one WHEN..THEN levels present in a CASE statement?
16. What does a relational database consists of?
17. What is true about the COALESCE function?
18. What does RDBMS stand for?
19. If we don't specify ASC or DESC after the ORDER BY clause, the following is used by default
20. A table is having some NULL values in a column name "Customer_Name", What condition will return all rows where "Customer_Name" is NULL?
21. Assuming the SYSDATE is 01-JAN-24, what will be the outcome of the following query?
22. Which of the following SQL clauses specifies a search condition?
23. Which of the following values is returned in case of a false value if the ELSE block in the CASE statement is undefined?
24. For removing extra space at last of name 'Techy Buddy ', which function should be used?
25. Which statement do we use to have null values to return at the top in my query result?
