As a part of your job, what are the DBCC commands that you
commonly use for database maintenance?
Answer / swapna
DBCC CHECKDB, DBCC CHECKTABLE, DBCC CHECKCATALOG, DBCC
CHECKALLOC, DBCC SHOWCONTIG, DBCC SHRINKDATABASE, DBCC
SHRINKFILE etc.
| Is This Answer Correct ? | 5 Yes | 0 No |
can you any body tell me suppose database is suspect mode. how can take to normal?
What is a view in sql?
Distinguish between commit and rollback?
You want to implement the one-to-many relationship while designing tables. How would you do it?
write sql program to get the detail of student in a class?
How to create a view on an existing table in ms sql server?
How is sql server used?
What is the most common type of join?
ow to bring suspect mode datbase online from scratch
What is the contrast between sql and mysql?
What is optimization and its types?
What is the recovery model? List the types of recovery model available in sql server?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)