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

Previous-Page 1 2... 153 154 155 156 157 158 159 160 161 Next-Page

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