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- 1z0-007





Question ID 7975

Top N analysis requires _____ and _____. (Choose two.)

Option A

the use of rowid

Option B

a GROUP BY clause

Option C

an ORDER BY clause

Option D

only an inline view

Option E

an inline view and an outer query

Correct Answer CE
Explanation Explanation/Reference: Explanation : The correct statement for Top-N Analysis SELECT [coloumn_list], ROWNUM FROM (SELECT [coloumn_list] FROM table ORDER BY Top-N_coloumn) WHERE ROWNUM <=N; Incorrect answer : A ROWID is not require B GROUP BY clause is not require D Must have inline view and outer query. Refer : Introduction to Oracle9i : SQL, Oracle University Study Guide, 11-23


Question ID 7976

Which statement adds a constraint that ensures the CUSTOMER_NAME column of the CUSTOMERS table holds a value?

Option A

ALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name IS NOT NULL;

Option B

ALTER TABLE customers MODIFY CONSTRAINT cust_name_nn CHECK customer_name IS NOT NULL;

Option C

ALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn NOT NULL;

Option D

ALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn IS NOT NULL; 

Option E

 ALTER TABLE customers MODIFY name CONSTRAINT cust_name_nn NOT NULL;

Option F

ALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name NOT NULL;

Correct Answer C
Explanation

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