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