Answer Posted / rajesh naidu
INDEX IS USED TO IMPROVE THE PERFORMANCE OF THE DATABASE AND
ALSO IT IS USE FULL FOR FASTER FETCHING THE REQUIRED DATA
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is fill factor? : sql server DBA
what is the diffrence between core dba and apps dba?
Explain materialized views and how they are used.
what is grd?
What is replication? : sql server DBA
how can you generate profile of pl/sql applications to identify performance bottlenecks?
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
What are the commands used in dcl? : sql server DBA
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?