Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sanjeev kumar
DBCC stands for database consistency checker. We use these
commands to check the consistency of the databases.
Example, maintenance, validation task and status
checks.Saying is that,through DBCC we can check what is
happining in database on time to time. It give me a changes
of information just happing in a bit of time (this is the
reason it is called consistency)
like:-
DBCC CHECKALLOC - Check consistency of disk allocation.
DBCC CHECKCATALOG - Check catalog consistency
DBCC CHECKCONSTRAINTS - Check integrity of table constraints.
etc.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What is a derived table?
Can you explain important index characteristics?
What are the disadvantages of indexes?
Explain the difference between function and stored procedure?
List out the differences between global and local temp tables in sql server?
What are the different types of join?
How to create percentile function?
How to edit table in sql server 2017?
What is difference between oltp and olap?
What do you understand by hotfixes and patches in sql server?
How to rebuild indexes with alter index ... Rebuild?
What is the difference between composite index and covering index?
What are system databases in ms sql server?
How can we rewrite sub-queries into simple select statements or with joins?
How to update muliple row in single query?
