READ Free Dumps For Oracle- 1z0-007

Question ID 7991	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	SER_NO
Option B	ORDER_ID
Option C	STATUS
Option D	PROD_ID
Option E	ORD_TOTAL
Option F	composite index on ORDER_ID and ORDER_DATE
Correct Answer	AF

Explanation Explanation/Reference: Explanation : Index exist for UNIQUE and PRIMARY KEY constraints Incorrect answer : B ORDER_ID is neither UNIQUE nor PRIMARY KEY C STATUS is neither UNIQUE nor PRIMARY KEY D PROD_ID is neither UNIQUE nor PRIMARY KEY E ORD_TOTAL is neither UNIQUE nor PRIMARY KEY Refer : Introduction to Oracle9i : SQL, Oracle University Study Guide, 10-15

Question ID 7992	What is true of using group functions on columns that contain NULL values?
Option A	Group functions on columns ignore NULL values.
Option B	Group functions on columns returning dates include NULL values.
Option C	Group functions on columns returning numbers include NULL values.
Option D	Group functions on columns cannot be accurately used on columns that contain NULL values.
Option E	Group functions on columns include NULL values in calculations if you use the keyword INC_NULLS.
Correct Answer	A

Explanation Explanation/Reference: Explanation : group functions on column ignore NULL values Incorrect answer : B group functions on column ignore NULL values C group functions on column ignore NULL values D NVL function can be use for column with NULL values E no such INC_NULLS keyword Refer : Introduction to Oracle9i : SQL, Oracle University Study Guide, 5-12

Previous-Page 1 2. . . 123 124 125 126 127 128 129. . . 160 161 Next-Page

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