Which three statements are true about indexes and their administration in an Oracle database?

CREATE SEQUENCE ord_seq

            INCREMENT BY 1

            START WITH 1

            MAXVALUE 100000

            CYCLE

             CACHE 5000;

CREATE TABLE ord_items(

          ord_no     NUMBER(4)  DEFAULT ord_seq.NEXTVAL NOT NULL;

           item_no   NUMBER(3),

           qty           NUMBER(3),

           expiry_date DATE,

CONSTRAINT it_pk PRIMARY KEY(ord no,item_no),

CONSTRAINT ord_fk FOREIGN KEY (ord no) REFERENCES orders (ord no));

Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence? (Choose two.)

Which two statements are true about dropping views?

Which two tasks require subqueries? (Choose two.)

Which two statements are true about expressions using PROMO BEGIN DATE contained in a query?

Examine these SOL statements:

Statement 1:

SELECT MAX(unit price * quantity) "Maximum order"

EROM order_items;

Statement 2.

SELECT MAX(unit_price*quantity) "Maximam order"

FROM order_items 

Group BY order_id;

Which two statements are true?

NLS_DATE_FORMAT is set to DD-MON-RR.

Which two are true about data type conversions involving these columns in query expressions? (Choose two.)