Which of the following utilities CANNOT be executed from the DB2 utilities panel in DB2I?
A. COPY
B. REORG
C. STOSPACE
D. BACKUP SYSTEM
Given the following CREATE VIEW statement and sample data; your login id is "ROGER". What will be the result for this query?
A. 6
B. 5
C. 4
D. 2
Given the tables:
Which SQL statement would join the tables on product number (prod#) and provide a table of what products (product), if any, the parts (part) are used? Limit the result to only parts where suppliers (supplier) do not start with the letter A.
A. B.
C. D.
The maximum size for each partition of a partition-by-range table space, with fewer than 255 partitions, is determined by which combination of options? (Choose two.)
A. DSSIZE
B. PRIQTY
C. NUMPARTS
D. BUFFERPOOL
E. MAXPARTITIONS
Which of the following statements about a system-period temporal table is TRUE?
A. Rows can be archived into a history table which is always read only
B. Every row has a pair of timestamps which is set and managed by the application
C. AN SQL query for auditing can be run against current data or history data, but not both
D. The table contains only the current active rows
Which statement is TRUE regarding catalog table SYSIBM.SYSROUTINES?
A. Contains scheduled tasks for the administrative scheduler
B. Contains information about UDFs, BIFs and stored procedures
C. Contains information about bound packages
D. Contains information about UDFs and stored procedures
Which type of index will cause DB2 to store the data in a given physical order?
A. UNIQUE
B. PRIMARY
C. CLUSTER
D. PARTITIONED
In order to evaluate the real-time relative disorganization of an index, which catalog table would you query?
A. SYSIBM.SYSINDEXES
B. SYSIBM.SYSINDEXPART
C. SYSIBM.SYSINDEXSTATS
D. SYSIBM.SYSINDEXSPACESTATS
Which of the following statements will create an application-period temporal table?
A. B. C. D.
Which SQL statement supports an insert or an update in a single SQL statement?
A. MERGE
B. UPSERT
C. UPDATE or INSERT INTO ...
D. INSERT INTO table ... ON DUPLICATE KEY ...
