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 7929

Examine the data from the ORDERS and CUSTOMERS tables. ORDERS ORD_ID ORD_DATE CUST_ID 12-JAN- 100 15 10000 09-MAR- 101 40 8000 09-MAR- 102 35 12500 15-MAR- 103 15 12000 25-JUN-104 15 6000 18-JUL- 105 20 5000 106 18-JUL- 35 7000 21-JUL- 107 20 6500 04-AUG- 109 10 8000 CUSTOMERS CUST_ID CUST_NAME CITY 10 Smith Los Angeles 15 Bob San Francisco 20 Martin Chicago 25 Mary New York 30 Rina Chicago 35 Smith New York40 Lind New York Evaluate the SQL statement: SELECT * FROM orders WHERE cust_id = (SELECT cust_id FROM customers WHERE cust_name = 'Smith'); What is the result when the query is executed?

Option A

ORD_ID ORD_DATE CUST_ID ORD_TOTAL 09-MAR- 102 35 12500 18-JUL- 106 35 7000 04-AUG- 108 10 8000

Option B

ORD_ID ORD_DATE CUST_ID ORD_TOTAL 09-MAR- 102 35 12500 18-JUL- 106 35 7000

Option C

ORD_ID ORD_DATE CUST_ID ORD_TOTAL 04-AUG- 108 10 8000

Option D

The query fails because the subquery returns more than one row.

Option E

The query fails because the outer query and the inner query are using different tables.

Correct Answer D
Explanation Explanation/Reference: Explanation: The query fails because the sub-query returns more than one row: it is possible situation when there are some customers with name Smith. Incorrect Answers A. The query fails because the sub-query returns more than one row B: The query fails because the sub-query returns more than one row C: The query fails because the sub-query returns more than one row E: The query fails because the sub-query returns more than one row, not because the outer query and the inner query are using different tables. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 150-165 Chapter 4: Subqueries


Question ID 7930

You need to display the last names of those employees who have the letter "A" as the second character in their names. Which SQL statement displays the required results?

Option A

SELECT last_name FROM EMP WHERE last_ name LIKE '_A%';

Option B

SELECT last_name FROM EMP WHERE last name ='*A%'

Option C

SELECT last_name FROM EMP WHERE last name ='_A%';

Option D

SELECT last_name FROM EMP WHERE last name LIKE '*A%'

Correct Answer A
Explanation Explanation/Reference: Explanation: Statement in this answer will show correct results because usage of operator LIKE and format mask '_A%' extract the last names of those employees who have the letter "A" as the second character in their names. Symbol '_' in format mask substitute exactly one symbol and cannot be NULL. Incorrect Answers B: This statement will return only names starting from symbol '*'. It cannot be used as substitution symbol. C: Usage of equity operator here is not appropriate in this case: query will look exact for first symbol '_', it will not be considered as substitution symbol. D: This statement will return only names starting from symbol '*'. It cannot be used as substitution symbol. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 61-67 Chapter 2: Limiting, Sorting, and Manipulating Return Data

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