WEEK 11 (PRE-FINALS)

Question 1

are built-in operations that perform specific tasks on data.

Answer 1

SQL FUNCTIONS

Question 2

These functions can be used in SQL queries to manipulate, aggregate, or analyze data.

Answer 2

SQL Functions

Question 3

are the one who work on single row and return one output per row.

Answer 3

Single Row Functions

Question 4

For example, length and case conversion functions are __________

Answer 4

Singe Row Functions

Question 5

work upon group of rows and return one result for the complete set of rows.

Answer 5

Multi-Row Functions

Question 6

Multi-Row functions are also known as?

Answer 6

Group Functions

Question 7

Accepts character input and returns number or character value.

Answer 7

Character Functions

Question 8

What is the under the Character Functions

Answer 8

CONCAT
LENGTH
SUBSTR
INSTR
LPAD
RPAD
TRIM
REPLACE

Question 9

What are the aggregate functions

Answer 9

AVG
SUM
COUNT
MAX
MIN

Question 10

It returns the average of all values in the given column.

Answer 10

AVG()

Question 11

What is the syntax for AVG

Answer 11

SELECT AVG(col_name) from table_name;

Question 12

It returns the sum of all values in the given column.

Answer 12

SUM()

Question 13

What is the syntax for SUM

Answer 13

SELECT SUM(< col_name >) from < table_name >;

Question 14

It returns the no. of rows in the given column.

Answer 14

COUNT()

Question 15

What is the syntax for COUNT

Answer 15

SELECT COUNT (< col_name >) from < table_name >

Question 16

It selects the MAXIMUM value in the specified column.

Answer 16

MAX()

Question 17

What is the syntax for MAX

Answer 17

SELECT MAX(< col_name >) from < table_name >;

Question 18

It selects the MINIMUM value in the specified column.

Answer 18

MIN()

Question 19

What is the Syntax for MIN

Answer 19

SELECT MIN(< col_name >) from < table_name >;

Question 20

What are the types of string functions

Answer 20

UPPER(x)
LOWER(x)
INSTR
SUBSTR
CONCAT
LPAD
RPAD

Question 21

It converts the string ‘X’ to UPPER case

Answer 21

UPPER(x)

Question 22

It converts the string to ‘X’ to LOWER case

Answer 22

LOWER(x)

Question 23

function returns numeric position of a character or a string in a given string.

Answer 23

INSTR

Question 24

Returns the substring of given string starting from position integer ‘m’ and length integer ‘n’

Answer 24

SUBSTR(x,m,n)

Question 25

adds string to its left.

Answer 25

LPAD

Question 26

function concatenates two string values

Answer 26

CONCAT

Question 27

adds string to its right.

Answer 27

RPAD

Question 28

What are the types of numeric functions

Answer 28

ROUND(value, decimal) TRUNCATE(x, y) MOD(value, divisor)

Question 29

Rounds value to decimal places.

Answer 29

ROUND(value, decimal)

Question 30

Truncate values of “x” up to “y” decimal places.

Answer 30

TRUNCATE(x, y)

Question 31

Returns remainder of value divided by divisor.

Answer 31

MOD(value, divisor)