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

765

What is transparent data encryption? : sql server DBA

791

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

776

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

826

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

793

What happens on checkpoint? : sql server DBA

780

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

779

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

784

What is fill factor? : sql server DBA

889

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

836

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

809

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

802

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

779

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

857

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

827

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

Which autogrowth database setting is good? : sql server DBA

761

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

816

what is the role of dip user in our database?

2227

What happens on checkpoint? : sql server DBA

780

how to restore files with rman?

1957

what are the performance views in an oracle rac environment?

807

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

788

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

7178

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

2420

how can a session indicate its interest in receiving alerts?

778

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?

2410

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

793

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1719

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

836

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

2170

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