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?

Choose the incorrect statements about an object identif‌ier (01D)? 1. The value of an OlD is visible to an external user. 2. It is used by a system to identify Objects uniquely. 3. An OID cannot be assigned to variables in programs.

Database normalization is used to .

Which of the following relations is also called a snapshot relation?

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?

How can a timestamp be implemented in a database?

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 following statements will be used to delete all the records from a table named, th? 1. DELETE from tb1; 2. DELETE ‘ from tb1; 3. DELETE tb1;

Which of the following correlated SQL queries will return Employeeld. EmployeeName, Salary and Department of all the employees whose salary is more than the average salary of employees in their respective departments?