IBM IBM Certifications C2090-320 Questions & Answers

• Question 81:

  Which DB2 address space manages DB2 locking?

  A. IRLM

  B. DIST

  C. DBM1

  D. MSTR

  Correct Answer: A

  Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/inst/src/tpc/ db2z_irlmaddrspcstgreq.html

• Question 82:

  Which BIND option determines when DB2 will do authorization checking?

  A. DEFER

  B. DEPLOY

  C. VALIDATE

  D. CURRENTDATA

  Correct Answer: C

  Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/comref/src/tpc/ db2z_bindoptvalidate.html

• Question 83:

  Which types of user-defined data types are supported? (Choose two.)

  A. CHAR

  B. ARRAY

  C. NUMERIC

  D. DISTINCT

  E. TIMESTAMP

  Correct Answer: BD

  Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/sqlref/src/tpc/ db2z_userdefineddatatypes.html

• Question 84:

  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

  Correct Answer: B

  In a system-period temporal table, every row has a pair of timestamps, which are set by the DB2 system and recorded in the begin_column and end_column columns. DB2 uses the SYSTEM_TIME period to audit the data changes. It provides the application with the database managed row begin and row end timestamp maintenance, providing non-overlapping time periods with no gaps in time.

  Reference: https://www.ibm.com/developerworks/data/library/techarticle/dm-1410temporal-tables-db2zos/ index.html

• Question 85:

  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

  Correct Answer: AC

  Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/sqlref/src/tpc/ db2z_sql_createtablespace.html

• Question 86:

  Which of the following are advantages of DB2 for z/OS data sharing over a standalone DB2 subsystem implementation? (Choose two.)

  A. Reduced active logs

  B. Reduced storage use

  C. Higher transaction rates

  D. Reduced lock contention

  E. Increased data availability

  Correct Answer: CE

• Question 87:

  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.

  Correct Answer: A

• Question 88:

  Which of the following describes OLTP workload rather than an analytics workload?

  A. Extreme data volume

  B. Temporary or intermediate staging of data

  C. Set-oriented processing and bulk operations

  D. A large number of short, discrete, atomic transactions

  Correct Answer: D

  Reference: http://www.ibmbigdatahub.com/sites/default/files/document/IBM-Netezza-Understanding-Analytic-Workloads-eBook.pdf

• Question 89:

  In order to run a DB2 program, the user issues the following commands:

  TSO prompt: READY

  USER enters: DSN SYS(SSTR)

  USER enters: RUN PROGRAM(MYPROG)

  USER enters: END

  What is the result?

  A. DB2 does not allow these commands

  B. DSN command can not be used to run a program

  C. Start a DSN session with DB2 subsystem SSTR, run a program and end the DSN session

  D. Start a DSN session with system parameters SSTR, run a program and end the DSN session

  Correct Answer: C

  Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/comref/src/tpc/ db2z_cmd_dsn.html

• Question 90:

  Assuming column hire date is a DATE data type, which SQL statement will retrieve the maximum salary (salary) and minimum salary(salary) for each job(job) from EMPLOYEE table for those hired(hiredate) before 1965?

  

  A. B. C. D.

  Correct Answer: D