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