Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / nikhil
Global Index: A global index is a one-to-many relationship,
allowing one index partition to map to many table
partitions. A global index can only be a range partition!
Local Index: A local index is a one-to-one mapping between a
index partition and a table partition. In general, local
indexes allow for a cleaner “divide and conquer” approach
for generating fast SQL execution plans with partition pruning.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
. 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?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
What the different components in replication and what is their use? : sql server DBA
what is grd?
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 are the types of connection load-balancing?
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.
What are the different ways you can create databases in sql server? : sql server DBA
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?
how can you schedule a job in database?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
what is a crs resource?
What is a correlated sub-query? : sql server DBA
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
Explain about your sql server dba experience? : sql server DBA
