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 3740

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

 2015

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

 1 4638

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

 2638

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

STC,

1 4740

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

 1 6576

What is blocking and how would you troubleshoot it?

 1 6256

Explain CREATE DATABASE syntax?

 2 7762

How to start SQL Server in minimal configuration mode?

 1 7352

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

3 7725

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

 1 4959

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

 1 4328

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

 1 3921

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

TCS,

7 20376

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 10879

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

What is transparent data encryption? : sql server DBA

816

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

785

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2414

what is a crs resource?

869

What are the different types of database compression introduced in sql server 2008? : sql server DBA

821

how does an oracle clusterware manage crs resources?

785

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

2199

what is asm?

816

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

749

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

839

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?

2422

what is a user-defined lock?

773

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

1917

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

789

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.

1442

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