Wednesday, May 24, 2006

SECTION 5
LESSON 1
Refer to the review examples shown below to answer the following questions about joins:
1. How do you know where to place the (+) in an outer join?

----the other side has null information
2. How do you know whether to indicate a join as a right, left, or full outer join?

----what side or both sides have null information
3. What is the function of the WHERE clause in an equijoin?

----provide the conditions to join tables
4. When using a nonequijoin, what conditions must be true about the data in each table?

----the column name
5. What data will not be returned in a natural join between two tables?

----not match
LESSON 4
1. Create a query that will show the average cost of the DJ on Demand events. Round to two decimal places.


----select round(avg(cost),2)
from d_events;

2. Find the average salary for Global Fast Foods staff members whose manager ID is 19.

----select avg(salary)
from f_staffs
where manager_id=19;

3. Find the sum of the salaries for Global Fast Foods staff members whose IDs are 12 and 9.

---select sum(salary)
from f_staffs
where id in(12,19);

4. Using the Oracle database, select the lowest salary, the most recent hire date, the last name of the person who is at the top of an alphabetical list of employees, and the last name of the person who is at the bottom of an alphabetical list of employees. Select only employees who are in departments 50 or 60.

----select min(salary),max(hire_date),min(last_name),max(last_name)
from employees
where department_id in(50,60);

5. Your new Internet business has had a good year financially. You have had 1,289 orders this year. Your customer order table has a column named total_sales. If you submit the following query, how many rows will be returned?
SELECT sum(total_sales)
FROM orders;

----none

6. You were asked to create a report of the average salaries for all employees in each division of the company. Some employees in your company are paid hourly instead of by salary. When you ran the report, it seemed as though the averages were not what you expected. They were much higher than you thought! What could have been the cause?

----someone paid hourly, someone paid yearly


7. Employees of Global Fast Foods have birth dates of July 1, 1980, March 19, 1979, and March 30, 1969. If you select MIN(birthdate), which date will be returned?

----March 10,1969

8. Create a query that will return the average order total for all Global Fast Foods orders from January 1, 2002, to December 21, 2002.

----select avg(order_total)
from d_orders
where order_date is between 'January 1, 2002' and 'December 21, 2002';

9. What was the hire date of the last Oracle employee hired?

----select max(hire_date)
from employees;

10. In the following SELECT clause, which value returned by the SELECT statement will be larger?SELECT SUM(operating_cost), AVG(operating_cost)

----SUM(operating_cost)
LESSON 5
1. How many songs are listed in the DJs on Demand D_SONGS table?

----select count(id)
from d_songs;

2. In how many different location types has DJs on Demand had venues?

----select count(distinct loc_type)
from d_venues;

3. The d_track_listings table in the DJs on Demand database has a song_id column and a cd_number column. How many song IDs are in the table and how many different CD numbers are in the table?

----select count(song_id),count(distinct cd_number)
from D_TRACK_LISTINGs;

4. How many of the DJs on Demand customers have email addresses?

----select count(email)
from d_clients;

5. Some of the partners in DJs on Demand do not have authorized expense amounts (auth_expense_amt). How many partners do have this privilege?

----select count(auth_expense_amt)
from partners;

6. Using the table shown, what values will be returned when the following statement is issued?
SELECT COUNT(shoe_color), COUNT(DISTINCT shoe_color)FROM shoes;


----the total number of shoes, the number of shoes for different types

7. Create a query that will convert any null values in the auth_expense_amt column on the DJs on Demand D_PARTNERS table to 100000 and find the average of the values in this column. Round the result to two decimal places.

----select round(avg(nvl(auth_expense_amt,100000)),2)
from d_partners;

24 Comments:

Blogger Daniel Joseph said...

SAP Training... Visit Us,
Sap training in chennai | SAP Success factor training in chennai | Workday training in chennai | Success factor training in chennai

11:58 PM  
Blogger glennparyy said...

Oracle HW and oracle ADG is same or not equivalent.

Java training in Chennai | Android training in chennai | IOS training in chennai

4:35 AM  
Blogger joshnson haddin said...

Your hadoop training in chennaionline journal is novel among each other.oracle training in chennai I may turn out my website to your technique so that my web journal too will work out. I recognized like oracle dba training in chennai you have termed every last intending to be clear.

12:30 AM  
Blogger joshnson haddin said...

Your oracle training in chennai
online diary is novel among one another. oracle dba training in chennai I may turn out my site to your procedure so that my web diary too will work out.hadoop training in chennai I perceived like you have termed each and every meaning to be clear.

12:33 AM  
Blogger Raksha said...

Thank you for the useful post. It helps a lot in my training. I share your blog with my students. Keep posting more.
Selenium Training in Chennai

6:12 AM  
Blogger PLC Training In Chennai said...

