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
Tell me about the approaches which you used to counter the DI problems.
What is raid? : SQL Server Architecture
What is default constraint in ms sql server?
What are the advantages to use stored procedures?
how can u get last observation in an unknown dataset ?
What are the different SQL Server Versions you have worked on?
what is bit datatype? : Sql server database administration
What is the use of group by clause?
Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
How can sql server instances be hidden?
Explain go command in sql server?
What is database architecture? : SQL Server Architecture
What is a file group?
What is difference between foreign key and unique key?
Why use “pivot” in sql server?
