answer for this

q)When joining more than 2 tables, what rule is true?

1) All tables must be related to each other.
 2)Every table must be related to at least one table.
3) A table does not have to be related.
 4)There must be one table that is directly related to all other tables.

q) When using a join, which option is true about the joining columns in each table.

1) Must have the same name  
2)Must have the same data type
3) Must have the same name and data type.  ]
4)Must have a PK FK relationship.
5)  Must have been joined in the past.
dAsked:
Who is Participating?
 
Arifhusen AnsariBusiness Intelligence Developer and AnalystCommented:
Practically we can not answer this question. Because there is no restriction on data type or name of column or relationship between columns to be joined.

But conceptually, to get correct data we can answer this.

As per my knowledge, i might be wrong.

First question answer is Option2 : Because Every table should be connected to at lest one table. It's no mandatory for all tables to be connected. Eg. If you need product details.
Product Category is connected Product sub category
Product sub category is connected to Product

Even though , Product Category and Product are not connected we can use them in single query.

Second Question answer is Option 4: It's not mandatory to have pk and fk relationship. But it would be great, if this relationship is there.

Hope it will help you..!!
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Curiosity overwhelms me, which class is this homework for?
1
 
Nitin SontakkeDeveloperCommented:
@Jim,

Precise reaction coming to my while reading the question and your comment which put it in words. Perfect.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
dAuthor Commented:
i know the answers
1)option 1
2)OPTION 4
BUT TO CONFORM
0
 
dAuthor Commented:
IS THIS ANWERS ARE CURRECT
0
 
Nitin SontakkeDeveloperCommented:
And yet another thought was, never ever I had any formal education in Microsoft SQL Server and why none of these questions come to my mind when I am typing a query.
0
 
dAuthor Commented:
PLEASE ANY ONE TELL ME
0
 
_agx_Commented:
Why not create two tables, with a single column each, and test each theory?
0
 
PortletPaulfreelancerCommented:
Consider question 2 a bit more ...

Would you attempt to join a number column to a name column?
or a date column to book title column?

Remember that each given answer starts with MUST.
0
 
dAuthor Commented:
can any one tell me the answer
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
dr pallavi - In case you haven't noticed EE is not a homework site.  We expect you to be able to think a little and work with the comments experts give you, and not just copy-paste a multiple-choice question and then demand 'give me the answer'.  Otherwise it's called academic dishonesty.
1
 
PortletPaulfreelancerCommented:
Ps. Answer to question 2 isn't option 4....
0
 
PortletPaulfreelancerCommented:
EE's homework policy is here http://support.experts-exchange.com/customer/portal/articles/1435136

Accordingly let me try to explain why option 4 isn't correct for question 2.

It is NOT mandatory that every join be through a PK/FK, you can join through columns that are not keys.

But, if you try to join through columns that are different data types, one of those columns will be converted to a compatible data type and this can lead to query errors. E.g. You cannot join a date to a varchar unless one of those columns is converted.

So, option 4 is incorrect.

Reconsider: Question 2, option 2.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.