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 |
What are the steps you must follow to hide sql server instances?
What are acid properties of transaction?
What is after dml trigger?
What are sql server functions?
What is tablesample?
Tell about MOM Tool(Microsoft Operator Manager)?
Give me any three differences between Truncate and Delete.
Diffrent types of function
What’s the use of custom fields in report?
What is database normalization?
7 Answers Deloitte, Digicel, JPMorgan Chase, Verifone,
According to you what goes into making the best database administrator? : sql server database administration
how many type of subquery?
Oracle (3259)
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)