SQL - Interview Questions and Answers for 'Sql joins' | Search Interview Question

SQL - Interview Questions and Answers for 'Sql joins' - 6 question(s) found - Order By Newest

Q1. If Table A has 100 records and Table B has 50 records , how many records will the equi join of Table generate ?

SQL

Ans. It depends on the join condition.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve equi join sql join database sql}

Q2. If Table A has 100 records and Table B has 50 records , how many records will the left join of Table A with Table B generate ?

SQL

Ans. 100 records

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve database sql sql joins left join}

Q3. If Table A has 100 records and Table B has 50 records , how many records will the right join of Table A with Table B generate ?

SQL

Ans. 50 records

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve database sql sql joins right join}

Q4. If Table A has 0 records and Table B has 50 records , how many records will the equi join of Table generate ?

SQL

Ans. 0 records

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve database sql sql joins equi join}

Q5. Describe SQL Joins

Database

Ans. Oracle having following types of joins these are also called 8i joins. There are:

1. Equi (or) Inner join
2. Non Equi join
3.Self join
4.Outer join

Oracle also support the 9i (or) ANSI standard joins.There are:

1.Inner join
2.Left outer join
3.Right outer join
4.Full outer join
5.Natural join

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve sql joins sql Asked in 2 Companies}