Chapter-MySQL Functions

Important MCQ-Based Questions on Informatics Practices (IP) class 11 chapter-MySQL Functions

This page consists of Important MCQ-Based Questions on Informatics Practices (IP) class 11 chapter-MySQL Functions all the questions are uploaded for practice with detailed explanations of every question. To check the solution, click on the answer. 

Find below Important MCQ-Based Questions on Informatics Practices (IP) class 11 chapter-MySQL Functions

Important Questions for Informatics Practices (IP) class 11 chapter-MySQL Functions set-1

Informatics Practices - MCQ on MySQL Functions

Class XI

Q.1 A special type of predefined command set that performs some operation and returns a single value is known as

a) parameter.

b) argument.

c) function.

d) calculator.

Answer:

(c)

Explanation: A function is a portion of code within a larger program, which performs a specific task and is relatively independent of the remaining code.

Q.2 The values that are provided to functions are known as

a) parameters.

b) passing values.

c) predictive values.

d) practical values.

Answer:

(a)

Explanation: A parameter is a special kind of variable that refers to data that a subroutine receives on which to operate.

Q.3 The number of categories in which SQL functions can be divided is

a) one.

b) two.

c) three.

d) ten.

Answer:

(b)

Explanation: SQL functions can be divided into – Single Row functions and Multiple Row functions.

Q.4 The functions that work with a single row at a time is known as

a) mini row function.

b) one row function.

c) first row function.

d) single row function.

Answer:

(d)

Explanation: SQL functions can be divided into – Single Row functions and Multiple Row functions. Single row functions work with a single row at a time and multiple row functions work with data of multiple rows at a time and return aggregated value.

Q.5 The functions that work with a multiple rows at a time is known as

a) multi row function.

b) main row function.

c) several row function.

d) multiple row function.

Answer:

(d)

Explanation: SQL functions can be divided into – Single Row functions and Multiple Row functions. Single row functions work with a single row at a time and multiple row functions work with data of multiple rows at a time and return aggregated value.

Q.5 The string function among the following is

a) Round().

b) Now().

c) Sysdate().

d) Instr().

Ans. d)

Explanation: INSTR function searches for given second string into the first string.

Q.7 The numeric function among the following is

a) Mod().

b) Year().

c) Concat().

d) Length().

Answer:

(a)

Explanation: Mod() function returns modulus (i.e., remainder) of given two numbers.

Q.8 The date and time function among the following is

a) Now().

b) Mod().

c) Concat().

d) Length().

Answer:

(a)

Explanation: NOW() function returns the current date and time.

Q.9 The function of MySQL which can manipulate the strings in many ways is known as

a) mathematical functions.

b) numeric functions.

c) string functions.

d) date/time functions.

Answer:

(c)

Explanation: String functions can manipulate the text string in many ways. Different types of String functions are: CHAR(), CONCAT, LOWER/LCASE, SUBSTR, LTRIM, UPPER/UCASE, RTRIM, TRIM, INSTR, LEFT, RIGHT, MID

Q.10 The function that returns the character for each integer passed is known as

a) CONCAT.

b) LOWER.

c) SUBSTR.

d) CHAR.

Ans. d)

Explanation: SYNTAX - CHAR(value1 [, value2 …]) It returns a string made up of the ASCII representation of the decimal value list. Strings in numeric format are converted to a decimal value. Null values are ignored.

Q.11 The argument type of CHAR() is

a) null.

b) integer.

c) string.

d) number.

Answer:

(b)

Explanation: Its argument types are integers. For e.g., SELECT CHAR(65, 67.3, 69.8

Q.12 The return value of CHAR() is

a) null.

b) integer.

c) string.

d) number.

Answer:

(c)

Explanation: Its return value is string. For e.g., SELECT CHAR(65, 67.3, 69.8 and output is ACE, which is a string.

Q.13 The output of the given query mysql>SELECT CHAR (70, 65, 67, 69 is

a) CASE.

b) RACE.

c) FACE.

d) LACE.

Answer:

(c)

Explanation: CHAR() returns a string made up of the ASCII representation of the decimal value list.

Q.14 The output of the given query mysql> SELECT CHAR ( 65, 67.3, 69.3 is

a) BGE.

b) RCE.

c) MHT.

d) ACE.

Answer:

(d)

Explanation: CHAR() returns a string made up of the ASCII representation of the decimal value list.

