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;

57 Comments:

Blogger Unknown 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 Unknown 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 Unknown 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 Unknown 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 ict 99 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 Unknown 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 Unknown 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 franklin 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 Unknown 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 Unknown 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 Unknown said...

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

2:42 AM  
Blogger Unknown said...

Mettur dam updates Mettur Diary

11:53 PM  
Blogger Unknown said...

Truely a very good article on how to handle the future technology. After reading your post,thanks for taking the time to discuss this, I feel happy about and I love learning more about this topic.keep sharing your information regularly for my future reference

Best Dental Clinic In Vellore

Best Dental Clinic In OMR

2:10 AM  
Blogger Unknown said...

Information in the article is very useful to everyone, thanks for the author.
Uprtou result

Ou Degree Results
<a

5:02 AM  
Blogger Unknown said...

wow really superb you had posted one nice information through this. Definitely it will be useful for many people. So please keep update like this.

Teeth Whitening treatment
Root Canal Treatment In Chennai
Cosmetic Dentistry
Orthodontic Treatment

6:05 AM  
Blogger Upshot Tech said...

Training institute in bangalore
java training institute in bangalore
digital marketing training in bangalore
python training in bangalore
aws training in bangalore
devops training institutes in bangalore

5:30 AM  
Blogger akhilapriya404 said...

I read this article. I think You put a lot of effort to create this article. I appreciate your work. salesforce Online Training

11:57 PM  
Blogger Vicky Ram said...


Wonderful post!!Thank you for sharing this info with us.
Keep updating I would like to know more updates on this topic
Very useful content, I would like to suggest this blog to my friends.


Informatica Training center in Chennai


Informatica course in Chennai

2:49 AM  
Blogger simbu said...

The knowledge of technology you have been sharing thorough this post is very much helpful to develop new idea. here by i also want to share this.

java training in chennai | java training in bangalore

java online training | java training in pune

java training in chennai | java training in bangalore

4:37 AM  
Blogger Unknown said...

Needed to compose you a very little word to thank you yet again regarding the nice suggestions you’ve contributed here.
python training in chennai | python training in bangalore

python online training | python training in pune

python training in chennai | python training in bangalore

5:10 AM  
Blogger nivatha said...

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

Data Science Training in Chennai
Data science training in bangalore
Data science online training
Data science training in pune
Data science training in kalyan nagar
selenium training in chennai

4:05 AM  
Blogger pavithra dass said...

Pretty blog, so many ideas in a single site, thanks for the informative article, keep updating more article.
Salesforce Training in Chennai
German Classes in Chennai
Salesforce Course in Chennai
Salesforce developer training in chennai
German Language Course in Chennai
German Courses in Chennai

2:41 AM  
Blogger Sumaya Manzoor said...

Thanks for sharing a valuable information to us. your article inspired me more. I Would like to get more updates in future.
Selenium Training in Chennai
Selenium Course in Chennai
iOS Course in Chennai
Digital Marketing Training in Chennai
J2EE Training in Chennai
Future of testing professional
SEO Course in Chennai
SEO Training Institute in Chennai

11:11 PM  
Blogger Unknown said...

Brilliant ideas that you have share with us.It is really help me lot and i hope it will help others also.update more different ideas with us.
Java Training in OMR
Java Training in Sholinganallur
Java Training in T nagar
Java Institute in T nagar
Java Courses in Thirumangalam
Java training courses near me

11:07 PM  
Blogger Mindmajix Technologies INC said...

Really this is a great informative post. This blog is very much helpful for the beginners and developers as well.

Thanks
Katherine

10:40 PM  
Blogger uma said...

The blog is well. thanks for this great information


selenium training centers in Bangalore

best software testing training institutes in Bangalore with placements

automation testing courses in Bangalore

selenium testing course in Bangalore

software testing institutes in Bangalore

selenium training in Bangalore

best selenium training in Bangalore

selenium course in Bangalore

8:31 PM  
Blogger chandana said...

It's a nice blog.
robotics courses in Marathahalli

robotic process automation training in Marathahalli

blue prism training in Marathahalli

rpa training in Marathahalli

automation anywhere training in Marathahalli

8:37 PM  
Blogger jefrin said...

wow very good to read
cloud computing course in chennai

12:25 AM  
Blogger Anjali Siva said...

Great blog, I was searching this for a while. Do post more like this.
DevOps Training in Chennai
AWS Training in Chennai
Data Science Course in Chennai
ccna course in Chennai
Python Training in Chennai
R Programming Training in Chennai
Angularjs Training in Chennai
RPA Training in Chennai
Blue Prism Training in Chennai

10:43 PM  
Blogger karthick said...

Best Blockchain Training Institute in Chennai

Best Blockchain Training Institute in Chennai

2:33 AM  
Blogger tamilsasi said...

That was a great message in my carrier, and It's wonderful commands like mind relaxes with understand words of knowledge by information's.
devops online training

aws online training

data science with python online training

data science online training

rpa online training

2:38 AM  
Blogger sai ram said...

All the points you described so beautiful. Every time i read your i blog and i am so surprised that how you can write so well.
Microsoft Azure online training
Selenium online training
Java online training
uipath online training
Python online training

3:08 AM  
Blogger iBrandox Pvt Ltd said...

Best Dental Clinic in Gurgaon
Cosmodent is one of the best dental clinic in Gurgaon. Cosmodent highly experienced Dentist team and modern technologies used make the treatment more perfect and safe.

10:37 PM  
Blogger deiva said...

This comment has been removed by the author.

6:54 PM  
Blogger deiva said...

"Thanks for sharing this awesome content..
Digital Marketing Training Course in Chennai | Digital Marketing Training Course in Anna Nagar | Digital Marketing Training Course in OMR | Digital Marketing Training Course in Porur | Digital Marketing Training Course in Tambaram | Digital Marketing Training Course in Velachery

"

6:55 PM  
Blogger saran said...

Thanks for your informative blog. Your post helped me to understand the future and career prospects. Keep on updating your blog with such awesome blog.
Digital Marketing Training Course in Chennai | Digital Marketing Training Course in Anna Nagar | Digital Marketing Training Course in OMR | Digital Marketing Training Course in Porur | Digital Marketing Training Course in Tambaram | Digital Marketing Training Course in Velachery


6:52 AM  
Blogger Devi said...

Its really great information i am thank full to this website........... oracle training in chennai

9:22 AM  
Blogger manasa said...

Awesome blog it's very nice and useful i got many more information it's really nice i like your blog

AI Training in Hyderabad

10:01 PM  
Blogger Pushba said...

After reading your article I was amazed. I know that you explain it very well. And I hope that other readers will also experience how I feel after reading your article.
IELTS Coaching in chennai

German Classes in Chennai

GRE Coaching Classes in Chennai

TOEFL Coaching in Chennai

spoken english classes in chennai | Communication training

10:58 AM  
Blogger veera said...

Thanks for your valuable information.I found it very useful.Keep posting amazing content like this.
| Certification | Cyber Security Online Training Course|

Ethical Hacking Training Course in Chennai | Certification | Ethical Hacking Online Training Course|

CCNA Training Course in Chennai | Certification | CCNA Online Training Course|

RPA Robotic Process Automation Training Course in Chennai | Certification | RPA Training Course Chennai|

SEO Training in Chennai | Certification | SEO Online Training Course

9:02 AM  
Blogger SOL Technologies Solutions said...

Such a great articles in my carrier, It's wonderful commands like easiest understand words of knowledge in information's.

Core to Advanced Digital Marketing Training Course in Delhi, India
Learn Complete Advanced Excel Training Course in Delhi, NCR

4:38 AM  
Blogger INFYCLE TECHNOLOGIES said...

Want to do Data Science Course in Chennai with Certification Exam? Catch the best features of Data Science training courses with Infycle Technologies, the best Data Science Training & Placement institutes in and around Chennai. Infycle offers the best hands-on training to the students with the revised curriculum to enhance their knowledge. In addition to the Certification & Training, Infycle offers placement classes for personality tests, interview preparation, and mock interviews for clearing the interviews with the best records. To have all it in your hands, dial 7504633633 for a free demo from the experts.

10:26 AM  
Blogger Thedentalhub1 said...

The Dental Hub is a best dental clinic in Gurgaon. Best dental clinic in gurgaon
.Our goal is to consistently provide our patients with sensible, long-lasting premium dental treatment.

10:13 PM  
Blogger David Fincher said...

Such a good post .thanks for sharing
IELTS Coaching in OMR
IELTS Coaching in Chennai

3:06 AM  
Blogger Yasodha Varman said...

Jump into an immense learning experience of DevOps Training in Chennai from Infycle Technologies, the finest software training Institute in Chennai. Also, an excellent place to learn other technical courses like Cyber Security, Graphic Design and Animation, Block Security, Java, Cyber Security, Oracle, Python, Big data, Azure, Python, Manual and Automation Testing, DevOps, Medical Coding etc., and here we provide well-experienced trainers with excellent training to the freshers. And we also provide 100+ Live Practical Sessions with Real-Time scenarios which helps the students in learning the technical stuff easily and they are able to get through interviews in top MNC’s with an amazing package. for more queries call us on 7504633633, 7502633633.

5:12 AM  
Blogger Pavithra Devi said...


This post is so interactive and informative.keep update more information…
IELTS Coaching in anna nagar
IELTS Coaching in Chennai

9:29 PM  
Blogger scouts tips said...

This comment has been removed by the author.

10:38 PM  
Blogger scouts tips said...

home decor company
VBoAST Home Goods

Have you ever felt like your home does not define who you are? It takes an eye for detail to turn simple walls into a cozy home. Having that artistic eye, I started VBōAST Home Decor as an outlet for me, where I could offer beautiful pieces at affordable prices so everyone can have their own space they love and call "home."

Home is not just about walls; it is more like love, emotions, experiences, and warm feelings that dictate how we live our lives every day. With intricate design and luxurious detailing, my goal has always been to decorate a home that you feel like rushing towards from every other corner of the world.

I, along with my team, aim to take the stress out of decorating your home so that you can enjoy it for years to come. Together we can make the process of decorating your home smooth and enjoyable. Let’s start this mission today and make this phase an endearing memory for you and your loved ones.

11:10 AM  
Blogger arnav digital said...

This comment has been removed by the author.

11:33 PM  
Blogger scouts tips said...

Telesaga is an entertainment website Yakshini Oolala App that caters to the interests of diverse audiences worldwide. With its wide-ranging coverage of entertainment, Telesaga is the go-to destination for anyone looking for quality content.

Whether you are a casual viewer or a hardcore fan, Telesaga has something for everyone. From the latest blockbuster hits to the hottest Web Series, Telesaga brings you all the latest updates in the entertainment world.

What sets Telesaga apart is its commitment to providing its readers with unbiased and authentic coverage of the entertainment industry. Its team of experienced writers and editors are passionate about what they do and bring their expertise and knowledge to every article, review, and opinion piece they publish.

10:21 AM  

Post a Comment

<< Home