Which key word is used to sort the records of a table in descending order? Which command is used

Q.

(a) Which key word is used to sort the records of a table in descending order?

(b) Which command is used to modify the records of the table?

(c) Which clause is used to remove the duplicate rows of the table?

(d) Differentiate between Primary key and Candidate key,

(e) Differentiate between Degree and Cardinality key.

Answer =

(a) DESC

(b) UPDATE

(c) DISTINCT
(d) Candidate key: A candidate key is the one that is capable of becoming primary key i.e., a field or attribute that has unique value for each row in the relation.
Primary key is a designated attribute or a group whose values can uniquely identify the tuples in the relation.
(e)
Degree. It refers to the total number of attributes in the table.
Cardinality. It refers to the total number of tuples in the table.