Q.15 The function which combines two strings is known as

a) COMBINE.

b) CONCAT.

c) COLLECT.

d) TRUNCATE.

Answer:

(b)

Explanation: CONCAT concatenates two strings.

Q.15 The argument types of CONCAT() are

a) null, string.

b) integer, integer.

c) string, string.

d) number, string.

Answer:

(c)

Explanation: Its argument types are string, string. For e.g., SELECT CONCAT(‘ADITI’, ‘SUNEJA’)

Q.17 The return value of CONCAT() is

a) null.

b) integer.

c) string.

d) number.

Answer:

(c)

Explanation: Its return value is string. For e.g., SELECT CONCAT (‘ADITI’, ‘SUNEJA’) and the output is ADITISUNEJA which is a string.

Q.18 The function that converts a string into lowercase is

a) UCASE(str.

b) lCASE(str).

c) LCASE(str).

d) LOWERCASE(str).

Answer:

(c)

Explanation: LCASE(str) returns the argument str, with all letters in lowercase.

Q.19 The argument type of LOWER function is

a) null.

b) string.

c) number.

d) integer.

Answer:

(b)

Explanation: Its argument type is string. For e.g., SELECT LOWER(‘ADITI’) AS “Lowername”.

Q.20 The return value of LOWER function is

a) null.

b) string.

c) number.

d) integer.

Answer:

(b)

Explanation: For e.g., SELECT LOWER(‘ADITI’) AS “Lowername”. Its output is aditi, which is a string.

Q.21 The output of SELECT LOWER(‘CHIKY’) is

a) Chiky.

b) CHIKY.

c) chiky.

d) ChikY.

Answer:

(c)

Explanation: LOWER(str) returns the argument str, with all letters in lowercase.

Q.22 The function LOWER is equivalent to

a) LCASE.

b) LITTLE.

c) SMALL.

d) LUCASE.

Answer:

(a)

Explanation: Its syntax is LOWER(str) or LCASE(str). Both serve the same purpose.

Q.23 The string that extracts a substring from a given string is

a) SUBSTR.

b) SUBSTRG.

c) SBSTR.

d) SUBSTRN.

Answer:

(a)

Explanation: SUBSTR( str, m[,n] returns a portion of str, beginning at character m, n characters long.

Q.24 The function SUBSTRING is equivalent to

a) SUBSTR.

b) SUBSTRG.

c) SBSTR.

d) SUBSTRN.

Answer:

(a)

Explanation: In the syntax, SUBSTRING or SUBSTR can be used. Both serve the same purpose.

Q.25 The argument type of SUBSTR is

a) String, Numeric [, Numeric].

b) String, String [, Numeric].

c) String, Numeric [, String].

d) String, String [, String].

Answer:

(a)

Explanation: For e.g., SELECT SUBSTR(‘ADITI’, 3,3. It will give output as ITI.

Q.25 The return value of SUBSTR is

a) integer.

b) number.

c) null.

d) string.

Answer:

(d)

Explanation: For e.g., SELECT SUBSTR(‘NAME’, 2,2. The output will be ‘AM’ which is a string.

Q.27 The output of the query SELECT SUBSTR(‘ABCDEFG’, -5, 4 “Subs”; is

a) ABCD.

b) BCDE.

c) CDEF.

d) DEFG.

Answer:

(c)

Explanation: The output displays 4 characters extracted from 5th right character onwards from string ‘ABCDEFG’.

Q.28 The function that converts the given string into upper case is

a) UCASE(str).

b) LCASE(str).

c) ULCASE(str).

d) LUCASE(str).

Answer:

(a)

Explanation: UCASE returns argument str, with all letters uppercase.

Q.29 The argument type of UPPER/UCASE function is

a) integer.

b) number.

c) string.

d) null.

Answer:

(c)

Explanation: For e.g., SELECT UPPER (‘Large’) “Uppercase”. Here, string is passed as argument.

Q.30 The return value of UCASE is

a) integer.

b) number.

c) string.

d) null.

Answer:

(c)

Explanation: For e.g., SELECT UPPER (‘Large’) “Uppercase”. Here, string is passed as argument. The output is LARGE, so the return type is also string.

Important Questions for Informatics Practices (IP) class 11 chapter-MySQL Functions set-2

Q.31 The function UCASE is synonym of

a) LOWER.

b) UPPER.

c) CHAR.

d) CONCAT.

Answer:

(b)

