View the Exhibit and examine the structure of the CUSTOMERS table.

Evaluate the following SQL statement:

Which statement is true regarding the outcome of the above query?

• A.It returns an error because WHERE and HAVING clauses cannot be used to apply conditions on the same column.
• B.It returns an error because WHERE and HAVING clauses cannot be used in the same SELECT statement.
• C.It executes successfully.
• D.It returns an error because the BETWEEN operator cannot be used in the HAVING clause.

Comment: *

Name: *

Email: *

Verification: *

You issued this command:
SQL > DROP TABLE employees;
Which three statements are true? (Choose three.)

• A.The EMPLOYEES table may be moved to the recycle bin.
• B.The EMPLOYEES table can be recovered using the ROLLBACK command.
• C.The space used by the EMPLOYEES table is always reclaimed immediately.
• D.If there is an uncommitted transaction in the session, it is committed.
• E.All indexes and constraints defined on the table being dropped are also dropped.
• F.Sequences used in the EMPLOYEES table become invalid.

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true regarding multiple-row subqueries? (Choose two.)

• A.They can be used to retrieve multiple rows from a single table only.
• B.They always contain a subquery within a subquery.
• C.They can contain group functions.
• D.They should not be used with the NOT IN operator in the main query if NULL is likely to be a part of the result of the subquery.
• E.They use the < ALL operator to imply less than the maximum.

Comment: *

Name: *

Email: *

Verification: *

Examine the structure of the EMPLOYEEStable.

There is a parent/child relationship between EMPLOYEE_IDand MANAGER_ID.
You want to display the last names and manager IDs of employees who work for the same manager as the employee whose EMPLOYEE_IDis 123.
Which query provides the correct output?
SELECT e.last_name, m.manager_id

• A.FROM employees e RIGHT OUTER JOIN employees m
  on (e.employee_id = m.employee_id)
  WHERE e.employee_id = 123;
  SELECT m.last_name, e.manager_id
• B.FROM employees e LEFT OUTER JOIN employees m
  on (e.manager_id = m.manager_id)
  WHERE e.employee_id = 123;
• C.FROM employees e LEFT OUTER JOIN employees m
  on (e.employee_id = m.manager_id)
  WHERE e.employee_id = 123;
  SELECT e.last_name, e.manager_id
• D.FROM employees e RIGHT OUTER JOIN employees m
  on (e.manager_id = m.employee_id)
  AND e.employee_id = 123;
  SELECT e.last_name, m.manager_id

Comment: *

Name: *

Email: *

Verification: *

View the Exhibits and examine the structure of the COSTSand PROMOTIONStables.
You want to display PROD_IDSwhose promotion cost is less than the highest cost PROD_IDin a promotion time interval.
Examine this SQL statements:

What will be the result?
Exhibit 1.

Exhibit 2.

• A.It gives an error because the GROUP BYclause is not valid
• B.It gives an error because the ALLkeyword is not valid
• C.It executes successfully but does not give the required result
• D.It executes successfully and gives the required result

Comment: *

Name: *

Email: *

Verification: *