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-001





Question ID 1647

You want to display the details of all employees whose last name is Smith, but you are not sure in which case the last names are stored. Which statement will list all the employees whose last name is Smith?

Option A

A.    SELECT lastname, firstname FROM emp
WHERE UPPER(lastname) = 'smith';
 

Option B

B.    SELECT lastname, firstname FROM emp
WHERE LOWER(lastname) = 'smith';
 

Option C

C.    SELECT lastname, firstname FROM emp
WHERE lastname = UPPER('smith');
 

Option D

D.    SELECT lastname, firstname FROM emp
WHERE lastname = 'smith';
 

Correct Answer B
Explanation


Question ID 1648

The EMPLOYEE table contains these columns:
LAST_NAME VARCHAR2(25) FIRST_NAME VARCHAR2(25) SALARY NUMBER(7,2)
You need to display the names of employees that earn more than the average salary of all employees.
Evaluate this SQL statement: SELECT last_name, first_name FROMemployee
WHEREsalary > AVG(salary);
Which change should you make to achieve the desired results?
 

Option A

A.    Move the function to the SELECT clause and add a GROUP BY clause and a HAVING clause.
 

Option B

B.    Move the function to the SELECT clause and add a GROUP BY clause.
 

Option C

C.    Use a subquery in the WHERE clause to compare the average salary value.

 

Option D

D.    Change the function in the WHERE clause.

Correct Answer C
Explanation

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