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

1146

What is dcl? : sql server DBA

1277

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

1092

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

1012

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

1135

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

1220

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

1216

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

1055

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

1095

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

1082

What is dbcc? : sql server DBA

1297

Why would you use sql agent? : sql server DBA

1092

What is replication? : sql server DBA

1182

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

1302

Why would you call update statistics? : sql server DBA

994

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

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.

2570

how can you schedule a job in database?

1130

what are the performance views in an oracle rac environment?

1057

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

2362

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

1192

What happens on checkpoint? : sql server DBA

1099

How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

2099

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

1016

What is replication? : sql server DBA

1182

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

1082

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

1031

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

1110

what are the types of connection load-balancing?

1002

Why does Oracle not permit the use of PCTUSED with indexes?

2947

what is a user-defined lock?

1071

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