Solution : a) 40 rows b) 40 rows c) 40 rows http://abhishekgaikwadt

2) Consider a Table name A which has below records

ID
---
5
5
5
5
5
Consider another table B which has below records

ID
--
5
5
5
5
5
5
5
5
How many rows will be returned by each of the below queries
a) select * from A inner join B on A.id = b.ID
b) select * from A left join B on A.id = b.ID
c) select * from A right join B on A.id = b.ID

Question Posted / abhishek6555

2 Answers
4909 Views
Synechron, TCS, I also Faced
E-Mail Answers

Answer Posted / abhishek6555

Solution :

a) 40 rows
b) 40 rows
c) 40 rows

http://abhishekgaikwadtech.blogspot.in/2015/07/t-sql-interview-question-2.html

Is This Answer Correct ?

14 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain the truncate command? : SQL Server Architecture

1142

Does hive support indexing?

946

What is normalization process?

1149

What do you mean by collation recursive stored procedure?

1042

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

953

Explain contrast amongst grouped and non-bunched records?

1006

What stored by the model? : sql server database administration

935

mention different types of relationships in the dbms?

1001

Can you name a few encryption mechanisms in sql server?

926

What is the difference between ddl and dml?

1034

Explain what are the basic functions for master, msdb, model, tempdb databases?

951

What is a result set object returned by mssql_query()?

1130

How many types of cursor type are there?

1070

What are points to remember while using the fillfactor argument?

951

Explain different backup plans?

919