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 4900

The EMPLOYEES table contains these columns:
EMPLOYEE_ID NUMBER(4) ENAME VARCHAR2 (25) JOB_ID VARCHAR2(10)
Which SQL statement will return the ENAME, length of the ENAME, and the numeric position of the letter "a" in the ENAME column, for those employees whose ENAME ends with a the letter "n"?

 

Option A

A.    SELECT ENAME, LENGTH(ENAME), INSTR(ENAME, 'a') FROM EMPLOYEES WHERE SUBSTR(ENAME, -1, 1) = 'n';
 

Option B

B.    SELECT ENAME, LENGTH(ENAME), INSTR(ENAME, ,-1,1) FROM EMPLOYEES WHERE
SUBSTR(ENAME, -1, 1) = 'n';
 

Option C

C.    SELECT ENAME, LENGTH(ENAME), SUBSTR(ENAME, -1,1) FROM EMPLOYEES WHERE INSTR(ENAME, 1, 1) = 'n';
 

Option D

D.    SELECT ENAME, LENGTH(ENAME), SUBSTR(ENAME, -1,1) FROM EMPLOYEES WHERE INSTR(ENAME, -1, 1) = 'n';

Correct Answer A
Explanation


Question ID 4901

Which four are valid Oracle constraint types? (Choose four.)
 

Option A

A.    CASCADE
 

Option B

B.    UNIQUE
 

Option C

C.    NONUNIQUE
 

Option D

D.    CHECK
 

Option E

E.    PRIMARY KEY
 

Option F

F.     NOT NULL
 

Correct Answer B,D,E,F
Explanation

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