In table a 1lakh data is present,in table b 20 thousand data is present, to get

In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from table a and b which join to be considered. whether right outer join or left inner join.

Question Posted / rashmi

2 Answers
5347 Views
GE, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from tab..

Answer / krish

Using Intersect operator

Is This Answer Correct ?

0 Yes

0 No

In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from tab..

Answer / oracle enthusiastic

The optimizer automatically decides the driving table based on statistics. The join order is immaterial

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More SQL PLSQL Interview Questions

Why join is faster than subquery?

0 Answers

Is sql procedural language?

0 Answers

how to create table with in the procedure or function?

2 Answers Genpact, HCL,

Explain the difference between triggers and constraints?

0 Answers

Why truncate is faster than delete?

0 Answers

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

0 Answers

when a procedure /package is getting invalidated?

4 Answers TCS,

How do you retrieve set of records from database server. {Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records again connect to database retrieve next 100 }

2 Answers DELL,

What is embedded sql with example?

0 Answers

Is sql the best database?

0 Answers

What is difference between inner join and cross join?

0 Answers

I i have 2 tables A & B ,A contains 10 records B contains 20 records ,what w'll be the o/p if we perform equijoin,outer join,right outer join,left outer join,full outer join,cross join seperately Can anyone help on this?

2 Answers

For more SQL PLSQL Interview Questions Click Here