Explanation: The syntax is either UPPER(str) or UCASE(str). Both convert the given string into upper case.

Q.32 The output of the query SELECT UPPER (‘kleptomania’) is

a) Kleptomania.

b) KLEPTOMANIA.

c) Kleptomania.

d) KLEPtomania.

Answer:

(b)

Explanation: UPPER(str) returns argument str, with all the letters uppercase.

Q.33 The function that removes leading space of given string is

a) TRIM.

b) LTRIM.

c) RTRIM.

d) LEAD.

Answer:

(b)

Explanation: LTRIM(str) removes spaces from the left of argument str with initial characters removed.

Q.34 The argument type of LTRIM is

a) string.

b) integer.

c) number.

d) null.

Answer:

(a)

Explanation: For e.g., SELECT LTRIM(‘ ADITI’). Here, the argument passed is string.

Q.35 The return type of LTRIM is

a) string.

b) integer.

c) number.

d) null.

Answer:

(a)

Explanation: For e.g., SELECT LTRIM(‘ ADITI’). Here, the argument passed is string and the return type is also string.

Q.35 The function that removes trailing spaces of given string is

a) TRIM.

b) LTRIM.

c) RTRIM.

d) LEAD.

Answer:

(c)

Explanation: RTRIM(str) returns str, with trailing spaces removed after the last character.

Q.37 The argument type of RTRIM is

a) string.

b) integer.

c) numeric.

d) null.

Answer:

(a)

Explanation: For e.g., SELECT RTRIM(‘ RDBMS MySQL ‘); Here, the argument type is string.

Q.38 The return type of RTRIM is

a) string.

b) integer.

c) numeric.

d) null.

Answer:

(a)

Explanation: For e.g., SELECT RTRIM(‘ RDBMS MySQL ‘); Here, the argument type is string and the return type is also string.

Q.39 The function that removes leading and trailing spaces from a given string is

a) LTRIM.

b) RTRIM.

c) TRIM.

d) LETR.

Answer:

(c)

Explanation: TRIM performs combined functions of LTRIM() and RTRIM().

Q.40 A single function that performs the combined action of LTRIM() and RTRIM() is

a) LRTRIM()

b) RTTRIM()

c) TRIM()

d) LLRR()

Answer:

(c)

Explanation: TRIM removes leading and trailing spaces from a given string.

Q.41 The argument type of TRIM is

a) string.

b) integer.

c) numeric.

d) null.

Answer:

(a)

Explanation: For e.g., SELECT TRIM(‘ ADITI ‘); Here, the argument passed is string.

Q.42 The return value of TRIM is

a) string.

b) integer.

c) numeric.

d) null.

Answer:

(a)

Explanation: For e.g., SELECT TRIM(‘ ADITI ‘);

Here, the argument passed is string and the return value is also string.

Q.43 The output of query SELECT TRIM(LEADING ‘X’ from ‘XXXXmobileXXXX’);

a) XXXXMOBILE.

b) MobileXXXX.

c) mobileXXXX.

d) XXXXmobile.

Answer:

(c)

Explanation: TRIM removes leading and trailing spaces from a given string. But, in the query only leading keyword is mentioned. Therefore, the output is mobileXXXX.

Q.44 The output of query SELECT TRIM(TRAILING ‘X’ from ‘XXXXmobileXXXX’);

a) XXXXMOBILE.

b) MobileXXXX.

c) mobileXXXX.

d) XXXXmobile.

Answer:

(d)

Explanation: TRIM removes leading and trailing spaces from a given string. But, in the query only TRAILING keyword is mentioned. Therefore, the output is XXXXmobile.

Q.45 The output of query SELECT TRIM(BOTH ‘X’ from ‘XXXXmobileXXXX’);

a) XXXXMOBILE.

b) MobileXXXX.

c) mobile.

d) XXXXmobile.

Answer:

(c)

Explanation: TRIM removes leading and trailing spaces from a given string. Therefore, the output is mobile.

Q.45 The function that searches for given second string into the given first string is

a) INSTR.

b) LENGTH.

c) LEFT.

d) RIGHT.

Answer:

(a)

Explanation: INSTR(str1, str2 searches str1 for str2 and returns the position.

Q.47 The argument type of INSTR is

a) string, integer.

b) string, string.

c) integer, integer.

d) null.

Answer:

(b)

