Title  

In how many parts are the SQL functions are divided into? 

____ value is returned by the SQL Aggregate functions?____ value is returned by the SQL Aggregate functions?
The answer is:
A. Single


Select the Aggregate function(s) among the followingSelect the Aggregate function(s) among the following.
The answer is:
D. All of the above


What does AVG() function returns?What does AVG() function returns?
The answer is:
D. Average value of the column


Which function returns the largest value of the column?Which function returns the largest value of the column?
The answer is:
B. MAX()


What does COUNT() function returns?What does COUNT() function returns?
The answer is:
D. Number of rows


Select the function which is not the Scalar Function(s)?Select the function which is not the Scalar Function(s)?
The answer is:
C. SUM()


What does UCASE() function do?What does UCASE() function do?
The answer is:
A. Converts database field to uppercase


____ function extract characters from the text field____ function extract characters from the text field.
The answer is:
C. MID()


Which function returns the correct date and time?Which function returns the correct date and time?
The answer is:
B. NOW()


In order to merge two or more strings, which string function is used?In order to merge two or more strings, which string function is used?
The answer is:
C. CONCAT


We can use literal in the CONCAT function. What does literal refer to?We can use literal in the CONCAT function. What does literal refer to?
The answer is:
D. All of the above


What is the symbol of Concatenation Operator? 

What is the full form of CTE in SQL?What is the full form of CTE in SQL?
The answer is:
D. Common Table Expressions


Which clause is needed in CTE SQL syntax? 

In case of ____ data, recursive CTE is used?In case of ____ data, recursive CTE is used?
The answer is:
B. Hierarchal


In case the CTE is wrong, it goes into –In case the CTE is wrong, it goes into –
The answer is:
A. Infinite Loop


In case to prevent the endless loop in CTE, ____ is addedIn case to prevent the endless loop in CTE, ____ is added.
The answer is:
C. MAXRECURSION


From the set of results, in order to remove the duplicate columns, ____ Clause is usedFrom the set of results, in order to remove the duplicate columns, ____ Clause is used.
The answer is:
B. DISTINCT


____ are the columns for the retrieval purpose____ are the columns for the retrieval purpose.
The answer is:
C. Expressions

MCQs
Views
Best Answers
Points