Similar Collections

    No collections found

questions

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

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

  1. 1
  2. 2
  3. 3
  4. 4
discuss
____ value is returned by the SQL Aggregate functions?

____ value is returned by the SQL Aggregate functions?

  1. Single
  2. Twice
  3. NULL
  4. Infinite
discuss
Select the Aggregate function(s) among the following

Select the Aggregate function(s) among the following.

  1. AVG()
  2. FIRST()
  3. LAST()
  4. All of the above
discuss
What does AVG() function returns?

What does AVG() function returns?

  1. First value of the column
  2. Last value of the column
  3. Sum of rows of the table
  4. Average value of the column
discuss
Which function returns the largest value of the column?

Which function returns the largest value of the column?

  1. MIN()
  2. MAX()
  3. LARGE()
  4. AVG()
discuss
What does COUNT() function returns?

What does COUNT() function returns?

  1. Average value
  2. Largest value
  3. Smallest value
  4. Number of rows
discuss
Select the function which is not the Scalar Function(s)?

Select the function which is not the Scalar Function(s)?

  1. UCASE()
  2. LEN()
  3. SUM()
  4. NOW()
discuss
What does UCASE() function do?

What does UCASE() function do?

  1. Converts database field to uppercase
  2. Converts database field to lowercase
  3. Returns the length of the text field
  4. Returns the current date and time
discuss
____ function extract characters from the text field

____ function extract characters from the text field.

  1. LEN()
  2. NOW()
  3. MID()
  4. FORMAT()
discuss
Which function returns the correct date and time?

Which function returns the correct date and time?

  1. DATE()
  2. NOW()
  3. TIME()
  4. DATETIME()
discuss
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?

  1. CHAR
  2. ALTER
  3. CONCAT
  4. MERGE
discuss
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?

  1. Number
  2. Character
  3. Date
  4. All of the above
discuss
What is the symbol of Concatenation Operator?

What is the symbol of Concatenation Operator?

  1. |
  2. ||
  3. //
  4. \\
discuss
What is the full form of CTE in SQL?

What is the full form of CTE in SQL?

  1. Character Table Expressions
  2. Character Table Evaluator
  3. Common Table Evaluator
  4. Common Table Expressions
discuss
Which clause is needed in CTE SQL syntax?

Which clause is needed in CTE SQL syntax?

  1. FOR
  2. AS
  3. WITH
  4. TO
discuss
In case of ____ data, recursive CTE is used?

In case of ____ data, recursive CTE is used?

  1. Round
  2. Hierarchal
  3. Linear
  4. None of the above
discuss
In case the CTE is wrong, it goes into –

In case the CTE is wrong, it goes into –

  1. Infinite Loop
  2. Null State
  3. False State
  4. True State
discuss
In case to prevent the endless loop in CTE, ____ is added

In case to prevent the endless loop in CTE, ____ is added.

  1. MAXLINEAR
  2. MAXROUND
  3. MAXRECURSION
  4. None of the above
discuss
From the set of results, in order to remove the duplicate columns, ____ Clause is used

From the set of results, in order to remove the duplicate columns, ____ Clause is used.

  1. DUPLICATE
  2. DISTINCT
  3. REMOVE
  4. DROP
discuss
____ are the columns for the retrieval purpose

____ are the columns for the retrieval purpose.

  1. Tables
  2. WHERE Conditions
  3. Expressions
  4. None of the above
discuss
total MCQs: 30

MCQs

30

Views

199

Best Answers

299

Points

5