As a part of your job, what are the DBCC commands that you commonly use for database maintenance?
IBM,
1 4185What are the different ways of moving data or databases between servers and databases in SQL Server?
3 8395Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
1 5349What is database replicaion? What are the different types of replication you can set up in SQL Server?
1 4725Explain the difference between a hot backup and a cold backup and the benefits associated with each?
TCS,
7 21388You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?
3 11475Post New DB Administration Questions
What are the steps you will take to improve performance of a poor performing query?
how can you communicate with operating system files from oracle?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
how can you schedule a job in database?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
how can you get actual data change values from previous transactions in oracle?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
What purpose does the model database server? : sql server DBA
What is a system database and what is a user database? : sql server DBA
What is fill factor? : sql server DBA
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 would you do with an "in-doubt" distributed transaction?
What is transparent data encryption? : sql server DBA
Which autogrowth database setting is good? : sql server DBA
what do you understand by fine-grained auditing?