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 1092

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

857

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

1 2236




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

1181

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

STC,

1 2052

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

1 4288

What is blocking and how would you troubleshoot it?

1 3883

Explain CREATE DATABASE syntax?

2 4506




How to start SQL Server in minimal configuration mode?

1 4323

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

3 3830

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

1 2792

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

1 1886

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

1 1840

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

TCS,

7 12209

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 6815


Post New DB Administration Questions






Un-Answered Questions { DB Administration }

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

987


Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

878


How to start SQL Server in minimal configuration mode?

4323


Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

615


You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1256


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

1236


Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

579


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

1051


internal architecture

770


what is the role of dip user in our database?

1046


What are the commands you'd issue to show the explain plan for "select * from dual"?

642


How would you go about verifying the network name that the local_listener is currently using?

1685


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.

423


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

2173


what is the last version,the release date of that version and fix pack of ibm db2 udb?

682