Examine the below-given SQL statements applied on a table named, Employees and answer the following question.

1. SELECT Iast_name, salary, hire_date FROM EMPLOYEES ORDER BY salary DESC

2. SELECT Iast_name, salary. hire_date FROM EMPLOYEES ORDER BY 2 DESC

Which of the answer options is true?

How can a timestamp be implemented in a database?

Which of the following is NOT the correct syntax to write the REVOKE statement that is used to revoke a privilege on a table named, Employee from user2?

Which type of constraints are expressed by the application programs and not directly expressed in the schemas Of the data model?

Consider a table titled 'StudentDetails' having the following attributes:

Which of the following SOL queries will return the details of only those students who are enrolled in the 'Cricket' club?