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 ?
- 10 Answers
- 16592 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
How to query multiple tables jointly?
What is molap and its advantage? : sql server analysis services, ssas
What is difference between join and natural join?
What is for xml in sql server?
how can a database be repaired? : Sql server administration
How to add additional conditions in SQL?
How you can change the database name in SQL SERVER?
What is the difference between coalesce() & isnull()?
What is the difference between mysql and sql server?
How can I create a report based on a query? : sql server management studio
What is the most common type of join?
What command is used to create a database in the sql server and how?
What is the filtered index?
How to create sub reports?
What is acid properties?
