DB Administration Interview Questions
Questions Answers Views Company eMail

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

IBM,

1 3562

What are statistics, under what circumstances they go out of date, how do you update them?

1915

What is RAID and what are different types of RAID configurations?

1 4477

What are the steps you will take to improve performance of a poor performing query?

2546

What are the steps you will take, if you are tasked with securing an SQL Server?

STC,

1 4556

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

1 6431

What is blocking and how would you troubleshoot it?

1 6116

Explain CREATE DATABASE syntax?

2 7400

How to start SQL Server in minimal configuration mode?

1 7157

What are the different ways of moving data or databases between servers and databases in SQL Server?

3 7463

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1 4810

What is database replicaion? What are the different types of replication you can set up in SQL Server?

1 4153

How to determine the service pack currently installed on SQL Server?

1 3742

Explain the difference between a hot backup and a cold backup and the benefits associated with each?

TCS,

7 19954

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

3 10613


Post New DB Administration Questions

Un-Answered Questions { DB Administration }

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

622


What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

673


Where do you find the default index fill factor and how to change it? : sql server DBA

702


what is the diffrence between core dba and apps dba?

2227


What is the importance of a recovery model? : sql server DBA

682






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.

1842


Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

1675


Where would you look for errors from the database engine?

2486


What are the commands you'd issue to show the explain plan for "select * from dual"?

1844


how to restore files with rman?

1867


What are statistics, under what circumstances they go out of date, how do you update them?

1915


how does an oracle clusterware manage crs resources?

684


Can you redefine a table online?

801


what is the use of recording information about current session?

686


how can you initialize log miner?

721