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 866

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

836

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

1 2067

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

1145

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

STC,

1 1849

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

1 4135

What is blocking and how would you troubleshoot it?

1 3701

Explain CREATE DATABASE syntax?

2 4294

How to start SQL Server in minimal configuration mode?

1 4142

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

3 3571

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

1 2679

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

1 1748

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

1 1714

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

TCS,

7 11550

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 6461


Post New DB Administration Questions


Un-Answered Questions { DB Administration }

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

1145


what is the last version,the release date of that version and fix pack of ibm db2 udb?

655


What is the recommended interval at which to run statspack snapshots, and why?

1039


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

603


how can you connect from 10g user to 11g user??

682


You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

1891


How to start SQL Server in minimal configuration mode?

4142


internal architecture

706


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

429


i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

651


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

619


Query processing is slow(eg select query)how will u solve that

3978


In oracle 10g export, import if we declare rows=y/n what would be the output?

1415


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.

635


currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

900