As a part of your job, what are the DBCC commands that you
commonly use for database maintenance?
- 1 Answers
- 3287 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / irimi
DBCC commands are most useful for performance and troubleshooting
PROCCACHE
SHOW_STATISTICS
TRACESTATUS
SHOWCONTIG
....
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the importance of a recovery model? : sql server DBA
what are the types of connection load-balancing?
How do you trace the traffic hitting a sql server? : sql server DBA
What the different types of replication and why are they used? : sql server DBA
internal architecture
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
how can you enable flashback feature?
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
What is dcl? : sql server DBA
when does an alert gets signaled?
How would you best determine why your MVIEW couldn't FAST REFRESH?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
Explain about your sql server dba experience? : sql server DBA
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
