abhishek


{ City } pune
< Country > india
* Profession * technical engineer
User No # 62425
Total Questions Posted # 1
Total Answers Posted # 3

Total Answers Posted for My Questions # 2
Total Views for My Questions # 4001

Users Marked my Answers as Correct # 22
Users Marked my Answers as Wrong # 5
Questions / { abhishek }
Questions Answers Category Views Company eMail

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

Synechron, TCS,

2 SQL Server 4001



Answers / { abhishek }

Question { Informatica, 12119 }

What is the different between Stored Procedure and Procedure?


Answer

Stored procedure is a subprogram in oracle and procedure is an anoyomous block. Stored procedure can be caled by exec at any time wen the user require it for execution..Procedure are created for temporary execution and they are not stored

Is This Answer Correct ?    0 Yes 1 No

Question { Infosys, 14335 }

Can we use out parameter in function?


Answer

Yes we can use the out parameter in function. But it does
not as any use as the value will be return to the calling
statement by the keyword return.

Is This Answer Correct ?    8 Yes 4 No


Question { Synechron, 4001 }

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


Answer

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