Q: Which of the following are the correct results of a Boolean expression?
A: TRUE, FALSE or NULL
Q: Which operator is used to perform a case-sensitive comparison in SQL?
A: COLLATE
Q: Which operator is used to concatenate two or more columns in SQL Server?
A: CONCAT
Q: Which operator is used to perform a self-join in SQL?
A: =
Q: Which function is used to divides one numeric expression by another and get the remainder ?
A: MOD
Q: Which operator is used to specify multiple values in a WHERE clause in SQL?
A: IN
Q: Which of the following is a comparison operator in SQL?
A: Single equal sign ( = )
Q: Which of the following is a legal expression in SQL?
A: SELECT NAME FROM SALES
Q: Which keyword is used instead of the assignment operator to initialize variables?
A: DEFAULT
Q: Which operator is used to perform pattern matching with regular expressions in SQL?
A: REGEXP_LIKE