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





Question ID 1660

Examine the structure of the EMPLOYEES table:
EMPLOYEE_ ID NUMBER Primary Key
FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25)
Which three statements insert a row into the table? (Choose three.)
 

Option A

A.    INSERT INTO employees( first_name, last_name) VALUES( 'John', 'Smith');
 

Option B

B.    INSERT INTO employees VALUES ( NULL, 'John', 'Smith');
 

Option C

C.    INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'John', ' ');
 

Option D

D.    INSERT INTO employees (employee_id) VALUES (1000);
 

Option E

E.    INSERT INTO employees (first_name, last_name, employee_id) VALUES ( 1000, 'John', 'Smith');
 

Option F

F.    INSERT INTO employees VALUES ( '1000', 'John', NULL);
 

Correct Answer C,D,F
Explanation


Question ID 1661

Which SELECT statement should you use to extract the year from the system date and display it in the format "1998"?

Option A

A.    SELECT TO_CHAR(SUBSTR(SYSDATE, 8,2),'yyyy') FROM dual;
 

Option B

B.    SELECT DECODE(SUBSTR(SYSDATE, 8), 'year') FROM dual;
 

Option C

C.    SELECT TO_DATE(SYSDATE,'yyyy') FROM dual;
 

Option D

D.    SELECT TO_CHAR(SYSDATE,'yyyy') FROM dual;
 

Option E

E. SELECT DECODE(SUBSTR(SYSDATE, 8), 'YYYY') FROM dual;
 

Correct Answer D
Explanation

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