Welcome to Tekiana Quiz



1. SQL is case-sensitive

True
False


2. What is the output of following code?
COALESCE(NULL,1,2)

1
2
NULL
None Of the Above


3. What is the default date format of SQL?

YYYY-MM-DD
DD-MM-YYYY
MM-DD-YYYY
None Of the Above


4. What is the output of following line?
SELECT CONVERT(int, 101.75);

100
101
102
None Of the Above


5. How do you fetch matching columns with Null Values?

IS NULL
= NULL
Both of the Above
None Of the Above


6. If we have two operations to order and limit, which operation should be the last SQL statement

LIMIT
ORDER BY
Both of the Above
None Of the Above


7. Which of the following property means All or Nothing

Atomicity
Consistency
Isolation
Durablity


8. What is the output of following query?
Select name,price from items order by 2 asc

Throws Error
Two columns ordered in ascending order


9. WHERE clause and HAVING Clauses behave differently when used with

Group By
Order By
Limit By
Sort By


10. SQL supports both single and multi line comments

TRUE
FALSE