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

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?

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?

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?