Mainframe Micro-quiz: DB2 V8 |
 |
By Edward Hurley, Editor
28 Nov 2004 | Search390.com |
|
|
Crash Course: Rexx
So have you upgraded to DB2 Version 8 yet? Either way, I hope you enjoy
this new micro-quiz on DB2 V8. It will both test your knowledge and
provide additional resources you may find useful when contemplating an
upgrade or getting the most out of going to V8.
So are you using DB2 V8 yet? Or are you waiting? Let us know what your
upgrade plans are by clicking here.
 Table
of Contents |
|
 When did 31-bit addressing come
to DB2?
SQL bytes
Major security improvements in DB2 V8
DB2 V8
is not for more "mature" mainframes
Padded vs. non-padded indexes
When did 31-bit addressing come to DB2?
- A) 1979
- B) 1980
- C) 1981
- D) 1982
You can find the answer in this tip The
benefits and drawbacks of DB2 V8 by clicking here.
In DB2 V8, SQL statements can be how long?
- A) Up to 32,765 bytes
- B) Up to 65,530 bytes
- C) Up to 262,120 bytes
- D) up to 2,097,152 bytes
The answer can be found
in this tip: Hot DB2 features
There are some major security improvements in DB2 V8. One of the
biggest is
- A) Table level security
- B) Object level
- C) Row level security
- D) User level security
To find the answer, click here
to see DB2 V8 = better
security
The latest release of DB2 is not for shops that are running more
"mature" mainframes. Which of these statements is true?
- A) z/OS v1.4 or higher is needed to run DB2 V8
- B) DB2 V8 will run on OS/390 but not all functionality will be
available
- C) DB2 V8 will only run on zSeries machines running z/OS v1.3 or
higher
- D) Trick question! IBM always makes DB2 run on all versions when
unveiling a new release
You can find the answer here
in this tip What will be the impact
of DB2 V8?
What is the difference between a padded and non-padded index?
- A) Padded indexes has the same length so each column in an index
has fixed length
- B) Padded indexes have extra space so data integrity is conserved
- C) Non-padded indexes allow for longer indexes
- D) Trick question! There is no such thing as a non-padded index
To find the answer, read
this Q&A: IBM fellow on DB2 V8
for zSeries
|
|
|
|
