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 8110

Your company wants to get each employee a $100 salary increment. You need to evaluate the results, from the EMP table prior to actual modification. If you do not want to store the result in the database which statement is valid? 

Option A

You need to add a column to the EMP table.

Option B

You need to give the arithmetic expression that involves the salary increment in the set clause of the update statement.

Option C

You need to give the arithmetic expression that involves the salary increment in the select clause of the select statement.

Option D

You need to give the arithmetic expression that involves the salary increment in the update clause of the select statement.

Option E

You need to give the arithmetic expression that involves the salary increment in the display clause of the select statement.

Correct Answer C
Explanation Explanation/Reference: Explanation: Answer C is correct because using of the SELECT clause of the SELECT statement WILL NOT change data and will not store the result of operation in the database. Incorrect Answers: A: To evaluate results you DON'T NEED to add a column to the EMP table, this can be done with SELECT statement only, without changing structure of table. B: Usage of the SET clause of the UPDATE statement will cause data changes in the database. So this answer is eliminated. D: The UPDATE clause does not exist in the SELECT statement. E: The DISPLAY clause does not exist in the SELECT statement. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 6-10 Chapter 1: Selecting Data from Oracle


Question ID 8111

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' OR UPPER (last_name) Like '%K' ; 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

The statement will retrieve different data from the database.

Option B

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

Option C

Statement1 will execute but statement2 will not.

Option D

Statement2 will execute but statement1 will not.

Correct Answer A
Explanation Explanation/Reference: Explanation: Answer A is correct because the statements will retrieve different data from the database. First statement will show concatenated first and last names of EMPLOYEE TABLE and also length of concatenated string for all rows in the table which have last_name with 'j', 'J', 'k' or 'K' on the end. Second statement will show concatenated first and last names with the initial letter for each first and last name converted to a capital letter and also summary length of first and last name for all rows which started from 'j', 'J', 'k', 'K', 'l' or 'L'. Incorrect Answers: B: Each statement will show different data from the database. C: Both statements will execute successfully. D: Both statements will execute successfully. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 6-10 Chapter 1: Selecting Data from Oracle

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