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 4286

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

2254

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

1 5314

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

2850

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

STC,

1 5300

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

1 7057

What is blocking and how would you troubleshoot it?

1 6752

Explain CREATE DATABASE syntax?

2 8648

How to start SQL Server in minimal configuration mode?

1 7977

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

3 8551

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

1 5444

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

1 4823

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

1 4449

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

TCS,

7 21634

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 11615

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

how can you generate profile of pl/sql applications to identify performance bottlenecks?

1082

what is the diffrence between core dba and apps dba?

2573

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?

1985

what is a user-defined lock?

1070

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

1909

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

2440

What the different types of replication and why are they used? : sql server DBA

1178

What are the commands you'd issue to show the explain plan for "select * from dual"?

2233

how can you implement fine-grained auditing?

1139

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

4353

what is ora 24313?what is the procedure to exclude that error?

2570

Explain materialized views and how they are used.

2444

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

1122

Explain about your sql server dba experience? : sql server DBA

1091

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.

2283

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