Explanation: For e.g., SELECT INSTR(‘MINDMAP’, ‘IN’) As Instring. Here, both the arguments are strings.

Q.48 The return type of INSTR is

a) string.

b) null.

c) number.

d) integer.

Answer:

(c)

Explanation: For e.g., SELECT INSTR(‘MINDMAP’, ‘IN’) As Instring. Here, Both the arguments are strings. The output is 2 which implies the return type is number.

Q.49 The output of the query SELECT INSTR(‘MINDMAP’, ‘IN’) is

a) 1.

b) 2.

c) 3.

d) 4.

Answer:

(b)

Explanation: The output is 2, as the position of string ‘IN’ in string ‘MINDMAP’ is 2.

Q.50 The function that returns the length of a given string in bytes is

a) LENGTH.

b) LEFT.

c) RIGHT.

d) MID.

Answer:

(a)

Explanation: LENGTH(str)returns the length of parameter specified by argument str in characters.

Q.51 The argument type of LENGTH is

a) string.

b) integer.

c) number.

d) null.

Answer:

(a)

Explanation: For e.g., SELECT LENGTH(‘ADITI’). Here, the argument type is string.

Q.52 The return type of LENGTH is

a) string.

b) number.

c) null.

d) integer.

Answer:

(b)

Explanation: For e.g., SELECT LENGTH(‘ADITI’). Here, the argument type is string. The output is 5 as the length of characters is 5.

Q.53 The result of query SELECT LENGTH(‘ADITI’) “Length in Characters”; is

a) 3

b) 4

c) 5

d) 6

Answer:

(d)

Explanation: The output is 5 as the length of characters are 5.

Q.54 The function that returns the leftmost number of characters from the string str is

a) LEFT.

b) LEFTMOST.

c) LEFTNUM.

d) LEFTCHAR.

Answer:

(a)

Explanation: LEFT(str, len) returns the leftmost len characters from the string str.

Q.55 The argument types of LEFT is

a) string, string,

b) integer, integer.

c) string, integer.

d) null.

Answer:

(c)

Explanation: For e.g. SELECT LEFT (‘GSS/22/76/09’, 3; Here, the argument types are string, integer.

Q.55 The return value of LEFT is

a) string.

b) integer.

c) null.

d) number.

Answer:

(a)

Explanation: For e.g. SELECT LEFT (‘GSS/22/76/09’, 3; Here, the argument types are string, integer. The output is GSS, so the return type is string.

Q.57 The output of the query SELECT LEFT(‘GSS/22/76/09’, 3; is

a) /09.

b) 22/.

c) GSS.

d) ‘GS.

Answer:

(c)

Explanation: The output of the query is GSS, as these are the leftmost 3 characters.

Q.58 The function that returns the rightmost number of characters as specified is

a) RIGHT.

b) RIGHTMOST.

c) RIGNUM.

d) RIGCHAR.

Answer:

(a)

Explanation: RIGHT(str, len) returns the rightmost len characters from the string str.

Q.59 The argument types of RIGHT are

a) string, integer

b) string.

c) integer.

d) null.

Answer:

(a)

Explanation: For example – SELECT RIGHT(‘USS/23/67/09’, 2; See, the argument types are string, integer.

Q.60 The return type of RIGHT is

a) string.

b) integer.

c) number.

d) null.

Answer:

(a)

Explanation: For example – SELECT RIGHT(‘USS/23/67/09’, 2; Here, the argument types are string, integer. The result is 09, which is a string.

Q.61 The result of the query SELECT RIGHT(‘USS/23/67/09’, 2; is

a) 23.

b) 67.

c) 09.

d) US.

Answer:

(c)

Explanation: The result is 09, as in the string ‘USS/23/67/09’ the rightmost digits are 09.

Q.62 The function that returns a substring starting from the specified position is

a) MID.

b) LEFT.

c) RIGHT.

d) MIDDLE.

Answer:

(a)

Explanation: MID(str, pos, len) returns a substring from str starting from pos and having number of characters as len.

Q.63 The argument types of MID are

a) integers

b) strings.

c) null.

d) numbers

Answer:

(a)

Explanation: For e.g., SELECT MID(‘marvelous’, 4,3. Here, the argument types are integers.

Q.64 The return type of MID is

a) string.

b) number.

c) integer.

d) null.

Answer:

(a)

Explanation: For e.g., SELECT MID(‘marvelous’, 4,3. Here, the argument types are integers. The result is ‘vel’, which is a string.

Q.65 The output of the query SELECT MID(‘marvelous’, 4,3; is

a) rve.

b) vel.

c) ous.

d) lou.

Answer:

(b)

Explanation: The output is vel, as it is the substring of ‘marvelous’ which is starting at position 4 of length of 3.

Q.66 The functions that accept numeric values and after performing the required operation, return numeric values is

a) integer function.

b) power function.

c) mod functions.

d) numeric functions.

Answer:

(d)

Explanation: These functions take numeric values and in the output also give numeric values.

Q.67 The argument type of numeric functions is

a) string.

b) date.

c) null.

d) numeric.

Answer:

(d)

Explanation: These functions take numeric values and in the output also give numeric values.

Q.68 The return type of numeric functions is

a) string.

b) date.

c) null.

d) numeric.

Answer:

(d)

Explanation: These functions take numeric values and in the output also give numeric values.

Q.69 The function that returns modulus of two numbers is

a) MID.

b) MODULUS.

c) MOD.

d) MODL.

Answer:

(c)

Explanation: MOD(m, n) returns remainder of argument m divided by argument n.

Q.70 The output of query SELECT MOD(232, 4; is

a) 1.

b) 2.

c) 3.

d) 0.

Answer:

(d)

Explanation: This function returns remainder of argument m divided by argument n where m is 232 and n is 4.

Important Questions for Informatics Practices (IP) class 11 chapter-MySQL Functions set-3

Q.71 The function that returns mn is

a) MOD.

b) POW.

c) MID.

d) SQRT.

Answer:

(b)

Explanation: POW(m, n) returns value of argument m raised to the nth power.

Q.72 The result of the query SELECT POWER(5, 4; is

a) 25.

b) 9.

c) 20.

d) 625.

Answer:

(d)

Explanation: The result is 625 as 54 is 625.

Q.73 The function that returns a number rounded off as per the given instructions is

a) ROUND.

b) TRUNCATE.

c) MOD.

d) MID.

Answer:

(a)

Explanation: ROUND(n[,m]) returns value of argument n rounded to m places right of the decimal point.

Q.74 The result of the query SELECT ROUND(16.789, 1 is

a) 16.7

b) 16.9

c) 17

d) 16.8

Answer:

(d)

Explanation: ROUND(n[,m]) returns value of argument n rounded to m places right of the decimal point.

Q.75 The function that returns sign of a given number is

a) MOD.

b) POW.

c) SIGN.

d) SQRT.

Answer:

(c)

Explanation: SIGN(n) returns -1 if the argument n<o, SIGN(n) returns 0 if the argument n=o, SIGN(n) returns 1 if the argument n>o.

Q.75 The result of the query SELECT SIGN(199; is

a) 1.

b) -1.

c) 0.

d) 199.

Answer:

(a)

Explanation: SIGN(n) returns -1 if the argument n<o, SIGN(n) returns 0 if the argument n=o, SIGN(n) returns 1 if the argument n>o.

Q.77 The function that returns the square root of given number is

a) ROOT.

b) SQUARE.

c) SQRT.

d) SQROOT.

Answer:

(c)

Explanation: SQRT(n) returns square root of argument n.

Q.78 The result of query SQRT(625; is

a) 13.

b) 25.

c) 125.

d) 55.

Answer:

(b)

Explanation: The output is 25, as the square root of 625 is 25.

Q.79 The function that returns a number with some digits truncated, is

a) TRUNCATE.

b) ROUND.

c) TRUN.

d) TRUNC.

Answer:

(a)

Explanation: TRUNCATE(n, m) returns value of argument n truncated to argument m decimal places.

Q.80 The result of query TRUNCATE(15.9876, 1; is

a) 15.9

b) 15.8

c) 16.0

d) 15.987

Answer:

(a)

Explanation: TRUNCATE(n, m) returns value of argument n truncated to argument m decimal places.

Q.81 The functions that operate on values of the DATE datatype are known as

a) numeric functions.

b) mathematical functions.

c) string functions.

d) date/time functions.

Answer:

(d)

Explanation: Date/time functions are the functions to manipulate date and time based functions.

Q.82 The function that extracts the date part of a date or datetime expression is

a) CURDATE().

b) DATE().

c) MONTH().

d) YEAR().

Answer:

(b)

Explanation: DATE(expr) extracts the date part of the date or datetime expression expr.

