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,

824

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

823

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

1 1989

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

1130

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

STC,

1 1701

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

1 4048

What is blocking and how would you troubleshoot it?

1 3588

Explain CREATE DATABASE syntax?

2 4131

How to start SQL Server in minimal configuration mode?

1 4040

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

3 3440

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

1 2621

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

1 1662

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

1 1661

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

TCS,

7 11145

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 6195


Post New DB Administration Questions


Un-Answered Questions { DB Administration }

how can you connect from 10g user to 11g user??

657


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

823


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

850


In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

1110


Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

509


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

928


Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

822


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

857


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

609


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?

1155


You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

648


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.

381


. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

913


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?

895


In oracle 10g export, import if we declare rows=y/n what would be the output?

1403