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

1013

What is transparent data encryption? : sql server DBA

1194

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

1111

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

1111

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

1046

What happens on checkpoint? : sql server DBA

1095

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

994

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

1024

What is fill factor? : sql server DBA

1249

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

1162

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

1068

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

1116

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

1072

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

1188

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

1231

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

what are the performance views in an oracle rac environment?

1055

when does an alert gets signaled?

1052

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

1162

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

1231

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2043

what are the benefits of flashback feature?

1024

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

2680

Query processing is slow(eg select query)how will u solve that

7912

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

2113

who owns the operating system files created by the utl_file package?

1074

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

2036

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

1210

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

1111

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

1314

what do you understand by flashback feature of oracle?

995

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