1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category
DB Administration Interview Questions
Questions Answers Views Company eMail

What are the different ways you can create databases in sql server? : sql server DBA

 601

What is dcl? : sql server DBA

 654

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

 549

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

 552

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

 576

What authentication modes does sql server support? : sql server DBA

 703

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

 686

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

 542

Explain about your sql server dba experience? : sql server DBA

 551

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

 605

What is dbcc? : sql server DBA

 779

Why would you use sql agent? : sql server DBA

 582

What is replication? : sql server DBA

 630

What types of replication are supported in sql server? : sql server DBA

 605

Why would you call update statistics? : sql server DBA

 582

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

What is dbcc? : sql server DBA

779

suppose you want to audit specific activities on sensitive data. How can you achieve that?

551

what is asm?

615

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

597

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

565




Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

3316

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

565

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

518

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1501

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

1977

what is a user-defined lock?

590

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?

2037

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

1848

how can you record information about current session?

497

What is the importance of a recovery model? : sql server DBA

557

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