To display the day like Monday, Tuesday, from the date when India got independence.

Q. Answer the following questions:

(a) Define RDBMS. Name any two RDBMS software.

(b) What is the purpose of the following clauses in a select statement?

(i) ORDER BY

(ii) HAVING

(c) Site any two differences between Single_row functions and Aggregate functions.

(d) What do you understand by Cartesian Product?

 

(e) Write the name of the functions to perform the following operations:

(i) To display the day like “Monday”, “Tuesday”, from the date when India got independence.

(ii) To display the specified number of characters from a particular position of the given string.

(iii) To display the name of the month in which you were born.

(iv) To display your name in capital letters.

Answer :-

I = DAYNAME(date)

II = SUBSTR(string, pos, n)

III = MONTHNAME(date)

IV = UCASE(string)