Which of the following DB2 objects is NOT considered executable using SQL?
Routine
Function
Procedure
Trigger
Which of the following is a valid DB2 data type?
NUMBER
INTERVAL
NUM
BYTE
Which of the following DB2 data types can NOT be used to create an identity column?
SMALLINT
INTEGER
DOUBLE
NUMERIC
Which of the following actions will NOT cause a trigger to be fired?
ALTER
INSERT
DELETE
UPDATE
What command eliminates the duplicates.
union
union all
inner join
outer join
What is the utility used to check the performance of the DB2 SQL query
Explain
Xpeditor
Alchemist
Abendaid
A plan is a collection of
Binds
DBRMs
Packages
Collections
The number of levels of subqueries we could use in the SQL is
13
255
78
15
The utility used to rearrange the space in the tables is
Reorg
Runstats
Rebinds
Load
Which is not a type of constraint
primary key
unique
null
check