DB Administration Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

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 4374

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

2312

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

1 5455

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

2902

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

STC,

1 5395

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

1 7136

What is blocking and how would you troubleshoot it?

1 6849

Explain CREATE DATABASE syntax?

2 8758

How to start SQL Server in minimal configuration mode?

1 8093

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

3 8668

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

1 5528

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

1 4893

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

1 4539

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

TCS,

7 21881

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 11739

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

What is transparent data encryption? : sql server DBA

1253

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

2350

Which autogrowth database setting is good? : sql server DBA

1245

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

2414

What is replication? : sql server DBA

1239

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

2502

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.

2618

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?

2041

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

4411

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2687

how can you enable flashback feature?

1010

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

1137

What is the default fill factor value? : sql server DBA

1184

How do you troubleshoot errors in a sql server agent job? : sql server DBA

1167

how does an oracle clusterware manage crs resources?

1141

For More Un-Answered { DB Administration } Questions Click Here