Interested to Buy Any Domain ? << Click Here >> for more details...
which is the most efficient tablespace??
a.simple tablespace.
b.partitioned tablespace.
c.segmented tablespace.
d.none of the above.
please post answer with the reason.?
- 3 Answers
- 6249 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / jaydeep c
C. Segmented tablespace.
Because the sequential access to a particular table is more
efficient and the mass delete is much more efficient than any
other tablespace.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / jaydeep c
C. Segmented tablespace.
Because the sequential access to a particular table is more
efficient and the mass delete is much more efficient than any
other tablespace.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is copy pending and check pending in db2?
When Can you be sure that a query will return only one row?
What are some SQL aggregates and other built-in functions?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
How to take backup of table in db2?
What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?
what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx
AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE
What is difference between isnull and coalesce?
How to find the number of rows in db2 tables?
How does DB2 determine what lock-size to use?
What is a precompiler?
COBOL 
