DB2 - 5 Flashcards
To facilitate the restoration or logical recovery of a database system, the database server generates a consistency point, called a:
Dead lock
Checkpoint
Ziplock
Live lock
Checkpoint
On a data partitioned table, you can reorganize a specific nonpartitioned index on a partitioned table.
True or False?
True
False
True
The RUNSTATS command updates statistics in the system catalog about the characteristics of a :
Java Virtual Machine
Python thread
Table, associated indexes, or statistical views
ISAM file
Table, associated indexes, or statistical views
What would be a real-world use case for Table Partitioning?
VSAM blows up
The amount of rows in a table is affecting query performance.
File is on Tape
Fortran compiler is not available
The amount of rows in a table is affecting query performance.
A schema is a collection of:
Named objects classified logically in the database.
Really old programming languages
Unblocked structures
Memory allocated
Named objects classified logically in the database.
A table space is a storage structure. It contains:
Cobol Data Division
Fortran77 READ Statements
Tables, indexes, large objects, and long data.
Primos Operating System
Tables, indexes, large objects, and long data.
REPORT provides information about table spaces, tables, and indexes that is useful for recovery.
True or False?
True
False
True
A set of Storage paths to store a database table or objects is a storage group.
True or False?
True
False
True
The RECOVER DATABASE command restores and rolls forward a database to a particular point in time.
True or False?
True
False
True
Why would you use the REORG utility?
Ensure that the data is available in WORKING STORAGE
Ensure that the data is written to the heap
Ensure that the data is seen by ZOS
Ensure that the data is situated in an optimal fashion for subsequent access.
Ensure that the data is situated in an optimal fashion for subsequent access.
