Answer Posted / pavan singh
there are 5types of isolation level
1.ecoas
2.read commited
3.read uncommited
4.repetable read
5.synchronized
| Is This Answer Correct ? | 1 Yes | 8 No |
Post New Answer View All Answers
What is the difference between TRUNCATE and DROP?
What is the default order of an order by clause?
What are “lock” hints?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
What is data file in computer?
How to create view in stored procedure sql server?
Explain filtered indexes?
What is the report builder?
Explain what is analysis service repository?
How to copy the tables, schema and views from one sql server to another?
Explain the steps to create and execute a user-defined function in the sql server?
How to create a new schema in a database?
Why use “pivot” in sql server?
Write an SQL query to obtain the 2nd highest salary.
explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