PLC Training in Chennai
PLC Training Institute in Chennai
PLC Training Center in Chennai
PLC Training Centre in Chennai
PLC SCADA Training in Chennai
SCADA Training in Chennai
Best PLC Training in Chennai
Best PLC Training Institute in Chennai
DCS Training in Chennai
Automation Training in Chennai
Automation Training Institute in Chennai
Process Automation Training in Chennai
Industrial Automation Training in Chennai
HMI Training in Chennai
VFD Training in Chennai
Final Year Projects in Chennai
IEE Projects in Chennai
Inplant Training in Chennai
Embedded Training in Chennai
VLSI Training in Chennai
IT Training in Chennai
AutoCad Training in Chennai
Web Designing Training in Chennai

9:23 PM  
Blogger Akula Rahul said...

LIC AAO Recruitment 2016 Online Application Form

I Like your site because you have a good post on this blog.........

2:54 AM  
Blogger for IT the said...

Great Article
Online Java Training | Java EE course | Java Course in Chennai | Java Training in Chennai | Java Training Institutes in Chennai | J2EE Training in Chennai | java j2ee training institutes in chennai

9:38 AM  
Blogger HogardSteve said...

Thanks for your valuable information.I found it very useful.Keep posting amazing content like this.
Assignment Tutor Help

9:59 PM  
Blogger Abina Ragav said...

JAVA training in chennai THINKIT is a leading JAVA training institute in Chennai, India. We offer various professional and job oriented courses to students, fresher, job seekers and professionals. Our courses include.Apart from regular training to students and experienced professionals, we also provide completely customized training's to entrepreneurs, small business owners and startup companies.

6:09 AM  
Blogger Ridhima said...


Thank you for taking the time to provide us with your valuable information. We strive to provide our candidates with excellent care and we take your comments to heart.As always, we appreciate your confidence and trust in us.

Hadoop Training in Chennai

10:46 PM  
Blogger Ridhima said...

Everything is fine, am happy about your blog. Thanks admin for sharing the unique content, you have done a great job I appreciate your effort and I hope you will get more positive comments from the web users.
Regards,

Hadoop Training in Chennai

10:48 PM  
Blogger Ridhima said...

Wonderful article, very useful and well explanation. Your post is extremely incredible. I will refer this to my candidates.

Hadoop Training in Chennai

10:50 PM  
Blogger Rakesh S said...

nce posts..
Informatica training, in the recent times has acquired a wide scope of popularity amongst the youngsters at the forefront of their career.
Informatica online training in hyderabad

11:37 PM  
Blogger Training Coimbatore said...

Wonderful article, very useful and well explanation. Your post is extremely incredible. I will refer this to my candidates.

Hadoop training in coimbatore
Java training in coimbatore
Oracle training in coimbatore
Informatica training in coimbatore
Oracle training in coimbatore
Informatica training in coimbatore

6:17 AM  
Blogger Nikshitha S said...

Well Said, you have furnished the right information that will be useful to anyone at all time. Thanks for sharing your Ideas.
Salesforce training in Chennai | salesforce course in Chennai

4:57 AM  
Blogger Roshini RS said...

In coming years, cloud computing is going to rule the world. The cloud based CRM tool provider like Salesforce have massive demand in the market. Thus talking Cloud Computing Training in Chennai from reputed Cloud Computing Courses will ensure bright career prospects for aspiring professionals.

4:47 AM  
Blogger Rasool Bevi said...

Everyone wants to get unique place in the IT industry’s for that you need to upgrade your skills, your blog helps me improvise my skill set to get good career, keep sharing your thoughts with us.
Salesforce Training in Chennai|Salesforce Training|Salesforce Training institutes in Chennai

6:44 AM  
Blogger sindhu said...


Thanks for appreciating. Really means and inspires a lot to hear from you guys.I have bookmarked it and I am looking forward to reading new articles. Keep up the good work..Believe me, This is very helpful for me.

CRO Agency in Chennai

1:46 AM  
Blogger kanchana said...

I keep on reading your blog post.. This was still amazing. Thanks a lot for sharing this unique informative post with us.. I really enjoyed by reading your blog post
Best SharePoint Training Institute in Chennai

2:32 AM  
Blogger Abiya Carol said...

Great Article… I love to read your articles because your writing style is too good, its is very very helpful for all of us and I never get bored while reading your article because, they are becomes a more and more interesting from the starting lines until the end.

Salesforce Training in Chennai

3:15 AM  
Blogger Gopi Perumal said...

Best Article..
Amazing psot.. with all details SAP Training in Chennai

2:42 AM  
Blogger Training Chennai said...

Pretty article! I found some useful information in your blog, it was awesome to read, thanks for sharing this great content to my vision, keep sharing.
Regards,
JAVA Training in Chennai | Multimedia Training in Chennai

10:41 PM  
Blogger sankar meta said...

Mettur dam updates Mettur Diary

11:53 PM  

Post a Comment

<< Home