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 8055

Evaluate the SQL statement: SELECT LPAD (salary,10,*) FROM EMP WHERE EMP _ ID = 1001; If the employee with the EMP_ID 1001 has a salary of 17000, what is displayed?

Option A

17000.00

Option B

17000*****

Option C

****170.00

Option D

**17000.00

Option E

an error statement

Correct Answer D
Explanation


Question ID 8056

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

Option A

INSERT INTO employees VALUES (NULL, 'JOHN','Smith');

Option B

INSERT INTO employees( first_name, last_name) VALUES ('JOHN','Smith');

Option C

INSERT INTO employees VALUES ('1000','JOHN','NULL');

Option D

INSERT INTO employees(first_name,last_name, employee_id) VALUES ('1000, 'john','Smith');

Option E

INSERT INTO employees (employee_id) VALUES (1000);

Option F

INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'john',");

Correct Answer CEF
Explanation Explanation/Reference: Explanation: Since EMPLOYEE_ID column is used as primary key, it cannot be NULL, so only INSERT statements in C, E and F are correct. You can insert the row with NULL LAST_NAME as in answer C, or only the row with EMPLOYEE_ID as in answer E, or the row with empty LAST_NAME column. Incorrect Answers A: This answer is incorrect because a primary key cannot be NULL. B: INSERT statement does not contain primary key value at all, so this answer needs to be eliminated as correct one. D: This statement shows incorrect order of columns of row which needs to be inserted into the table. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 260-267 Chapter 6: Manipulating Oracle Data

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