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 4263

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

2238

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

1 5286

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 5273

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

1 7045

What is blocking and how would you troubleshoot it?

1 6727

Explain CREATE DATABASE syntax?

2 8607

How to start SQL Server in minimal configuration mode?

1 7942

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

3 8509

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

1 5425

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

1 4796

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

1 4434

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

TCS,

7 21590

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 11585

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

how to restore files with rman?

2293

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

2325

how can you record information about current session?

1038

What are the different ways you can create databases in sql server? : sql server DBA

1123

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

2262

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

1188

what do you understand by flashback feature of oracle?

983

What is a system database and what is a user database? : sql server DBA

1206

what do you understand by fine-grained auditing?

1049

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

997

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

4421

How to start SQL Server in minimal configuration mode?

7942

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

982

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

2102

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?

3401

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