RollBack Mean Transaction is Rolled Back to That State me undo The Thing

1. What are the grouping function in SQL ?

2. If base table of a view deleted means, what will happen
while we querying on view ? will give any error ?

3. Difference between DROP, DELETE, TRUNCATE table ?

4. What is constraints and types ?

5. What is max size of nchar & nvarchar ?

6. Define ROLLBACK, COMMIT, SAVE POINT

7. How non-clustered better ? or rank the Clustered,
Non-Clustered and Table scan in performance wise

8. Select 10 rows from a table ?

9. Define DML, DDL, DCL, DTL commands ?

10. What is mean by NULL value ? NULL means "" or 0 or
undefined ?

11. Default constraints ?

12. Can we have more then primary Key in table ?

13. Type of integrity ? Entity, Referential, Domain ?

Question Posted / dinesh sharma

10 Answers
18560 Views
Perot Systems, I also Faced
E-Mail Answers

Answer Posted / dinesh sharma

RollBack Mean Transaction is Rolled Back to That State me
undo The Thing That we Have Done

Commit Mean Transaction is Commited to that state me the
the thing we have done is save

SavePoint is Concept of ORacle mean
For A Long Transaction we have Declare save point
intermediate so that the transction before savepoint is
commited .

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What authentication modes does sql server support?

1097

Can a table have 2 primary keys?

983

What are the new features in sql server 2016?

967

When would you use a before or after trigger?

907

Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?

953

how can u get last observation in an unknown dataset ?

2436

What are the steps to process a single select statement?

942

Benefits of Stored Procedures?

964

What are different types of statements that are supported by sql?

1047

How do you start single user mode in clustered installations?

941

What are the purposes and advantages stored procedure?

959

How do I find the size of a sql server database?

928

What are date and time data types in ms sql server?

1092

What does nvl stand for?

943

What happens when converting big values to numeric data types?

1134