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.?
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 |
How to select the duplicate rows from a table?
What is db2 optimizer?
What is a host variable?
How can deadlocks be resolved?
When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing?
What do you mean by NOT NULL WITH DEFAULT? When will you use it?
What techniques are used to retrieve data from more than one table in a single SQL statement?
what is the use of cursors?
wt is view ? wht r the restrictions for view ?
how can u nderstand the sql stmts executed successfully or not ?
What types of tables are there in the db2 database?
What information can you find in SYSIBM.SYSLINKS table?