Advanced functions

Question 1

Returns a binary representation of a number

Answer 1

BIN

Question 2

Converts a value to a binary string

Answer 2

BINARY

Question 3

Goes through conditions and return a value when the first condition is met

Answer 3

CASE

Question 4

Converts a value (of any type) into a specified datatype

Answer 4

CAST

Question 5

Returns the first non-null value in a list

Answer 5

COALESCE

Question 6

Returns the unique connection ID for the current connection

Answer 6

CONNECTION ID

Question 7

Converts a number from one numeric base system to another

Answer 7

CONV

Question 8

Converts a value into the specified datatype or character set

Answer 8

CONVERT

Question 9

Returns the user name and host name for the MySQL account that the server used to authenticate the current client

Answer 9

CURRENT USER

Question 10

Returns the name of the current database

Answer 10

DATABASE

Question 11

Returns a value if a condition is TRUE, or another value if a condition is FALSE

Answer 11

IF

Question 12

Return a specified value if the expression is NULL, otherwise return the expression

Answer 12

IFNULL

Question 13

Returns 1 or 0 depending on whether an expression is NULL

Answer 13

ISNULL

Question 14

Returns the AUTO_INCREMENT id of the last row that has been inserted or updated in a table

Answer 14

LAST INSERT ID

Question 15

Compares two expressions and returns NULL if they are equal. Otherwise, the first expression is returned

Answer 15

NULLIF

Question 16

Returns the current MySQL user name and host name

Answer 16

SESSION USER

Question 17

Returns the current MySQL user name and host name

Answer 17

SYSTEM USER

Question 18

Returns the current MySQL user name and host name

Answer 18

USER

Question 19

Returns the current version of the MySQL database

Answer 19

VERSION