Examine the structure of the EMPLOYEEStable.
Name Null? Type
- ---------------- ----- ------ ------
EMPLOYEE_ID NOT NULL NUMBER(6)
FIRST_NAME VARCHAR2(20)
LAST_NAME NOT NULL VARCHAR2(25)
EMAIL NOT NULL VARCHAR2(25)
PHONE NUMBER VARCHAR2(20)
HIRE_DATE NOT NULL DATE
JOB_ID NOT NULL VARCHAR2(10)
SALARY NUMBER(8,2)
COMMISSION_PCT NUMBER(2,2)
MANAGER_ID NUMBER(6)
DEPARTMENT_ID NUMBER(4)
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?

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

Comment: *

Name: *

Email: *

Verification: *

Which two statement are true regarding table joins available in the Oracle Database server? (Choose two.)

• A.You can use the USING clause to join tables on more than one column.
• B.You can explicitly provide the join condition with a NATURAL JOIN.
• C.You can use the JOIN clause to join only two tables.
• D.You can use the ON clause to specify multiple conditions while joining tables.

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the data in the PRODUCTS table.

You must display product names from the PRODUCTS table that belong to the 'Software/other' category with minimum prices as either $2000 or $4000 and with no unit of measure.
You issue this query:

Which statement is true?

• A.It executes successfully but returns no result.
• B.It executes successfully and returns the required result.
• C.It generates an error because the condition specified for the PROD_CATEGORY column is not valid.
• D.It generates an error because the condition specified for PROD_UNIT_OF_MEASURE is not valid.

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the CUSTOMERS table:

You need to display last names and credit limits of all customers whose last name starts with A or B in lower or upper case, and whose credit limit is below 1000.
Examine this partial query:

Which two WHERE conditions give the required result?

• A.Option B
• B.Option D
• C.Option C
• D.Option E
• E.Option A

Comment: *

Name: *

Email: *

Verification: *

Which two are true about scalar subquery expressions? (Choose two.)

• A.You cannot correlate them with a table in the parent statement.
• B.You must enclose them in parentheses.
• C.They can return two columns.
• D.They can return at most one row.
• E.You can use them as a default value for a column.

Comment: *

Name: *

Email: *

Verification: *