1z1-071 Exam Question 11

Which three statements are true regarding the data types?
  • 1z1-071 Exam Question 12

    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?
  • 1z1-071 Exam Question 13

    Examine the description of the BOOKS_TRANSACTIONS table:

    Which two WHERE conditions give the same result?
  • 1z1-071 Exam Question 14

    Examine the command to create the BOOKS table.

    The BOOK_ID value 101 does not exist in the table.
    Examine the SQL statement:

    Which statement is true?
  • 1z1-071 Exam Question 15

    Examine the description of the BOOKS table:

    The table has 100 rows.
    Examine this sequence of statements issued in a new session;
    INSERT INTO BOOKS VALUES ('ADV112' , 'Adventures of Tom Sawyer', NULL, NULL);
    SAVEPOINT a;
    DELETE from books;
    ROLLBACK TO SAVEPOINT a;
    ROLLBACK;
    Which two statements are true?