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 1187

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

873

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

1 2346




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

1221

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

STC,

1 2177

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

1 4387

What is blocking and how would you troubleshoot it?

1 3985

Explain CREATE DATABASE syntax?

2 4586




How to start SQL Server in minimal configuration mode?

1 4421

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

3 3946

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

1 2849

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

1 1936

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

1 1890

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

TCS,

7 12598

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 6961


Post New DB Administration Questions






Un-Answered Questions { DB Administration }

Where would you look for errors from the database engine?

1477


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

570


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

1009


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

597


i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

713


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

2205


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

702


Why does Oracle not permit the use of PCTUSED with indexes?

1352


Explain materialized views and how they are used.

791


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

1727


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.

779


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

610


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

937


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.

747


How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

921