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
18442 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

Can two tables share the same primary key?

893

what is isolation level at dead lock?

2131

Explain what are the database objects? : SQL Server Architecture

1056

How to create a simple user defined function in ms sql server?

997

What is 5nf in normalization form?

976

Explain what is the function of sql server agent windows service?

976

How can we delete Duplicate row in table?

1039

Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture

896

How real and float literal values are rounded?

1132

What is the difference between ddl,dml and dcl commands?

1093

Write a SQL command to insert and update only a particular field?

1087

what is checksum in sql server.........???

1666

What is a collation in ms sql server?

1055

How to create a view with data from multiple tables?

996

How to encrypt Strored Procedure in SQL SERVER?

1146