Define RDBMS. Name any two RDBMS software. (b)What is the purpose of the following clauses in a select statement?

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) GROUP BY

(c) Site any two differences between Single Row Functions and Aggregate Functions.

(d) What do you understand by Cartesian Product?

(e) Differentiate between the following statements:
(i)  ALTER and UPDATE
(ii) DELETE and DROP

(f) 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)