Similar Collections

    No collections found

questions

Title
Output returned by the Scalar functions is/are -

Output returned by the Scalar functions is/are -

  1. Single Value
  2. Multiple Value
  3. Two Values
  4. None of the above
discuss
The scalar functions operate on each record ___________ in SQL

The scalar functions operate on each record ___________ in SQL.

  1. Dependently
  2. Independently
  3. Interdependently
  4. Intradependently
discuss
Which of the following is/are Scalar function(s)?

Which of the following is/are Scalar function(s)?

  1. UCASE()
  2. MID()
  3. ROUND()
  4. All of the above
discuss
What is the functionality of UCASE function?

What is the functionality of UCASE function?

  1. To change the case of the string to lowercase characters.
  2. To change the case of the string to uppercase characters.
  3. To change the case of the string to numeric characters.
  4. To change the case of the string to symbolic characters.
discuss
Full form of LCASE is -

Full form of LCASE is -

  1. Low case
  2. Letter case
  3. Light case
  4. Lower case
discuss
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 –

  1. ROUND()
  2. MID()
  3. FORMAT()
  4. NOW()
discuss
NOW function is used to return the current –

NOW function is used to return the current –

  1. Time
  2. Date
  3. Date & Time
  4. Day
discuss
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?

  1. FORM()
  2. DISPLAY()
  3. COL()
  4. FORMAT()
discuss
ROUND function consists of ___ parameters?

ROUND function consists of ___ parameters?

  1. One
  2. Two
  3. Three
  4. Four
discuss
Choose the correct syntax of NOW function?

Choose the correct syntax of NOW function?

  1. SELECT ()NOW;
  2. NOW() SELECT;
  3. SELECT NOW();
  4. SELECT OWN();
discuss
total MCQs: 10

MCQs

10

Views

91

Best Answers

299

Points

5