READ Free Dumps For Oracle- 1z0-007

Question ID 7903	Examine the data from the EMP table: EMP_ID DEPT_ID COMMISSION 1 10 500 2 20 1000 3 10 4 10 600 5 30 800 6 30 200 7 10 8 20 300 The COMMISSION column shows the monthly commission earned by the employee. Which three tasks would require subqueries or joins in order to perform in a single step? (Choose three)
Option A	Examine the data from the EMP table: EMP_ID DEPT_ID COMMISSION 1 10 500 2 20 1000 3 10 4 10 600 5 30 800 6 30 200 7 10 8 20 300 The COMMISSION column shows the monthly commission earned by the employee. Which three tasks would require subqueries or joins in order to perform in a single step? (Choose three)
Option B	Increasing the commission of employee 3 by the average commission earned in department 20.
Option C	Finding the number of employees who do NOT earn commission and are working for department 20.
Option D	Inserting into the table a new employee 10 who works for department 20 and earns a commission that is equal to the commission earned by employee 3.
Option E	Creating a table called COMMISSION that has the same structure and data as the columns EMP_ID and COMMISSIONS of the EMP table.
Option F	Decreasing the commission by 150 for the employees who are working in department 30 and earning a commission of more then 800.
Correct Answer	BDE

Explanation Explanation/Reference: Explanation: Increasing the commission of employee 3 by the average commission earned in department 20 will require subqueries or joins in order to perform in a single step. Inserting into the table a new employee 10 who works for department 20 and earns a commission that is equal to the commission earned by employee 3 is correct answer also. To create a table that has the same structure as subset of columns from another table it's required to use a subquery in order to perform in a single step. Incorrect Answers A: This query can be done without using sub-queries or joins in order to perform in a single step. C: It is not required to use sub-queries or joins to create SQL statement for that query. F: This query can be done without using sub-queries or joins in order to perform in a single step: only two conditions in the WHERE clause should be specified.

Question ID 7904	From SQL*Plus, you issue this SELECT statement: SELECT* FROM order; You use this statement to retrieve data from a data table for __________. (Choose all that apply)
Option A	Updating
Option B	Viewing
Option C	Deleting
Option D	Inserting
Option E	Truncating
Correct Answer	BD

Explanation Explanation/Reference: Explanation: You can use SELECT statement to display and to insert data into different table. Incorrect Answers A: You cannot update data with SELECT statement. Update command is used for this purpose. C: You cannot delete data with SELECT statement. Delete command is used for this purpose. E: You cannot truncate data with SELECT statement. Truncate command is used for this purpose. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 20-21 Chapter 1: Overview of Oracle Databases

Previous-Page 1 2. . . 79 80 81 82 83 84 85. . . 160 161 Next-Page

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