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 ways you can create databases in sql server? : sql server DBA

1139

What is dcl? : sql server DBA

1269

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

1091

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

1005

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

1128

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

1217

What are the different types of upgrades that can be performed in sql server? : sql server DBA

1210

What the different components in replication and what is their use? : sql server DBA

1051

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

1083

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

1077

What is dbcc? : sql server DBA

1286

Why would you use sql agent? : sql server DBA

1084

What is replication? : sql server DBA

1176

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

1297

Why would you call update statistics? : sql server DBA

991

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

995

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

1268

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

1087

Which autogrowth database setting is good? : sql server DBA

1156

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

2360

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

1760

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

1288

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

2636

when does an alert gets signaled?

1052

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

2203

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

1190

Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

2168

how can you process messages in order asynchronously?

976

What is dcl? : sql server DBA

1269

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

1068

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