Online Access Free 1z1-071 Practice Test

Which two statements are true about Data Manipulation Language (DML) statements?

• A.An UPDATE...SET.... statement can modify multiple rows based on only a single condition on a table.
• B.An INSERT INTO...VALUES..... statement can add a single row based on multiple conditions on a table.
• C.A DELETE FROM ..... statement can remove rows based on only a single condition on a table.
• D.An UPDATE...SET... statement can modify multiple rows based on multiple conditions on a table.
• E.A DELETE FROM..... statement can remove multiple rows based on multiple conditions on a table.
• F.AH INSERT INTO. . .VALUES. . statement can add multiple rows per execution to a table.

View the exhibits and examine the structures of the COSTSand PROMOTIONStables.


Evaluate the following SQL statement:

What would be the outcome of the above SQL statement?

• A.It displays prod IDs in the promos with the lowest cost in the same time interval.
• B.It displays prod IDs in the promos with cost less than the highest cost in the same time interval.
• C.It displays prod IDs in the promos with the highest cost in the same time interval.
• D.It displays prod IDs in the promo with the lowest cost.

Examine the structure proposed for the TRANSACTIONS table:

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

• A.The TRANS_DATE column would allow storage of dates only in the dd-mon-yyyy format.
• B.The CUST_STATUS column would allow storage of data up to the maximum VARCHAR2 size of
  4,000 characters.
• C.The CUST_CREDIT_VALUE column would allow storage of positive and negative integers.
• D.The TRANS_VALIDITY column would allow storage of a time interval in days, hours, minutes, and seconds.

Examine the data in the CUSTOMERStable:

You want to list all cities that have more than one customer along with the customer details.
Evaluate the following query:

Which two JOIN options can be used in the blank in the above query to give the correct output?
(Choose two.)

• A.RIGHT OUTER JOIN
• B.JOIN
• C.LEFT OUTER JOIN
• D.NATURAL JOIN
• E.FULL OUTER JOIN

View the Exhibit and examine the structure of ORDERS and ORDER_ITEMS tables.
ORDER__ID is the primary key in the ORDERS table. It is also the foreign key in the ORDER_ITEMS table wherein it is created with the ON DELETE CASCADE option.

Which DELETE statement would execute successfully?

• A.DELETE order_id
  FROM orders
  WHERE order_total < 1000;
• B.DELETE orders
  WHERE order_total < 1000;
• C.DELETE orders o, order_items i
  WHERE o.order id = i.order id;
• D.DELETE
  FROM orders
  WHERE (SELECT order_id
  FROM order_items);