What are “lost updates”?
No Answer is Posted For this Question
Be the First to Post Answer
How will you optimize a stored procedure optimization?
Diff between Composite key, Alternate Key, Candidate Key, Primary Key, Unique Key, Super Key, Foreign Key
What is Schema in Database?
What is a db view?
Where is trigger in sql server?
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 ?
Differentiate between a local and a global temporary table?
What is the difference between commit and rollback?
what is the Surrogate key?and wt is the diff between Primary key and Surrogate Key?
What is catalog views?
What is the purpose of UPDATE STATISTICS?
Is sql server is free?