AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Oracle- 1z1-051





Question ID 4918

Which object privileges can be granted on a view?
 

Option A

A.    none
 

Option B

B.    DELETE, INSERT,SELECT
 

Option C

C.    ALTER, DELETE, INSERT, SELECT
 

Option D

D.    DELETE, INSERT, SELECT, UPDATE
 

Correct Answer D
Explanation


Question ID 4919

Examine the SQL statement that creates ORDERS table:
CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE
DATE NOT NULL, STATUS VARCHAR2(10) CHECK (status IN ('CREDIT', 'CASH')), PROD_ID NUMBER REFERENCES PRODUCTS(PRODUCT_ID), ORD_TOTAL NUMBER, PRIMARY KEY (order_id, order_date));
For which columns would an index be automatically created when you execute the above SQL statement? (Choose two.)
 

Option A

A.    SER_NO
 

Option B

B.    ORDER_ID
 

Option C

C.    STATUS
 

Option D

D.    PROD_ID
 

Option E

E.    ORD_TOTAL
 

Option F

F.    composite index on ORDER_ID and ORDER_DATE
 

Correct Answer A,F
Explanation

Send email to admin@getfreedumps for new dumps request!!!