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 1829

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

1155

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

1 2875




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

1612

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

STC,

1 2817

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

1 4913

What is blocking and how would you troubleshoot it?

1 4499

Explain CREATE DATABASE syntax?

2 5192




How to start SQL Server in minimal configuration mode?

1 5232

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

3 4739

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

1 3285

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

1 2385

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

1 2273

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

TCS,

7 14843

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 7889


Post New DB Administration Questions






Un-Answered Questions { DB Administration }

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

942


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?

913


what is the diffrence between core dba and apps dba?

1275


Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

1137


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

1476






Where would you look for errors from the database engine?

1709


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

898


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

856


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

1221


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

1727


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.

914


How would you best determine why your MVIEW couldn't FAST REFRESH?

1170


what is logical system in sap basis

433


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?

2307


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

986