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 1008

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

849

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

1 2167




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

1171

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

STC,

1 1986

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

1 4233

What is blocking and how would you troubleshoot it?

1 3810

Explain CREATE DATABASE syntax?

2 4434




How to start SQL Server in minimal configuration mode?

1 4256

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

3 3743

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

1 2747

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

1 1848

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

1 1786

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

TCS,

7 12029

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 6705


Post New DB Administration Questions






Un-Answered Questions { DB Administration }

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

597


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

477


what is ora 24313?what is the procedure to exclude that error?

988


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.

713


What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

1089


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

922


How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

852


Explain materialized views and how they are used.

730


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.

742


In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

1196


Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

1218


. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

971


What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

925


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

676


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

1159