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?

• 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 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;
• C.SELECT e.last_name, m.manager_id
  FROM employees e LEFT OUTER JOIN employees m
  on (e.employee_id = m.manager_id)
  WHERE e.employee_id = 123;
• D.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;

Comment: *

Name: *

Email: *

Verification: *

Examine the data in the COLORS table:

Examine the data in the BRICKS table:

Which two queries return all the rows from COLORS?

• A.SELECT
  EROM colors C
  LEFT JOIN bricks b
  USING (rgb _ hex_ value) ;
• B.SELECT.
  FROM bricks b
  RIGHT JOIN colors c
  ON b. color _rgb_ hex_ value = c. rgb hex_ value;
• C.SELECT
  FROM bricks b
  FULL JOIN colors C
  ON b. color rgb _ hex_ value = c. rgb _hex_ value;
• D.SELECT
  EROM colors C
  LEET JOIN bricks b
  ON b. color_ rgb_ hex value = c. rgb. hex.
  value
  WHERE b. brick_ id > 0;
• E.SELECT *
  EROM bricks | b
  JOIN colors C
  ON b. color_ rgb_ hex_ value =c. rgb _hex value;

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true regarding the data types? (Choose three.)

• A.A TIMESTAMPdata type column stores only time values with fractional seconds.
• B.The BLOBdata type column is used to store binary data in an operating system file.
• C.The value for a CHARdata type column is blank-padded to the maximum defined column width.
• D.The minimum column width that can be specified for a VARCHAR2data type column is one.
• E.Only one LONGcolumn can be used per table.

Comment: *

Name: *

Email: *

Verification: *

View the exhibit and examine the description of the PRODUCT_INFORMATIONtable.

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

• A.SELECT COUNT (list_price)
  FROM product_information
  WHERE list_price i= NULL
• B.SELECT COUNT (DISTINCT list_price)
  FROM product_information
  WHERE list_price is NULL
• C.SELECT COUNT (list_price)
  FROM product_information
  WHERE list_price is NULL
• D.SELECT COUNT (NVL(list_price, 0))
  FROM product_information
  WHERE list_price is NULL

Comment: *

Name: *

Email: *

Verification: *

Examine the structure proposed for the TRANSACTIONS table:

Which two statements are true regarding the creation and storage of data in the above table structure? (Choose two.)

• A.The CUST_STATUS column would store exactly one character.
• B.The TRANS_DATE column would be able to store day, month, century, year, hour, minutes, seconds, and fractions of seconds.
• C.The CUST_STATUS column would give an error.
• D.The CUST_CREDIT_LIMIT column would be able to store decimal values.
• E.The TRANS_VALIDITY column would give an error.
• F.The TRANS_VALIDITY column would have a maximum size of one character.

Comment: *

Name: *

Email: *

Verification: *