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 does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?
Q4. How will you get the count of record without using COUNT verb in query?
how to unload different table data into different gdg files/ vsam files.
what is db2 restart?
How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?
How do I delete a table in database?
What is the result of open cursor statement?
What is consistency token in db2?
What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?
how do u update the faltfile into db2 table ?
4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?