If a left outer join is performed and the tuple on the left hand side does not match with the tuple on the right hand side, what happens to the values that are preserved on the left hand side?(a) They are given null values(b) They are given a random value(c) The user is asked to enter data(d) The query is declared invalid by the compilerThis question was posed to me in an international level competition.Enquiry is from Join Expressions in chapter Intermediate and Advanced Sql of RDBMS

If a left outer join is performed and the tuple on the left hand side

1.	If a left outer join is performed and the tuple on the left hand side does not match with the tuple on the right hand side, what happens to the values that are preserved on the left hand side?(a) They are given null values(b) They are given a random value(c) The user is asked to enter data(d) The query is declared invalid by the compilerThis question was posed to me in an international level competition.Enquiry is from Join Expressions in chapter Intermediate and Advanced Sql of RDBMS
Answer» The CORRECT option is (a) They are given null VALUES For explanation I would say: If a LEFT outer join is performed and the tuple on the left hand SIDE does not match with the tuple on the right hand side, the remaining values are given a null value.

Discussion

No Comment Found

Related InterviewSolutions

The collections on which aggregate functions can operate are called as __________(a) Multisets(b) Multivalues(c) Multicollections(d) MultivariablesThe question was asked in final exam.I would like to ask this question from The Relational Algebra topic in section Intermediate and Advanced Sql of RDBMS
State true or false: There exists a division operator in Relational Algebra(a) True(b) FalseThis question was posed to me in my homework.My question is from The Relational Algebra in portion Intermediate and Advanced Sql of RDBMS
Updating, Deleting and Inserting in relational algebra is done using the ________ operator(a) Assignment(b) Modification(c) Alteration(d) InclusionThis question was addressed to me in an online interview.The above asked question is from The Relational Algebra in chapter Intermediate and Advanced Sql of RDBMS
How is the right outer join symbol represented in relational algebra?(a) ⟕(b) ⟖(c) ⟗(d) ⋈I have been asked this question in unit test.The question is from The Relational Algebra in division Intermediate and Advanced Sql of RDBMS
How is the left outer join symbol represented in relational algebra?(a) ⟕(b) ⟖(c) ⟗(d) ⋈The question was asked in semester exam.I want to ask this question from The Relational Algebra topic in division Intermediate and Advanced Sql of RDBMS
The project operation’s function in relational algebra is identical to the _______ clause in SQL(a) where(b) from(c) select(d) none of the mentionedThe question was asked in examination.This intriguing question originated from The Relational Algebra topic in section Intermediate and Advanced Sql of RDBMS
The select operation’s function in relational algebra is identical to the _______ clause in SQL(a) where(b) from(c) select(d) none of the mentionedThe question was asked during an interview for a job.My question is from The Relational Algebra topic in chapter Intermediate and Advanced Sql of RDBMS
Which of the following is not a relational algebra function?(a) Select(b) Project(c) Manipulate(d) UnionThe question was posed to me in class test.This question is from The Relational Algebra topic in chapter Intermediate and Advanced Sql of RDBMS
State true or false: In OLAP, analysts cannot view a dimension in different levels of detail.(a) True(b) FalseThis question was posed to me at a job interview.This key question is from OLAP topic in section Intermediate and Advanced Sql of RDBMS
The operation of moving from coarser granular data to finer granular data is called _______(a) Reduction(b) Increment(c) Roll back(d) Drill downThis question was posed to me in a national level competition.The question is from OLAP topic in portion Intermediate and Advanced Sql of RDBMS

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment