Examine the description of the transactions table:
Which two SQL statements execute successfully?

• A.SELECT customer_id AS "CUSTOMER-ID", transaction_date AS "DATE", amount+100 DUES FROM transactions;
• B.SELECT customer_id CUSTID, transaction_date TRANS_DATE,amount+100 DUES FROM transactions;
• C.SELECT customer_id AS "CUSTOMER-ID", transaction_date AS DATE, amount+100 "DUES" from transactions;
• D.SELECT customer_id AS 'CUSTOMER-ID',transaction_date AS DATE, amount+100 'DUES' from transactions;
• E.SELECT customer id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount+100 "DUES AMOUNT" FROM transactions;

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of ORDER_ITEMS and ORDERS tables.

You need to remove from the ORDER_ITEMS table those rows that have an order status of 0 or 1 in the ORDERS table.
Which two DELETE statements are valid (Choose two.)

• A.DELETEFROM order_itemsWHERE order_id IN (SELECT order_idFROM ordersWHERE orders_status in (0,1));
• B.DELETE *FROM order_itemsWHERE order_id IN (SELECT order_id)FROM ordersWHERE order_status IN (0,1));
• C.DELETEFROM (SELECT * FROM order_items I,orders oWHERE i.order_id = o.order_id AND order_status IN (0,1));
• D.DELETE FROM order_items iWHERE order_id = (SELECT order_id FROM orders oWHERE i.order_id = o.order_id AND order_status IN (0,1));

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?
SELECT COUNT (DISTINCT list_price)

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

Comment: *

Name: *

Email: *

Verification: *

Examine the structure of the EMPLOYEES table. (Choose two.)

You must display the maximum and minimum salaries of employees hired 1 year ago.
Which two statements would provide the correct output?

• A.SELECT MIN(Salary), MAX(salary)FROM (SELECT salary FROM employeesWHERE hire_date < SYSDATE-365);
• B.SELECT minsal, maxsalFROM (SELECT MIN(salary) minsal, MAX(salary) maxsal FROM employeesWHERE hire_date < SYSDATE-365GROUP BY MIN(salary), MAX(salary);
• C.SELECT MIN(Salary) minsal, MAX(salary) maxsalFROM employeesWHERE hire_date < SYSDATE-365GROUP BY MIN(salary), MAX(salary);
• D.SELECT minsal, maxsalFROM (SELECT MIN(salary) minsal, MAX(salary) maxsal FROM employeesWHERE hire_date < SYSDATE-365)GROUP BY maxsal, minsal;

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about views in an Oracle Database? (Choose three.)

• A.Views have no segment.
• B.A view can be created that refers to a non-existent table in its defining query.
• C.A SELECT statement cannot contain a WHERE clause when querying a view containing a WHEREclause in its defining query.
• D.Views have no object number.
• E.Views can join tables only if they belong to the same schema.
• F.Rows inserted into a table using a view are retained in the table if the view is dropped.

Comment: *

Name: *

Email: *

Verification: *