Examine the commands used to create DEPARTMENT_DETAILS and COURSE_DETAILS tables:

You want to generate a list of all department IDs along with any course IDs that may have been assigned to them.
Which SQL statement must you use?

• A.SELECT d.department_id, c.course_id FROM department_details d LEFT OUTER JOIN course_details c ON (d.department_id=c.department_id);
• B.SELECT d.department_id, c.course_id FROM department_details d RIGHT OUTER JOIN course_details c ON (d.department_id=c.department_id);
• C.SELECT d.department_id, c.course_id FROM course_details c LEFT OUTER JOIN department_details d ON (c.department_id=d.department_id);
• D.SELECT d.department_id, c.course_id FROM department_details d RIGHT OUTER JOIN course_details c ON (c.department_id=d.department_id);

Comment: *

Name: *

Email: *

Verification: *

View the exhibit and examine the structure of the STOREStable.
STORES table
Name Null? Type
----------------- ----- -------------
STORE_ID NUMBER
NAME VARCHAR2(100)
ADDRESS VARCHAR2(200)
CITY VARCHAR2(100)
COUNTRY VARCHAR2(100)
START_DATE DATE
END_DATE DATE
PROPERTY_PRICE NUMBER
You want to display the NAME of the store along with the ADDRESS, START_DATE, PROPERTY_PRICE, and the projected property price, which is 115% of property price.
The stores displayed must have START_DATEin the range of 36 months starting from 01-Jan-2000 and above.
Which SQL statement would get the desired output?

• A.SELECT name, concat (address| | ','| |city| |', ', country) AS full_address, start_date,
  property_price, property_price*115/100
  FROM stores
  WHERE MONTHS_BETWEEN (start_date, '01-JAN-2000') <=36;
• B.SELECT name, address||','||city||','||country AS full_address,
  start_date,
  property_price, property_price*115/100
  FROM stores
  WHERE MONTHS_BETWEEN (start_date, TO_DATE('01-JAN-2000','DD-MON-RRRR'))
  <=36;
• C.SELECT name, concat (address||','| |city| |', ', country) AS full_address, start_date,
  property_price, property_price*115/100
  FROM stores
  WHERE MONTHS_BETWEEN (start_date, TO_DATE('01-JAN-2000','DD-MON-RRRR'))
  <=36;
• D.SELECT name, concat (address| | ','| |city| |', ', country) AS full_address, start_date,
  property_price, property_price*115/100
  FROM stores
  WHERE TO_NUMBER(start_date-TO_DATE('01-JAN-2000','DD-MON-RRRR')) <=36;

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the CUSTOMERS table:

Which three statements will do an implicit conversion?

• A.SELECT. FROM customers WHERE insert_ date = DATE *2019-01-01';
• B.SELECT. FRON customers WE TO DATE (Insert _ date) = DATE '2019-01-01';
• C.SELECT FROM customers WHERE insert date = '01-JAN-19';
• D.SELECT * FROM customers WHERE customer_ id = 0001;
• E.SELECT * FROM customers WHERE customer id = '0001';
• F.SELECT * FROM customers WHERE TO_ CHAR (customer_ id) = '0001';

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about inner and outer joins? (Choose three.)

• A.A full outer join must use Oracle syntax
• B.An inner join returns matched rows
• C.A left or right outer join returns only unmatched rows
• D.A full outer join returns matched and unmatched rows
• E.Outer joins can only be used between two per query
• F.Outer joins can be used when there are multiple join conditions on two tables

Comment: *

Name: *

Email: *

Verification: *

Examine the structure of the BOOKS_TRANSACTIONStable:

You want to display the member IDs, due date, and late fee as $2 for all transactions.
Which SQL statement must you execute?

• A.SELECT member_id AS "MEMBER ID", due_date AS "DUE DATE", '$2' AS "LATE FEE" FROM BOOKS_TRANSACTIONS;
• B.SELECT member_id AS MEMBER_ID, due_date AS DUE_DATE, $2 AS LATE_FEE FROM BOOKS_TRANSACTIONS;
• C.SELECT member_id AS "MEMBER ID", due_date AS "DUE DATE", $2 AS "LATE FEE" FROM BOOKS_TRANSACTIONS;
• D.SELECT member_id 'MEMBER ID', due_date 'DUE DATE', '$2 AS LATE FEE' FROM BOOKS_TRANSACTIONS;

Comment: *

Name: *

Email: *

Verification: *