Which of the following are DML statements?

Which of the following are DCL statements?

While deferring constraint checks in Oracle Database 12c, which of the following statements hold true?

Find the error in the following query. if the Students table contains several records.

Which of the following are the new features in Oracle Database 12c?

While creating a database password file in Oracle Database 12c, which of the given administrative privileges are supported. if we set the FORMAT argument tvalue. legacy?

Which of the following statements is/are correct about lightweightjobs in Oracle Database 12c?

A production house needs a report about the sale, where total sale of the day is more than $20,000.Which query should be used?

Which of the following co—related SQL queries will return Employeeld, EmployeeName, Salary and Department of all those employees whose salary is more than the average salary of employees in that employee's department?

A table Employee is given with the following attributes:

Valid in Oracle Database 12c? 1.ANALYZE INDEX indx_pv VALIDATE STRUCTURE; 2.ANALYZE TABLE tbemployees VALIDATE STRUCTURE CASCADE; 3.ANALYZE TABLE tbemployees VALIDATE STRUCTURE ONLINE; 4.ANALYZE CLUSTER clpersonnel VALIDATE STRUCTURE CASCADE;