Examine the structure of the INVOICEtable.

Which two SQL statements would execute successfully?
SELECT inv_no, NVL2(inv_date, 'Pending', 'Incomplete')

Examine this data in the EMPLOYEES table:

Which statement will execute successfully?
SELECT dept_id, INSTR(last_name, 'A'), SUM(salary) FROM employees GROUP BY

View the exhibit and examine the description of the PRODUCT_INFORMATION table.

Which SQL statement would retrieve from the table the number of products having LIST_PRICE as NULL?

You have the privileges to create any type of synonym.
Which stalement will create a synonym called EMP for the HCM.EMPLOYEE_RECORDS table that is accesible to all users?

Examine the structure of the EMPLOYEES table.

You must display the details of employees who have manager with MANAGER_ID 100, who were hired in the past 6 months and who have salaries greater than 10000.
Which query would retrieve the required result?