Home »
SQL »
SQL MCQs
MCQ | SQL – Scalar Functions
SQL Scalar Functions MCQ: This section contains the Multiple-Choice Questions & Answers on SQL Scalar Functions.
Submitted by Anushree Goswami, on October 24, 2021
SQL Scalar Functions MCQs
1. Output returned by the Scalar functions is/are -
- Single Value
- Multiple Value
- Two Values
- None of the above
Answer: A) Single Value
Explanation:
The output returned by the Scalar functions is Single Value.
Discuss this Question
2. The scalar functions operate on each record ____ in SQL.
- Dependently
- Independently
- Interdependently
- Intradependently
Answer: B) Independently
Explanation:
The scalar functions operate on each record independently in SQL.
Discuss this Question
3. Which of the following is/are Scalar function(s)?
- UCASE()
- MID()
- ROUND()
- All of the above
Answer: D) All of the above
Explanation:
The commonly used Scalar functions are -
- UCASE()
- MID()
- ROUND()
- FORMAT()
- LCASE()
- LENGTH()
- NOW()
Discuss this Question
4. What is the functionality of UCASE function?
- To change the case of the string to lowercase characters.
- To change the case of the string to uppercase characters.
- To change the case of the string to numeric characters.
- To change the case of the string to symbolic characters.
Answer: B) To change the case of the string to uppercase characters
Explanation:
UCASE function is used to change the case of the string to uppercase characters.
Discuss this Question
5. Full form of LCASE is -
- Low case
- Letter case
- Light case
- Lower case
Answer: D) Lower case
Explanation:
Full form of LCASE is Lower case.
Discuss this Question
6. Which function is used to extract substrings from the column of the table –
- ROUND()
- MID()
- FORMAT()
- NOW()
Answer: B) MID()
Explanation:
The MID() function is used to extract substrings from the column of the table.
Discuss this Question
7. NOW function is used to return the current –
- Time
- Date
- Date & Time
- Day
Answer: C) Date & Time
Explanation:
NOW function is used to return the current Date & Time of the system.
Discuss this Question
8. In order to format, how the column should be displayed, which function is used?
- FORM()
- DISPLAY()
- COL()
- FORMAT()
Answer: D) FORMAT()
Explanation:
In order to format, how the column should be displayed, the FORMAT function is used.
Discuss this Question
9. ROUND function consists of ___ parameters?
- One
- Two
- Three
- Four
Answer: B) Two
Explanation:
The ROUND() function consists of Two Parameters and is used with the SELECT query in order to print the formatted value.
Discuss this Question
10. Choose the correct syntax of NOW function?
- SELECT ()NOW;
- NOW() SELECT;
- SELECT NOW();
- SELECT OWN();
Answer: C) SELECT NOW();
Explanation:
SELECT NOW(); is the correct syntax of NOW function.
Discuss this Question