Interview

What is tuple size?
Ans Tuple size 8.

Any alternative for cursor?

Ans : Joins 

https://interview-preparation-for-you.blogspot.com/2019/02/what-is-cursor-cursor-is-database.html

Can we return single value from stored procedure? How?
Ans : https://interview-preparation-for-you.blogspot.com/2019/02/can-we-return-single-value-from-stored.html

If we have lakhs of records  in database and we are inserting and selecting at same time. 

Can we do that how?

Types of user defined function?

Difference between var and dynamic.

Difference between abstract and interface.

Why we need interface?

Can we use asynch and await separately?
Ans No

What is the use of cursor?

Write a lambda query and Sql query to fetch data from a list/table

Give me some pattern name of structural?

Observer pattern

Composite pattern?

Difference between factory and Abstract factory.

The main difference between a “factory method” and an “abstract factory” is that the factory method is a single method, and an abstract factory is an object.
The factory method is just a method, it can be overridden in a subclass, whereas the abstract factory is an object that has multiple factory methods on it.
The Factory Method pattern uses inheritance and relies on a subclass to handle the desired object instantiation.

What is return type of procedure?

Integer

Can we return any value from procedure?

In SQL Server by using the return values, we can return only one integer. It is not possible, to return more than one value using return values, whereas in output parameters, we can return any data type and a stored procedure can have more than one output parameter.

How to return value from function?

What is the use of view?

Can we update table from view?