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

1007

What is transparent data encryption? : sql server DBA

1186

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

1098

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

1104

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

1031

What happens on checkpoint? : sql server DBA

1086

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

983

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

1012

What is fill factor? : sql server DBA

1240

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

1148

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

1057

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

1108

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

1066

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

1177

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

1215

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

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

1042

Which autogrowth database setting is good? : sql server DBA

1146

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

1118

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

1192

What are the steps you will take to improve performance of a poor performing query?

2843

how can you implement fine-grained auditing?

1120

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

2538

What is dcl? : sql server DBA

1254

how can you enable flashback feature?

943

What are the different types of database compression introduced in sql server 2008? : sql server DBA

1095

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

1215

what is a crs resource?

1160

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

2351

Where would you look for errors from the database engine?

2846

What is dbcc? : sql server DBA

1280

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