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

1076

What is dcl? : sql server DBA

1184

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

1023

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

937

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

1058

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

1136

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

1149

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

997

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

1022

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

1028

What is dbcc? : sql server DBA

1216

Why would you use sql agent? : sql server DBA

1016

What is replication? : sql server DBA

1102

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

1223

Why would you call update statistics? : sql server DBA

947

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

what are the benefits of flashback feature?

954

how can you create a user-defined lock?

959

What is transparent data encryption? : sql server DBA

1114

what is grd?

1047

How can you control the amount of free space in your index pages? : sql server DBA

1232

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

2879

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

1096

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

994

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

2397

How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

2446

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

1004

what do you understand by fine-grained auditing?

1014

what do you understand by flashback feature of oracle?

946

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

1187

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

963

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