DB Administration Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

DB Administration Interview Questions

Questions Answers Views Company eMail

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

1110

Which autogrowth database setting is good? : sql server DBA

1163

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

1296

Where do you find the default index fill factor and how to change it? : sql server DBA

1082

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

1204

What are the different types of indexes available in sql server? : sql server DBA

1209

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

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

1216

What is dbcc? : sql server DBA

1297

What is dcl? : sql server DBA

1277

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

1051

How would you extract DDL of a table without using a GUI tool?

2492

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

1317

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

2414

how can you process messages in order asynchronously?

981

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

1135

What are the different types of indexes available in sql server? : sql server DBA

1209

what do you understand by fine-grained auditing?

1063

What are the recovery models for a database? : sql server DBA

1133

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

2159

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

2852

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

1084

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