As a part of your job, what are the DBCC commands that you commonly use for database maintenance?
IBM,
1 4177What are the different ways of moving data or databases between servers and databases in SQL Server?
3 8386Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
1 5347What is database replicaion? What are the different types of replication you can set up in SQL Server?
1 4720Explain the difference between a hot backup and a cold backup and the benefits associated with each?
TCS,
7 21378You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?
3 11465Post New DB Administration Questions
What is replication? : sql server DBA
Query processing is slow(eg select query)how will u solve that
what are the benefits of flashback feature?
What is transparent data encryption? : sql server DBA
what are the performance views in an oracle rac environment?
What are statistics, under what circumstances they go out of date, how do you update them?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What is the default fill factor value? : sql server DBA
which background process invoke at the time of upgradation tell me???
How would you best determine why your MVIEW couldn't FAST REFRESH?
What purpose does the model database server? : sql server DBA
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
What is the difference between dropping a database and taking a database offline? : sql server DBA
What is a system database and what is a user database? : sql server DBA