Q.83 The function that returns the month from the date passed is

a) CURDATE().

b) DATE().

c) MONTH().

d) YEAR().

Answer:

(c)

Explanation: MONTH(date) returns the month for date, in the range 1 to 12 for January to December.

Q.84 The function that returns the current date is

a) CURDATE().

b) DATE().

c) CURRDATE().

d) DATECUR().

Answer:

(a)

Explanation: CURDATE() returns the current date as a value in ‘YYYY-MM-DD’ or YYYYMMDD format, depending upon whether the function is used in a string or numeric context.

Q.85 The function that returns the year part of a date is

a) DATE(YEAR).

b) YEAR().

c) YEAR date().

d) DATE().

Answer:

(b)

Explanation: YEAR(date) returns the year for date, in the range 1000 to 9999.

Q.86 The function that returns the name of weekday is

a) DAYNAME().

b) DAYOFMONTH().

c) DAYOFWEEK().

d) DAYOFYEAR().

Answer:

(a)

Explanation: DAYNAME(date) returns the name of the weekday for date.

Q.87 The function that returns the day of month is

a) MONTH()

b) DAYMONTH()

c) DAYOFWEEK()

d) DAYOFMONTH()

Answer:

(d)

Explanation: DAYOFMONTH(date) returns the name of the month for date in the range 1 to 31.

Q.88 The function that returns the day of week is

a) WEEKDAY().

b) DAYWEEK().

c) DAYOFWEEK().

d) WEEKENDDAY().

Answer:

(c)

Explanation: DAYOFWEEK() returns the weekday index for date (1 = Sunday, 2 = Monday, …, 7 = Saturday)

Q.89 The function that returns the day of the year is

a) YEAR OF DAY().

b) DAYOFYEAR().

c) YEAROFDAY().

d) YEARDAY().

Answer:

(b)

Explanation: DAYOFYEAR(date) returns the day of the year for date, in the range 1 to 366.

Q.90 The function that returns the current date and time is

a) CURDATE().

b) CURTIME().

c) NOW().

d) THEN().

Answer:

(c)

Explanation: NOW() returns a constant time that indicates the time at which the statement began to execute.

Q.91 The function that returns the time at which the function executes is

a) CURDATE().

b) CURTIME().

c) NOW().

d) SYSDATE().

Answer:

(d)

Explanation: SYSDATE() returns the time at which it executes. It is different from NOW().

Q.92 The argument type of CURDATE() is

a) date

b) datetime.

c) integer.

d) none.

Answer:

(d)

Explanation: The syntax is CURDATE() to display current date. No arguments are passed.

Q.93 The argument type of MONTH() is

a) date.

b) datetime.

c) integer.

d) string.

Answer:

(a)

Explanation: For e.g. SELECT MONTH(‘2009-11-04’); Here, the argument type passed is date.

Q.94 The return type of MONTH() is

a) date.

b) datetime.

c) integer.

d) string.

Answer:

(c)

Explanation: For e.g. SELECT MONTH(‘2009-11-04’); Here, the argument type passed is date. The output is 11, which is an integer.

Q.95 The return type of DAYNAME() is

a) date.

b) datetime.

c) integer.

d) string.

Answer:

(d)

Explanation: For e.g., SELECT DAYNAME(‘2009-11-04’); Here, the argument type is date. The output is Wednesday, which is a string.

Q.95 The return type of NOW() is

a) none.

b) date

c) datetime.

d) integer.

Answer:

(c)

Explanation: For e.g., SELECT NOW(); The output will contain current date and time.

Q.97 The return type of SYSDATE() is

a) none.

b) date

c) datetime.

d) integer.

Answer:

(c)

Explanation: For e.g., SELECT SYSDATE(); The output will contain current date and time.

Q.98 The argument type of DATE() is

a) none.

b) date or datetime.

c) time.

d) string.

Answer:

(b)

Explanation: For e.g., SELECT DATE (‘2009-11-04 01:20:09’);

Here, the argument type is datetime and it can be only date.

Q.99 The argument type of NOW() is

a) none.

b) date.

c) datetime.

d) string.

Answer:

(a)

Explanation: In NOW() function, no argument is passed.

Q.100 The argument type of SYSDATE() is

a) none.

b) date.

c) datetime.

d) string.

Answer:

(a)

Explanation: In SYSDATE() function, no argument is passed.

Frequently Asked Questions on Chapter-MySQL Functions