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 ?
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
What is a linked server in sql server?
How to use the inserted and deleted pseudo tables?
Does a server store data?
How do I setup a sql server database?
Do you know what are pages and extents? : SQL Server Architecture
What are sql server functions?
How is foreign key related to primary key?
How to call a function from a stored procedure in SQL Server ?
How much does sql server 2016 cost?
Can I save my report as html, excel or word? : sql server management studio
What are scheduled tasks in sql server?
can you instantiate a com object by using t-sql? : Sql server database administration
Write a code to select distinct records without using the DISTINCT keyword.
What is constraints and its types?
Why should you use or avoid select * statements?