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 4284

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

2252

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

1 5311

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

2849

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

STC,

1 5296

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

1 7056

What is blocking and how would you troubleshoot it?

1 6747

Explain CREATE DATABASE syntax?

2 8640

How to start SQL Server in minimal configuration mode?

1 7973

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

3 8537

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

1 5441

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

1 4818

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

1 4445

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

TCS,

7 21622

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 11610

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

What happens on checkpoint? : sql server DBA

1095

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?

2814

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

3761

How would you extract DDL of a table without using a GUI tool?

2489

What the different components in replication and what is their use? : sql server DBA

1051

How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

2502

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

2412

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

2513

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.

1729

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

1008

What are the recovery models for a database? : sql server DBA

1132

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.

2168

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?

2680

What is fill factor? : sql server DBA

1250

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

1046

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