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

1071

What is transparent data encryption? : sql server DBA

1253

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

1166

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

1187

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

1094

What happens on checkpoint? : sql server DBA

1146

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

1048

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

1079

What is fill factor? : sql server DBA

1309

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

1224

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

1111

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

1167

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

1133

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

1242

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

1318

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

What purpose does the model database server? : sql server DBA

1273

What happens on checkpoint? : sql server DBA

1146

What the different topologies in which replication can be configured? : sql server DBA

1319

What are the different types of indexes available in sql server? : sql server DBA

1270

What is the importance of a recovery model? : sql server DBA

1083

suppose you want to audit specific activities on sensitive data. How can you achieve that?

1059

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.

2044

What types of replication are supported in sql server? : sql server DBA

1357

what do you understand by fine-grained auditing?

1108

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

2614

what is the role of dip user in our database?

2464

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

1133

What is the difference between clustered and non-clustered index? : sql server DBA

1148

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

2414

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

2499

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