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
what do you understand by fine-grained auditing?
What is dcl? : 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?
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
What is the default fill factor value? : sql server DBA
How would you best determine why your MVIEW couldn't FAST REFRESH?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What are statistics, under what circumstances they go out of date, how do you update them?
What is the default port no on which sql server listens? : sql server DBA
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
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
how can you implement fine-grained auditing?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA