DB Administration Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

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 4177

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

2202

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

1 5167

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

2796

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

STC,

1 5179

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

1 6960

What is blocking and how would you troubleshoot it?

1 6647

Explain CREATE DATABASE syntax?

2 8490

How to start SQL Server in minimal configuration mode?

1 7828

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

3 8385

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

1 5347

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

1 4720

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

1 4353

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

TCS,

7 21377

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 11465

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

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?

2458

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

942

what is the role of dip user in our database?

2369

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

2623

how can you get actual data change values from previous transactions in oracle?

1045

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.

2105

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

2067

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

2373

What is the difference between clustered and non-clustered index? : sql server DBA

1033

What authentication modes does sql server support? : sql server DBA

1146

How do you open a cluster administrator? : sql server DBA

1043

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

953

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

2382

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

2024

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

2667

For More Un-Answered { DB Administration } Questions Click Here