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,

820

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

818

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

1 1979

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

1126

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

STC,

1 1652

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

1 4005

What is blocking and how would you troubleshoot it?

1 3526

Explain CREATE DATABASE syntax?

2 4086

How to start SQL Server in minimal configuration mode?

1 3996

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

3 3385

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

1 2607

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

1 1627

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

1 1650

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

TCS,

7 10978

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 6094


Post New DB Administration Questions


Un-Answered Questions { DB Administration }

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

921


what is the diffrence between core dba and apps dba?

865


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

1784


Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

699


which background process invoke at the time of upgradation tell me???

1102


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.

656


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

3865


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?

890


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

1396


How would you go about verifying the network name that the local_listener is currently using?

1564


How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

1055


Where would you look for errors from the database engine?

1398


I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

510


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

879


Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

702