InterviewSolution

Explore topic-wise InterviewSolutions in .

This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.

51.	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.

52.	Which off the following is not a valid type of join?(a) left outer join(b) outer join(c) join(d) full joinI got this question in an internship interview.This intriguing question originated from Join Expressions in chapter Intermediate and Advanced Sql of RDBMS
Answer» RIGHT answer is (d) full JOIN Best explanation: There is no such join called as full join. There is a full outer join but a full join does not EXIST.

53.	State true or false: on and where behave differently for outer join(a) True(b) FalseI had been asked this question in final exam.My question is based upon Join Expressions topic in portion Intermediate and Advanced Sql of RDBMS
Answer» The correct ANSWER is (a) True The EXPLANATION: The on CONDITION is a part of the outer JOIN syntax but the where clause isn’t.

54.	What is the function of inner join?(a) It preserves tuples only in the relation named before the operation(b) It preserves tuples only in the relation named after the operation(c) It preserved tuples in the relations named on both the sides of the operation(d) It does not preserve any tuples on either side of the relationI got this question in homework.The question is from Join Expressions in chapter Intermediate and Advanced Sql of RDBMS
Answer» The CORRECT choice is (d) It does not preserve any tuples on either side of the RELATION The best I can EXPLAIN: The JOIN operations that do not retain mismatched tuples are called as inner join operations. The inner join operation does not preserve any tuples on either side of the relation.

55.	What is the function of a right outer join?(a) It preserves tuples only in the relation named before the operation(b) It preserves tuples only in the relation named after the operation(c) It preserved tuples in the relations named on both the sides of the operation(d) It does not preserve any tuples on either side of the relationThe question was posed to me in an online quiz.My doubt is from Join Expressions in section Intermediate and Advanced Sql of RDBMS
Answer» Right CHOICE is (B) It preserves TUPLES only in the relation named after the operation For explanation: The right outer JOIN operation preserves the tuples named after the operation.

56.	What is the function of a full outer join?(a) It preserves tuples only in the relation named before the operation(b) It preserves tuples only in the relation named after the operation(c) It preserved tuples in the relations named on both the sides of the operation(d) It does not preserve any tuples on either side of the relationThe question was asked in quiz.This intriguing question originated from Join Expressions topic in portion Intermediate and Advanced Sql of RDBMS
Answer» Right choice is (c) It preserved tuples in the relations NAMED on both the sides of the operation For explanation I would SAY: The FULL OUTER join operation preserves the tuples named on both the sides of the operation. Unlike the inner join, outer joins preserve tuples from either or both sides of the operation.

57.	What is the function of a left outer join?(a) It preserves tuples only in the relation named before the operation(b) It preserves tuples only in the relation named after the operation(c) It preserved tuples in the relations named on both the sides of the operation(d) It does not preserve any tuples on either side of the relationI got this question in exam.The question is from Join Expressions in portion Intermediate and Advanced Sql of RDBMS
Answer» Correct answer is (a) It PRESERVES TUPLES only in the relation NAMED before the operation To explain I WOULD say: The left outer join operation preserves the tuples named before the operation.

58.	The join operations that do not retain mismatched tuples are called as _________ operations(a) outer join(b) natural join(c) full outer join(d) inner joinThis question was posed to me during an online exam.This is a very interesting question from Join Expressions topic in division Intermediate and Advanced Sql of RDBMS
Answer» RIGHT OPTION is (d) inner join Easy explanation: The join operations that do not retain MISMATCHED tuples are called as inner join operations. The inner join operations do not preserve any tuples that are OTHERWISE preserved in the outer join operation.

59.	What is the difference between a join and an outer join operation?(a) There is no difference(b) Join preserves a few tuples that are otherwise lost in the outer join(c) Outer join preserves a few tuples that are otherwise lost in the join(d) An outer join can be used only on outer queries whereas a join operation can be used in SubqueriesThis question was addressed to me during a job interview.The origin of the question is Join Expressions in chapter Intermediate and Advanced Sql of RDBMS
Answer» Correct option is (c) Outer join preserves a few TUPLES that are OTHERWISE lost in the join For explanation I would SAY: The outer join operation preserves a few tuples that are otherwise lost in the join operation. The outer join operation preserves the tuples to the right of the operation.

60.	The on condition appears at the _______ of the join expression(a) Beginning(b) End(c) Between(d) The on condition is not related to join expressionI have been asked this question in homework.Query is from Join Expressions in chapter Intermediate and Advanced Sql of RDBMS
Answer» The correct CHOICE is (b) END Easy EXPLANATION: The on condition appears at the end of the join EXPRESSION. Because it states the condition that the relations under the join operations GET matched based on.