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
- 6408 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between dbm cfg and db cfg file in db2 ?
Comment whether the cursor is closed during commit or not.
What is declare cursor?
What is db2 purescale?
What are union and union all?
Mention the location where the output received from explain statement is stored.
What is the physical storage length of timestamp data type?
What is package in db2 mainframe?
How would the varchar column remarks defined?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
Which is faster delete or truncate?
Can you use max on a char column?
What are the various data types available in db2?
What is iseries database?
Define db2.
