Database [3i Infotech Placement]: Sample Questions 39 - 40 of 294

Glide to success with Doorsteptutor material for competitive exams : get questions, notes, tests, video lectures and more- for all subjects of your exam.

Question 39

Database
Edit

Describe in Detail

Essay▾

Which function is used to find the largest integer less than or equal to a specific value?

Explanation

  • FLOOR function is used to find the largest integer less than or equal to a specific value.
  • Used to round a number down to the last whole number.
  • The highest decimal is rounded down with any number.

Syntax:

FLOOR (numeric_expression)

Arguments:

numeric_expression:

  • It is an expression of the exact number or approximate numeric data type category, except for the bit data type.

Example:

SELECT FLOOR (-5.12) ;

This will round down to -6

SELECT FLOOR (5.14) ;

This will round down to 5

Question 40

Database
Edit

Statement

True-False▾

EXISTS, SOME, ANY are operators in SQL.

Answer

TRUE

Explanation

EXISTS operator:

  • Used to test for the existence of any record in a subquery.
  • Returns true if subquery returns one or more record.

Syntax:

SELECT column_name (s)

FROM table_name

WHERE EXISTS

(SELECT column_name FROM table_name WHERE condition) ;

SOME operator:

  • Compares a value to every other value in list or results from query.
  • It evaluates to true if the result of an inner query contains at least one row.

Syntax:

SELECT [column_name … . | expression1}

FROM [table_name]

Where expression2 comparison_operator {ALL|ANY|SOME} (subquery)

ANY operator:

  • ANY compares a value to every value in list or result from a query
  • It evaluates to true if the result of an inner query contains at least one row.
  • It is preceded by comparison operators.
  • Using greater (>) with ANY ensures result greater than at least one value.

Syntax:

SELECT [column_name … | expression1|

FROM [table_name]

WHERE expression2 comparison_operator {ALL|ANY|SOME} (subquery)

Developed by: