Subjects
PRICING
COURSES
SIGN IN
Start Free Trial
Budda J.
Worked as Associate Software Engineer at Accenture and Graduate Student at University of Texas at Dallas
Tutor Satisfaction Guarantee
SQL Programming
TutorMe
Question:

Instead of using a NULL how do I show a "0" using a SELECT statement for a particular column?

Budda J.
Answer:

Here is the answer.Use the coalesce function. SELECT coalesce (column,0) as column. coalesce function returns the first null value.

R Programming
TutorMe
Question:

There are two vectors X<-c(3,2,4) and Y<-c(1,2) . What is the will be the result for Z<-X*Y?

Budda J.
Answer:

The result is Z<-(3,4,4).In R when two vectors are of different length,multiplication begins with a smaller vector and continues till all the elements in the larger vector have been multiplied. So, the result is as such Z<- (3*1 , 2*2 , 4*1)

Databases
TutorMe
Question:

What is the disadvantage of using flat files foe storing the attribute information?

Budda J.
Answer:

A lot of space gets wasted using a flat file, since every data record must contain the same number of fields regardless of the use of the field or not.This becomes a very big problem in large files containing lot of fields which do not have the same data field.In that case it becomes a big problem to store the data in such flat files.

Send a message explaining your
needs and Budda will reply soon.
Contact Budda
Ready now? Request a lesson.
Start Session
FAQs
What is a lesson?
A lesson is virtual lesson space on our platform where you and a tutor can communicate. You'll have the option to communicate using video/audio as well as text chat. You can also upload documents, edit papers in real time and use our cutting-edge virtual whiteboard.
How do I begin a lesson?
If the tutor is currently online, you can click the "Start Session" button above. If they are offline, you can always send them a message to schedule a lesson.
Who are TutorMe tutors?
Many of our tutors are current college students or recent graduates of top-tier universities like MIT, Harvard and USC. TutorMe has thousands of top-quality tutors available to work with you.