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 1789

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

1129

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

1 2841




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

1591

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

STC,

1 2775

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

1 4881

What is blocking and how would you troubleshoot it?

1 4464

Explain CREATE DATABASE syntax?

2 5164




How to start SQL Server in minimal configuration mode?

1 5176

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

3 4672

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

1 3254

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

1 2358

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

1 2241

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

TCS,

7 14690

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 7818


Post New DB Administration Questions






Un-Answered Questions { DB Administration }

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

1274


Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1043


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

1154


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?

1500


What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

1419






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

793


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.

619


Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

983


what are the differences of where and if in SAS?

957


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

4674


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

1180


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

2528


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

1213


I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

802


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

1300