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 1901

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

1191

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

1 2928




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

1677

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

STC,

1 2897

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

1 4969

What is blocking and how would you troubleshoot it?

1 4554

Explain CREATE DATABASE syntax?

2 5247




How to start SQL Server in minimal configuration mode?

1 5317

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

3 4852

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

1 3328

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

1 2431

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

1 2312

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

TCS,

7 15128

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 8006


Post New DB Administration Questions






Un-Answered Questions { DB Administration }

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

2505


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

1672


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

1251


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

1312


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?

1262






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.

938


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

1601


How would you extract DDL of a table without using a GUI tool?

1303


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

876


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

1191


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

4766


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

2114


Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

1079


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

1017


How to start SQL Server in minimal configuration mode?

5317