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 4283

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

2250

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

1 5310

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

2849

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

STC,

1 5292

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

1 7055

What is blocking and how would you troubleshoot it?

1 6746

Explain CREATE DATABASE syntax?

2 8636

How to start SQL Server in minimal configuration mode?

1 7970

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

3 8535

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

1 5441

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

1 4815

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

1 4444

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

TCS,

7 21621

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 11606

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

what is asm?

1048

what is logical system in sap basis

1640

how can you find out if a table can be redefined?

1012

Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

2167

how can you process messages in order asynchronously?

975

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?

2679

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?

2511

what is grd?

1095

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

1005

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

1023

How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

2094

What is dcl? : sql server DBA

1268

what functionality does oracle provide to secure sensitive information?

993

What is replication? : sql server DBA

1174

Explain about your sql server dba experience? : sql server DBA

1082

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