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 are the advantages of stored procedure in sql server?
What are the key configuration files for sql server reporting services ?
How to perform backup for certificates in sql server? : sql server security
What are different types of statements that are supported by sql?
What is dml command?
What part does database design plays a role in performance of an sql server-based application?
What is BCP? When does it used in sql server 2012?
Explain the relational database management system (rdbms)?
What is indexing in sql server with example?
What is the difference between NOROW and LOCKROW?
How do you check sql server is up and running?
Explain activity monitors
What does ss stand for sexually?
How to view existing indexes on an given table using sp_help?
What are the steps to follow to configure SQL*Net?
