This Content Component encountered an error
Get started Bring yourself up to speed with our introductory content.

Mainframe Micro-quiz: DB2 V8

Check out 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 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 adressing come to DB2?
 Return to Table of Contents

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.

 

  SQL bytes
 Return to Table of Contents


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

 

  Major security improvements in DB2 V8
 Return to Table of Contents

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

 

 

  DB2 V8 is not for more "mature" mainframes
 Return to Table of Contents

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?

 

  Padded vs. non-padded indexes
 Return to Table of Contents

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


 

This was last published in November 2004
This Content Component encountered an error

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchWindowsServer

SearchServerVirtualization

SearchCloudComputing

Close