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 1485

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 LOWER(lastname) = 'smith';
 

Option B

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

 

Option C

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

Option D

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

Correct Answer A
Explanation


Question ID 1486

You are updating the employee table. Jane has been granted the same privileges as you on the employee table. You ask Jane to log on to the database to check your work before you issue a
COMMIT command. What can Jane do to the employee table?
 

Option A

A.    Jane can access the table, but she cannot see your changes and cannot make the same changes.
 

Option B

B.    Jane can access the table and verify your changes.
 

Option C

C.    Jane cannot access the table.

 

Option D

D.    Jane can access the table, but she cannot see your changes. She can make the changes for you.

Correct Answer A
Explanation

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