A table Employee is given with the following attributes:

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 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 statements is/are correct about lightweightjobs in Oracle Database 12c?

For which of the following platforms in Oracle Database 12c, remote operating system authentication over a secure connection is supported?

While encrypting a tablespace in Oracle Database 12c, which of the following segments are supported for encryption? 1.Tables 2.Clusters 3.lndexes 4.LOBs

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

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

Which of the following are DCL statements?

Which of the following are DML statements?

Which of the following statements is/are correct about pluggable and container databases in a multitenant environment?