Which three are true about multitable INSERT statements?

• A.They can be performed on relational tables.
• B.They can be performed on remote tables.
• C.They can be performed only by using a subquery.
• D.They can be performed on external tables using SQL* Loader.
• E.They can be performed on views.
• F.They can insert each computed row into more than one table.

Comment: *

Name: *

Email: *

Verification: *

Evaluate the following ALTER TABLE statement:
ALTER TABLE orders SET UNUSED order_date; Which statement is true?

• A.The ORDER_DATE column should be empty for the ALTER TABLE command to execute successfully.
• B.The DESCRIBE command would still display the ORDER_DATE column.
• C.ROLLBACK can be used to get back the ORDER_DATE column in the ORDERS table.
• D.After executing the ALTER TABLE command, you can add a new column called ORDER_DATE to the ORDERS table.

Comment: *

Name: *

Email: *

Verification: *

Examine the structure of the INVOICE table.
NameNull?Type
--------------------------------------------------
INV_NONOT NULLNUMBER(3)
INV_DATEDATE
INV_AMTNUMBER(10,2)
Which two SQL statements would execute successfully?

• A.SELECT inv_no, NVL2(inv_date, sysdate-inv_date, sysdate)FROM invoice;
• B.SELECT inv_no, NVL2(inv_amt, inv_amt*.25, 'Not Available')FROM invoice;
• C.SELECT inv_no, NVL2(inv_amt, inv_date, 'Not Available')FROM invoice;
• D.SELECT inv_no, NVL2(inv_date, 'Pending', 'Incomplete')FROM invoice;

Comment: *

Name: *

Email: *

Verification: *

You have the privileges to create any type of synonym.
Which statement will create a synonym called EMPfor the HCM.EMPLOYEE_RECORDS table that is accessible to all users?

• A.CREATE PUBLIC SYNONIM emp FOR hcm.employee_records;
• B.CREATE GLOBAL SYNONIM emp FOR hcm.employee_records;
• C.CREATE SYNONIM emp FOR hcm.employee_records;
• D.CREATE SYNONIM PUBLIC.emp FOR hcm.employee_records;
• E.CREATE SYNONIM SYS.emp FOR hcm.employee_records;

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of the ORDER_ITEMS table.

Examine the following SQL statement:
SELECT order_id, product_id, unit_price
FROM order_items
WHERE unit_price =
(SELECT MAX(unit_price)
FROM order_items
GROUP BY order_id);
You want to display the PRODUCT_ID of the product that has the highest UNIT_PRICE per ORDER_ID. What correction should be made in the above SQL statement to achieve this?

• A.Replace = with the IN operator
• B.Replace = with the >ANY operator
• C.Replace = with the >ALL operator
• D.Remove the GROUP BY clause from the subquery and place it in the main query

Comment: *

Name: *

Email: *

Verification: *