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

DB Administration Interview Questions

Questions Answers Views Company eMail

What are the different sql server versions you have worked on? : sql server DBA

1014

What is transparent data encryption? : sql server DBA

1199

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

1115

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

1116

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

1050

What happens on checkpoint? : sql server DBA

1098

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

997

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

1027

What is fill factor? : sql server DBA

1254

What is the default port no on which sql server listens? : sql server DBA

1163

What is the difference between dropping a database and taking a database offline? : sql server DBA

1073

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

1122

What are the commands used in dcl? : sql server DBA

1076

What are the operating modes in which database mirroring runs? : sql server DBA

1189

What is a system database and what is a user database? : sql server DBA

1237

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

what do you understand by flashback feature of oracle?

995

Query processing is slow(eg select query)how will u solve that

7921

what is the role of dip user in our database?

2417

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

1134

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.

2568

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

1122

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

1975

what are the types of connection load-balancing?

1001

How do you open a cluster administrator? : sql server DBA

1108

Where would you look for errors from the database engine?

2858

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

4429

What are the recovery models for a database? : sql server DBA

1132

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

997

how can you process messages in order asynchronously?

977

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

3763

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