Can a UNION and a JOIN be used in the same SELECT statement
YES
NO
Cant say
Depends on the query
Bind component Produces
Only Package
Only application plan
Both A & B
None of the above
Where would the SQL error code (SQLSTATE/SQLCODE) be reported
in the SQLDA data structure
in the SQLCA data structure
in the DB configuration file
in the event monitor log
What does QMF stands for
Query Manager Facility
Query Management Factor
Query Management Facility
What does SQLCA stands for
SQL Communications Area
SQL Control Area
SQL Connection Area
SQL Control Access
What does DCLGEN stands for
Declaration General
Data Control Language Generator
DB2 Control Region
Declaration Generator
What does DB2I stands for
DB2 Interchange
DB2 Information
DB2 Intercative
DB2 Init
Which Database Services component manages the physical database
DBRM
Buffer Manager
Runtime Supervisor
Data Manager
A VIEW MAY NOT CONTAIN
INDICES
COLUMNS
ROWS
NONE OF THE ABOVE
TOTAL DATA CAPACITY IN TERADATA
64 GB PER AMP
120 GB PER AMP
32 GB PER AMP
16 GB PER AMP