Title  

Output returned by the Scalar functions is/are Output returned by the Scalar functions is/are 
The answer is:
A. Single Value


The scalar functions operate on each record ___________ in SQLThe scalar functions operate on each record ___________ in SQL.
The answer is:
B. Independently


Which of the following is/are Scalar function(s)?Which of the following is/are Scalar function(s)?
The answer is:
D. All of the above


What is the functionality of UCASE function?What is the functionality of UCASE function?
The answer is:
B. To change the case of the string to uppercase characters.


Full form of LCASE is Full form of LCASE is 
The answer is:
D. Lower case


Which function is used to extract substrings from the column of the table –Which function is used to extract substrings from the column of the table –
The answer is:
B. MID()


NOW function is used to return the current –NOW function is used to return the current –
The answer is:
C. Date & Time


In order to format, how the column should be displayed, which function is used?In order to format, how the column should be displayed, which function is used?
The answer is:
D. FORMAT()


ROUND function consists of ___ parameters? 

Choose the correct syntax of NOW function?Choose the correct syntax of NOW function?
The answer is:
C. SELECT NOW();

MCQs
Views
Best Answers
Points