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 1139

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

865

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

1 2285




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

1187

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

STC,

1 2104

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

1 4343

What is blocking and how would you troubleshoot it?

1 3942

Explain CREATE DATABASE syntax?

2 4549




How to start SQL Server in minimal configuration mode?

1 4372

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

3 3916

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

1 2819

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

1 1909

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

1 1865

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

TCS,

7 12394

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 6904


Post New DB Administration Questions






Un-Answered Questions { DB Administration }

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

2019


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

750


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

692


Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

560


In what script is "snap$" created? In what script is the "scott/tiger" schema created?

1060


Why does Oracle not permit the use of PCTUSED with indexes?

1320


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

649


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

1703


What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

925


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

1187


Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

900


You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

708


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?

950


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

4210


. 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?

989