As a part of your job, what are the DBCC commands that you commonly use for database maintenance?
IBM,
1 3562What are the different ways of moving data or databases between servers and databases in SQL Server?
3 7463Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
1 4810What is database replicaion? What are the different types of replication you can set up in SQL Server?
1 4153Explain the difference between a hot backup and a cold backup and the benefits associated with each?
TCS,
7 19954You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?
3 10613Post New DB Administration Questions
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
Where do you find the default index fill factor and how to change it? : sql server DBA
what is the diffrence between core dba and apps dba?
What is the importance of a recovery model? : sql server DBA
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
Where would you look for errors from the database engine?
What are the commands you'd issue to show the explain plan for "select * from dual"?
how to restore files with rman?
What are statistics, under what circumstances they go out of date, how do you update them?
how does an oracle clusterware manage crs resources?
Can you redefine a table online?
what is the use of recording information about current session?
how can you initialize log miner?