Name                     Null?                          Type

---------------------------------------------------------------

ORDER_ID NOT NULL NUMBER (38) 

PRODUCT_ID NOT NULL NUMBER (38) 

QUANTITY NOT NULL NUMBER (38)

Which two queries return rows where QUANTITY is a multiple of ten?

Which two are true about queries using set operators (UNION, UNION ALL, INTERSECT and MINUS)?

Examine the description of the BOOKS table: 

Name Null? Type

--------------------------------------------------------------------------------------------------------------------------------

BOOK_ID NOT NULL NUMBER(4) 

BOOK_TITLE VARCHAR2 (250) 

PRICE NUMBER(5,2) 

PURCHASE_DATE DATE 

AUTHOR_NAME VARCHAR2 (30)

Examine these requirements:

Sort the titles by date of purchase, starting with the most recently purchased book. Which two queries can be used?

CREATE USER sales

IDENTIFIED BY sales_123

DEFAULT TABLESPACE sales_q1

TEMPORARY TABLESPACE temp

QUOTA 5M ON users;