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 4271

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

2240

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

1 5295

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

2843

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

STC,

1 5276

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

1 7046

What is blocking and how would you troubleshoot it?

1 6732

Explain CREATE DATABASE syntax?

2 8616

How to start SQL Server in minimal configuration mode?

1 7953

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

3 8521

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

1 5430

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

1 4803

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

1 4436

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

TCS,

7 21606

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 11591

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

2457

What purpose does the model database server? : sql server DBA

1175

when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

1721

What the different topologies in which replication can be configured? : sql server DBA

1259

Explain materialized views and how they are used.

2436

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

988

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

2712

What is the importance of a recovery model? : sql server DBA

1021

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

985

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.

1989

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.

2162

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?

2674

What is transparent data encryption? : sql server DBA

1186

What is the difference between dropping a database and taking a database offline? : sql server DBA

1057

How can you control the amount of free space in your index pages? : sql server DBA

1304

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