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,

828

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

830

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

1 2008

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

1136

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

STC,

1 1742

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

1 4082

What is blocking and how would you troubleshoot it?

1 3628

Explain CREATE DATABASE syntax?

2 4189

How to start SQL Server in minimal configuration mode?

1 4078

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

3 3485

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

1 2636

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

1 1692

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

1 1678

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

TCS,

7 11281

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 6282


Post New DB Administration Questions


Un-Answered Questions { DB Administration }

what are the differences of where and if in SAS?

663


Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

825


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

643


internal architecture

685


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

503


I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

2575


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

1136


Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

628


. 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?

924


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

1408


How to start SQL Server in minimal configuration mode?

4078


what is the diffrence between core dba and apps dba?

882


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

786


How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

576


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

1119