Unit 5

Question 1

function produces a date by adding a specified number to a specified part of a date.

Answer 1

DATEADD

Question 2

function returns the difference between two parts of a date.

Answer 2

DATEDIFF

Question 3

function subtracts a specified time interval from a date.

Answer 3

DATE_SUB()

Question 4

function returns the specified part of the date requested.

Answer 4

DATEPART

Question 5

function is used to return a single part of a date/time, such as year, month, day, hour, minute, etc.

Answer 5

EXTRACT()

Question 6

function will extract the year from a value stored as a SMALLDATETIME data type.

Answer 6

YEAR

Question 7

function will extract the month from a date.

Answer 7

MONTH

Question 8

function extracts the day of the month from a date

Answer 8

DAY

Question 9

function returns the current system date and time

Answer 9

GETDATE

Question 10

function returns the current system date and time in Universal Time Coordinate Format, useful for getting date and time of other location.

Answer 10

GETUTCDATE

Question 11

Returns the current date and time

Answer 11

NOW()

Question 12

Returns the current date

Answer 12

CURDATE()

Question 13

Returns the current time

Answer 13

CURTIME()

Question 14

Returns the current utc date

Answer 14

UTC_DATE()

Question 15

Returns the current utc time

Answer 15

UTC_TIME()

Question 16

operate on values in single rows, one row at a time.

Answer 16

Row-level Functions

Question 17

function rounds numbers to a specified number of decimal places.

Answer 17

ROUND

Question 18

(attribute), which returns the next larger integer value when a number contains decimal places.

Answer 18

CEILING

Question 19

(attribute), which returns the next lower integer value when a number contains decimal places.

Answer 19

FLOOR

Question 20

(attribute), which returns the square root of positive numeric values.

Answer 20

SQRT

Question 21

(attribute), which returns the absolute value of any numeric value.

Answer 21

ABS

Question 22

(attribute), which returns a number squared.

Answer 22

SQUARE

Question 23

To handle the null issue, SQL Server provides a row-level function, which returns a value if a table value is null.

Answer 23

Isnull

Question 24

A function, which returns a NULL if expression1 = expression2. If the expressions are not equal, then expression1 is returned.

Answer 24

NULLIF

Question 25

function is used to display or return from a result set the rows that fall at the top of a range specified by an ORDER BY clause.

Answer 25

TOP

Question 26

returns a certain percentage of rows that fall at the top of a specified range.

Answer 26

PERCENT

Question 27

clause is used in the SELECT statement to constrain the number of rows in a result set. The —– clause accepts one or two arguments. The values of both arguments must be zero or positive integer constants.

Answer 27

LIMIT

Question 28

specifies the offset of the first row to return. The offset of the first row is 0, not 1.

Answer 28

offset

Question 29

specifies maximum number of rows to return.

Answer 29

count

Question 30

is a specialized conversion function that always converts from a number (for example, float or numeric) to a character data type

Answer 30

STR

Question 31

function is also used to explicitly convert to a given data type. But, the ——- function has additional limited formatting capabilities.

Answer 31

CONVERT

Question 32

function returns part of a string

Answer 32

SUBSTRING

Question 33

removes blanks from the beginning (left) of a string.

Answer 33

LTRIM

Question 34

removes blanks from the end (right) of a string.

Answer 34

RTRIM

Question 35

function returns the starting position of a specified pattern.

Answer 35

CHARINDEX

Question 36

returns the substring from the given string before a specified number of occurrences of a delimiter.

Answer 36

SUBSTRING_INDEX()

Question 37

function returns the starting position of a specified pattern

Answer 37

INSTR

Question 38

To produce all the fields in the result set (output) in uppercase or in lowercase

Answer 38

UPPER/ LOWER

Question 39

function returns the length (number of characters) of a desired string excluding trailing blanks.

Answer 39

LEN