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 1512

The EMPLOYEE table contains these columns:
FIRST_NAME VARCHAR2(25)
LAST_NAME VARCHAR2(25)
Evaluate these two SQL statements:
1.    SELECT CONCAT(first_name, last_name), LENGTH(CONCAT(first_name, last_name)) FROM employee
WHERE UPPER(last_name) LIKE '%J' ORUPPER(last_name) LIKE '%K'
ORUPPER(last_name) LIKE '%L';
2.    SELECT INITCAP(first_name) || INITCAP(last_name), LENGTH(last_name) + LENGTH(first_name)
FROM employee
WHERE INITCAP(SUBSTR(last_name, 1, 1)) IN ('J', 'K', 'L');
How will the results differ?
 

Option A

A.    The statements will retrieve different data from the database.

 

Option B

B.    Statement 1 will execute, but statement 2 will not.
 

Option C

C.    Statement 2 will execute, but statement 1 will not.
 

Option D

D.    The statements will retrieve the same data from the database, but will display it differently.

Correct Answer A
Explanation


Question ID 1513

Which statement is true when writing a cursor FOR loop?

Option A

A.    You do not explicitly open, fetch or close the cursor within a cursor FOR loop .
 

Option B

B.    You must explicitly close the cursor prior to the end of the program.
 

Option C

C.    You must explicitly fetch the rows within a cursor FOR loop.

 

Option D

D.    You must explicitly declare the record variable that holds the row returned from the cursor.

Correct Answer A
Explanation

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