Examine the structure of the BOOKS_TRANSACTIONS table:
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: *

View the exhibit and examine the structure of ORDERS and CUSTOMERS tables.

Which INSERT statement should be used to add a row into the ORDERS table for the customer whose CUST_LAST_NAME is Roberts and CREDIT_LIMIT is 600? Assume there exists only one row with CUST_LAST_NAME as Roberts and CREDIT_LIMIT as 600.

• A.INSERT INTO orders (order_id, order_date, order_mode,(SELECT customer_idFROM customersWHERE cust_last_name='Roberts' AND credit_limit=600), order_total)VALUES (1,'10-mar-2007', 'direct', &&customer_id, 1000);
• B.INSERT INTO ordersVALUES (1,'10-mar-2007', 'direct',(SELECT customer_idFROM customersWHERE cust_last_name='Roberts' AND credit_limit=600), 1000);
• C.INSERT INTO(SELECT o.order_id, o.order_date, o.order_mode, c.customer_id, o.order_totalFROM orders o, customers cWHERE o.customer_id = c.customer_id AND c.cust_last_name='Roberts' AND c.credit_limit=600)VALUES (1,'10-mar-2007', 'direct', (SELECT customer_idFROM customersWHERE cust_last_name='Roberts' AND credit_limit=600), 1000);
• D.INSERT INTO orders (order_id, order_date, order_mode,(SELECT customer_idFROM customersWHERE cust_last_name='Roberts' AND credit_limit=600), order_total)VALUES (1,'10-mar-2007', 'direct', &customer_id, 1000);

Comment: *

Name: *

Email: *

Verification: *

Which two queries execute successfully?

• A.SELECT SYSTIMESTAMP + INTERVAL '1' DAY FROM DUAL;
• B.SELECT SYSDATE "INTERRVAL '1' DAY FROM DUAL;
• C.select INTERVAL '1' DAY +INTERVAL '1' MONTH FROM DUAL;
• D.SELECT INTERVAL '1' DAY - INTERVAL '1' MINUTE FROM DUAL;
• E.SELECT INTERVAL '1' DAY - SYSDATE FROM DUAL;

Comment: *

Name: *

Email: *

Verification: *

The following are the steps for a correlated subquery, listed in random order:
1. The WHEREclause of the outer query is evaluated.
2. The candidate row is fetched from the table specified in the outer query.
3. This is repeated for the subsequent rows of the table, till all the rows are processed.
4. Rows are returned by the inner query, after being evaluated with the value from the candidate row in the outer query.
Which is the correct sequence in which the Oracle server evaluates a correlated subquery?

• A.2, 1, 4, 3
• B.4, 1, 2, 3
• C.4, 2, 1, 3
• D.2, 4, 1, 3

Comment: *

Name: *

Email: *

Verification: *

Examine this query:
SELECT TRUNC(ROUND(156.00, -2), -1) FROM DUAL;
What is the result?

• A.16
• B.200
• C.100
• D.160
• E.150

Comment: *

Name: *

Email: *

Verification: *