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?
  • 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?
  • 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?
  • 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?