Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 18150 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 many type of indexing in database?
What is subquery? Explain the properties of a subquery?
What stored procedure can you use to display the current processes?
Explain differentiate between a having clause and a where clause?
How can we determine what objects a user-defined function depends upon?
Where in ms sql server is ’100’ equal to ‘0’?
How can you stop stored procedures from recompiling?
What happens to a statement batch if there is a compilation error?
What is enhanced database mirroring in sql server 2008?
What is the difference between insensitive and scroll cursor?
Can you import Microsoft Excel data to SSRS?
How are the exceptions handled in sql server programming?
what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
Explain how to use linked server?
What is update locks?
