Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / mathavan
Indexes are used for faster access of required data in a
large table.
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
What happens on checkpoint? : sql server DBA
what is the use of ocr?
how can you process messages in order asynchronously?
Explain materialized views and how they are used.
What is dcl? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
What is a system database and what is a user database? : sql server DBA
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What is the importance of a recovery model? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
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
how can you connect from 10g user to 11g user??
