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

969

What is transparent data encryption? : sql server DBA

1130

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

1052

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

1065

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

995

What happens on checkpoint? : sql server DBA

1041

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

953

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

981

What is fill factor? : sql server DBA

1187

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

1095

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

1017

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

1057

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

1008

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

1117

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

1126

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

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

2587

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

1991

what functionality does oracle provide to secure sensitive information?

951

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

2405

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

1017

what is asm?

1005

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

2304

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

1204

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

1034

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

969

What is dcl? : sql server DBA

1197

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

1035

when does an alert gets signaled?

994

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

1007

Which autogrowth database setting is good? : sql server DBA

1078

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