InterviewUp – Job Interview Questions and Answers – What is join dependency and inclusion dependency?

December 01, 2008

Home

Sign-In

My Interview Questions

Question & Additional Information

UPs

What is join dependency and inclusion dependency?

Comments (0) |

Inappropriate

Asked By: mariann

Back

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

Answer

Edit

Join Dependency:

A Join dependency is generalization of Multivalued dependency.A JD {R1, R2, ..., Rn} is said to hold over a relation R if R1, R2, R3, ..., Rn is a lossless-join decomposition of R . There is no set of sound and complete inference rules for JD.

Inclusion Dependency:

An Inclusion Dependency is a statement of the form that some columns of a relation are contained in other columns. A foreign key constraint is an example of inclusion dependency.

Tags

Edit

database, RDBMS, Data Warehousing

Asked At

Edit

None

Job Titles

Edit

Database Engineer

Comments (0) :

Your Name:

Add your comment text

Tags

database, join, view

Asked At

None

Job Positions

database

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

156

UPs

What is it in myself that makes me confident to be a doctor?

Add or view comments about this interview question

Comments (2) |

Share this interview question with your friend

Inappropriate

View all interview questions asked by this user

Asked By: BenjaminTake... |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

Create Date

Monday, September 24, 2007

Tags

doctor, confident, inside, makes, me, what, is, it, in, that, to, be

Asked At

IMU (International Medical School) Malaysia

Job Positions

Medical school student

Click here to improve the Interview Question, Answer and other fields.

Comments (2) :

dk123

Wednesday, March 19, 2008 6:27 AM

nice comment

thingMaster

Tuesday, October 23, 2007 1:52 PM

you are overconfident. you will probably kill many patients, but drive a nice car.

See all 2 comments

143

UPs

What are different types of table join in oracle?

Comments (0) |

Inappropriate

Asked By: Anonymous |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

different types of joins are
equi join
non equi joiin
self join
outer join

Create Date

Tuesday, September 04, 2007

Tags

oracle, table, join, equi, nonequi, selfjoin, outerjoin

Asked At

None

Job Positions

None

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

150

UPs

Can you use server-side inclusions in xml?

Comments (0) |

Inappropriate

Asked By: Anonymous |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

Yes, so long as what they generate ends up as part of an XML-conformant file (ie either valid or just well-formed).
Server-side tag-replacers like shtml, PHP, JSP, ASP, Zope, etc store almost-valid files using comments, Processing Instructions, or non-XML markup, which gets replaced at the point of service by text or XML markup (it is unclear why some of these systems use non-HTML/XML markup).

Create Date

Tuesday, September 11, 2007

Tags

XML, server-side, inclusion, conformant file, non-XML markup, tag

Asked At

None

Job Positions

None

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

131

UPs