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

970

What is transparent data encryption? : sql server DBA

1132

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

1053

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

1065

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

997

What happens on checkpoint? : sql server DBA

1041

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

953

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

985

What is fill factor? : sql server DBA

1189

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

1096

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

1020

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

1059

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

1010

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

1119

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

1127

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

how can you implement fine-grained auditing?

1077

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

997

Why would you use sql agent? : sql server DBA

1028

what are the benefits of flashback feature?

966

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

943

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

1072

What happens on checkpoint? : sql server DBA

1041

can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

1710

What authentication modes does sql server support? : sql server DBA

1150

What is a correlated sub-query? : sql server DBA

1017

What is fill factor? : sql server DBA

1189

what is the role of dip user in our database?

2371

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

1038

how to restore files with rman?

2252

what are the types of connection load-balancing?

944

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