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

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

 533

What is transparent data encryption? : sql server DBA

 556

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

 546

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

 602

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

 580

What happens on checkpoint? : sql server DBA

 555

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

 551

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

 570

What is fill factor? : sql server DBA

 635

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

 546

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

 568

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

 554

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

 567

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

 598

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

 591

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..?

1734

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

544

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

1738

how can you create a user-defined lock?

577

what is the use of ocr?

586




How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

1647

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

572

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

1833

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

2049

How would you go about verifying the network name that the local_listener is currently using?

2747

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

2381

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

696

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

6485

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

589

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

546

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