1z0-071 Exam Question 316
Examine the structure of the SALES table. (Choose two.)

Examine this statement:
SQL > CREATE TABLE sales1 (prod_id, cust_id, quantity_sold, price)
AS
SELECT product_id, customer_id, quantity_sold, price
FROM sales
WHERE 1 = 2;
Which two statements are true about the SALES1 table?

Examine this statement:
SQL > CREATE TABLE sales1 (prod_id, cust_id, quantity_sold, price)
AS
SELECT product_id, customer_id, quantity_sold, price
FROM sales
WHERE 1 = 2;
Which two statements are true about the SALES1 table?
1z0-071 Exam Question 317
Which three statements are true about GLOBAL TEMPORARY TABLES?
1z0-071 Exam Question 318
You issued this command: DROP TABLE hr. employees;
Which three statements are true?
Which three statements are true?
1z0-071 Exam Question 319
SCOTT is a user in the database.
Evaluate the commands issued by the DBA:

Which statement is true regarding the execution of the above commands?
Evaluate the commands issued by the DBA:

Which statement is true regarding the execution of the above commands?
1z0-071 Exam Question 320
The first DROPoperation is performed on PRODUCTStable using the following command:
DROP TABLE products PURGE;
Then you performed the FLASHBACKoperation by using the following command:
FLASHBACK TABLE products TO BEFORE DROP;
Which statement describes the outcome of the FLASHBACKcommand?
DROP TABLE products PURGE;
Then you performed the FLASHBACKoperation by using the following command:
FLASHBACK TABLE products TO BEFORE DROP;
Which statement describes the outcome of the FLASHBACKcommand?
