Sign Up Login


  1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category
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 3714

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

 1997

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

 1 4608

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

 2626

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

STC,

1 4716

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

 1 6548

What is blocking and how would you troubleshoot it?

 1 6230

Explain CREATE DATABASE syntax?

 2 7708

How to start SQL Server in minimal configuration mode?

 1 7321

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

3 7680

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

 1 4931

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

 1 4299

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

 1 3891

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

TCS,

7 20331

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 10829

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

What happens on checkpoint? : sql server DBA

776

What are the different types of indexes available in sql server? : sql server DBA

807

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

909

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

818

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

1904

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

807

what are the differences of where and if in SAS?

1886

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

799

what is asm?

806

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?

2407

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

7176

What are the different types of upgrades that can be performed in sql server? : sql server DBA

904

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

2177

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

3490

What is transparent data encryption? : sql server DBA

783

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