Free DB2 11 Fundamentals for z/OS C2090-320 Exam Practice Test

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.)

• DSSIZE
  
• PRIQTY
  
• NUMPARTS
  
• BUFFERPOOL
  
• MAXPARTITIONS
  

Which of the following statements will create an application-period temporal table?

• CREATE TABLE POLICY_ATT(BANK VARCHAR(4). SYS_BEGIN TIMESTAMP. SYS_END TIMESTAMP, CLIENT CHAR(4), TYPE CHAR(5), PAY INT, PERIOD SYSTEM_TIME(SYS_BEGIN, SYS_END));
  
• CREATE TABLE POLICY_ATT(BANK VARCHAR(4),
  SYS_BEGIN TIMESTAMP NOT NULL, SYS_END TIMESTAMP NOT NULL, CLIENT CHAR(4)T TYPE CHAR(5), PAY INT, PERIOD SYSTEM_TIME(SYS_BEG1N, SYS_END));
  
• CREATE TABLE POLICY_ATT(BANK VARCHAR(4). BUS_BEGIN TIMESTAMP. BUS_END TIMESTAMP. CLIENT CHAR(4), TYPE CHAR(5), PAY INT. PERIOD BUSINESS_TIME(BUS_BEGIN. BUS_END));
  
• CREATE TABLE POLICY_ATT(BANK VARCHAR(4),
  BUS_BEGIN TIMESTAMP NOT NULL, BUS_END TIMESTAMP NOT NUK, CLIENT CHAR{4), TYPE CHAR(5), PAY INT. PERIOD BUSINESS_TIME(BUS_BEGIN. BUS_END));
  

Which BIND option determines when DB2 will do authorization checking?

• DEFER
  
• DEPLOY
  
• VALIDATE
  
• CURRENTDATA
  

When the following SQL statement is executed, user smith will NOT be able to do which of the following? REVOKE USE OF STOGROUP stogr1 FROM smith;

• CREATE TRIGGER...;
  
• CREATE TABLE... IN dbl.ts1;
  
• CREATE DATABASE ... STOGROUP stogr1;
  
• CREATE TABLESPACE... USING STOGROUP stogr1;
  

Which statement is TRUE regarding ROLLBACK processing?

• It only reads active logs
  
• It always needs archive logs
  
• It can never be processed just from memory
  
• It uses output buffers, active and archive logs
  

Which catalog table would you query in order to determine the relevant statistics for an index?

• SYSIBM.SYSKEYS
  
• SYSIBM.SYSFIELDS
  
• SYSIBM.SYSCOLUMNS
  
• SYSIBM.SYSINDEXSTATS1
  

Which type of constraint is NOT enforced by DB2 during SQL processing?

• Check
  
• Referential
  
• Primary key
  
• Informational referential
  

While DSN is running, which of the following commands CANNOT be successfully executed?

• --STOP DB2
  
• --START DB2
  
• --TERM UTILITY
  
• --DISPLAY UTILITY
  

Which catalog tables are populated by RTS? (Choose two.)

• SYSIBM.SYSTABLES
  
• SYSIBM.SYSINDEXES
  
• SYSIBM.SYSINDEXPART
  
• SYSIBM.SYSINDEXSPACESTATS
  
• SYSIBM.SYSTABLESPACESTATS
  

Which command displays the DB2 catalog level and migration mode?

• DSNC DISPLAY
  
• MODIFY irlmproc,STATUS
  
• DISPLAY GROUP DETAIL
  
• DISPLAY DATABASE (DSNDB06)