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 952

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

841

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

1 2121




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

1155

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

STC,

1 1938

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

1 4187

What is blocking and how would you troubleshoot it?

1 3771

Explain CREATE DATABASE syntax?

2 4377




How to start SQL Server in minimal configuration mode?

1 4206

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

3 3662

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

1 2719

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

1 1802

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

1 1752

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

TCS,

7 11827

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 6623


Post New DB Administration Questions






Un-Answered Questions { DB Administration }

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

708


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

1267


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

561


You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

1938


Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

1041


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.

736


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

1653


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

572


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?

676


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

890


Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

576


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

962


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.

726


How to start SQL Server in minimal configuration mode?

4206


how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

1964