Free C2090-320 Exam Braindumps
DB2 11 Fundamentals for z/OS exam Questions 31–35 (page: 8)

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

  1. –STOP DB2
  2. –START DB2
  3. –TERM UTILITY
  4. –DISPLAY UTILITY

Answer(s): D



Which of the following is TRUE for using LOAD on a partition-by-growth table space?

  1. Data can only be loaded at the partition level
  2. Data can only be loaded at the table space level
  3. Data can only be loaded using a clustering index
  4. Data can be loaded at either the table space level or the partition level

Answer(s): A


Reference:

https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&cad=rja&uact=8&ved=0ahUKEwjXpIn74tzZAhVRPsAKHRYGBGUQFggnMAA&url=https%3A%2F%2Fwww.ibm.com%2Fsupport%2Fknowledgecenter%2Fen% 2FSSEPEK_11.0.0%2Fintro%2Fsrc%2Ftpc% 2Fdb2z_partitionbygrowthtablespaces.html&usg=AOvVaw0DCKeDA6MfIUE5UQWhFe_G



Which of the following can be defined on the basis of a query?

  1. An alias
  2. A base table
  3. An accelerator-only table
  4. A materialized query table

Answer(s): D


Reference:

https://www.ibm.com/developerworks/data/library/techarticle/dm-0509melnyk/



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?





Answer(s): D



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?

  1. DB2 does not allow these commands
  2. DSN command can not be used to run a program
  3. Start a DSN session with DB2 subsystem SSTR, run a program and end the DSN session
  4. Start a DSN session with system parameters SSTR, run a program and end the DSN session

Answer(s): C


Reference:

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



Viewing page 8 of 26
Viewing questions 36 - 40 out of 124 questions


Post your Comments and Discuss IBM C2090-320 exam prep with other Community members:

AI Tutor AI Tutor 👋 I’m here to help!