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 log shipping?
what is database replication? : Sql server database administration
Explain ranking functions?
can an automatic recovery be initiated by a user? : Sql server administration
Can a table be moved to different filegroup?
What is an sql server agent?
What is a collation?
How many types of keys are there?
How will you know when statistics on a table are obsolete?
what purpose does the model database serve? : Sql server database administration
How to optimize stored procedure optimization?
How do I find the sql server database version?
What are types of storage modes? : sql server analysis services, ssas
Can we call future method from queueable?
What is read committed?
