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


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB Administration Interview Questions

Can you take Online Backups if the the database is running in NOARCHIVELOG mode? 5. How do you bring the database in ARCHIVELOG mode from NOARCHIVELOG mode? 6. You cannot shutdown the database for even some minutes, then in which mode you should run the database?

11 Answers   FA, GE, Wipro,


when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

0 Answers  


how can you process messages in order asynchronously?

0 Answers   Oracle,


how to restore files with rman?

0 Answers  


How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

0 Answers  






what is the difference between db2start command and start database manager command?

1 Answers  


What are the steps you will take to improve performance of a poor performing query?

0 Answers  


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

3 Answers   TCS,


What would you do with an "in-doubt" distributed transaction?

0 Answers  


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

0 Answers  


Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

0 Answers  


deleted of control file how will u recover control file?

4 Answers   CTS,


Categories