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

963

What is transparent data encryption? : sql server DBA

1114

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

1043

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

1053

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

986

What happens on checkpoint? : sql server DBA

1031

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

949

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

972

What is fill factor? : sql server DBA

1181

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

1083

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

1012

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

1050

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

994

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

1105

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

1112

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

what are the performance views in an oracle rac environment?

1000

what is the diffrence between core dba and apps dba?

2510

what functionality does oracle provide to secure sensitive information?

941

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

1004

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

1064

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

how can you find out if a table can be redefined?

961

what are the differences of where and if in SAS?

2133

what are the types of connection load-balancing?

937

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2404

what is asm?

994

what is ora 24313?what is the procedure to exclude that error?

2518

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

2275

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

2397

what is grd?

1047

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