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 3656

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

 1955

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

 1 4539

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

 2585

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

STC,

1 4655

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

 1 6493

What is blocking and how would you troubleshoot it?

 1 6175

Explain CREATE DATABASE syntax?

 2 7587

How to start SQL Server in minimal configuration mode?

 1 7245

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

3 7582

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

 1 4880

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

 1 4240

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

 1 3823

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

TCS,

7 20179

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 10713

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

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

1955

What is dbcc? : sql server DBA

939

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

1726

Why would you use sql agent? : sql server DBA

724

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.

1394




what is asm?

779

How would you best determine why your MVIEW couldn't FAST REFRESH?

2000

How do you troubleshoot errors in a sql server agent job? : sql server DBA

749

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2136

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

1883

what are the performance views in an oracle rac environment?

758

what is the use of recording information about current session?

742

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.

1876

What is replication? : sql server DBA

804

what is logical system in sap basis

1308

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