Topic: Oracle Certified Professional Exams (OCP & OCA) >> Which three tasks would require subqueries or joins in order to perform in a single step? (Choose three)
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: Which three tasks would require subqueries or joins in order to perform in a single step? (Choose three) |
| naidu |
Posted: Dec 27, 2006 05:00:04 AM |
Total Post: 85
Joined: Nov, 2006
|
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)
A. Deleting the records of employees who do not earn commission.
B. Increasing the commission of employee 3 by the average commission earned in department 20.
C. Finding the number of employees who do NOT earn commission and are working for department 20.
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.
E. Creating a table called COMMISSION that has the same structure and data as the columns EMP_ID and COMMISSIONS of the EMP table.
F. Decreasing the commission by 150 for the employees who are working in department 30 and earning a commission of more then 800.
Answer:
|
|
|
 Jayanta |
| Posted: Dec 27, 2006 05:05:52 AM |  |
|
Total Post: 479
Joined: Feb, 2006
|
|
|
|
|
| devi |
| Posted: Dec 27, 2006 05:28:49 AM | |
|
Total Post: 4
Joined: Dec, 2006
|
|
|
|
|
| Jayanta |
| Posted: Dec 27, 2006 05:34:40 AM | |
|
Total Post: 479
Joined: Feb, 2006
|
thanks devi truly the other option is f, i skipped
with regards jayanta
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 857 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| Gopu Gopi | 333 |
| Gitesh Trivedi | 322 |
| Vinoth Kumar | 264 |
| neeraj sharma | 258 |
| Ramesh Jois | 246 |
|
|
