What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
1115What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
1116What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
1050When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
997Due 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
1027What is the difference between dropping a database and taking a database offline? : sql server DBA
1073Post New DB Administration Questions
what do you understand by flashback feature of oracle?
Query processing is slow(eg select query)how will u solve that
what is the role of dip user in our database?
What is the default fill factor value? : sql server DBA
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.
How do you troubleshoot errors in a sql server agent job? : sql server DBA
what is the last version,the release date of that version and fix pack of ibm db2 udb?
what are the types of connection load-balancing?
How do you open a cluster administrator? : sql server DBA
Where would you look for errors from the database engine?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What are the recovery models for a database? : sql server DBA
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
how can you process messages in order asynchronously?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?