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 4904

Examine the description of the EMPLOYEES table:
EMP_ID NUMBER(4) NOT NULL
LAST_NAME VARCHAR2(30) NOT NULL
FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2)
Which statement produces the number of different departments that have employees with last name Smith?
 

Option A

A.    SELECT COUNT(*) FROM employees WHERE last_name='Smith';
 

Option B

B.    SELECT COUNT (dept_id) FROM employees WHERE last_name='Smith';
 

Option C

C.    SELECT DISTINCT(COUNT(dept_id)) FROM employees WHERE last_name='Smith';
 

Option D

D.    SELECT COUNT(DISTINCT dept_id) FROM employees WHERE last_name='Smith';
 

Option E

E.    SELECT UNIQUE(dept_id) FROM employees WHERE last_name='Smith';
 

Correct Answer D
Explanation


Question ID 4905

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

Option A

A.    the use of rowid
 

Option B

B.    a GROUP BY clause

 

Option C

C.    an ORDER BY clause
 

Option D

D.    only an inline view
 

Option E

E.    an inline view and an outer query

Correct Answer C,E
Explanation

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