three type of (1)Begin (2)Rollback (3)commit

How many nested transaction can possible in sql server?

Question Posted / naveen singh

Answer Posted / naveen singh

three type of

(1)Begin
(2)Rollback
(3)commit

Is This Answer Correct ?

11 Yes

25 No

Please Help Members By Posting Answers For Below Questions

What do you understand by mirroring and mention the advantages of the mirroring?

1068

Do you know clustered and non-clustered index?

978

What is normalization? What number of normalization shapes are there?

1107

What are pessimistic lock and optimistic lock?

1074

What are logical database components? : SQL Server Architecture

1033

What is the full form of ddl?

925

How will you find out if there are expensive SQL statements running or not?

1015

what is the difference between Delete and Truncate command in SQL

1147

What is collation sensitivity? Explain different types.

1009

How to delete exactly duplicate records from a table?

1063

Explain nested trigger in sql?

1069

What is the synonym of join?

961

What is a trace frag?

1083

Can you name a few encryption mechanisms in sql server?

942

what are database files and filegroups? : Sql server database administration

945