CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. IBM
  5. C2090-320

Free C2090-320 Exam Braindumps

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



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

  1. Extreme data volume
  2. Temporary or intermediate staging of data
  3. Set-oriented processing and bulk operations
  4. A large number of short, discrete, atomic transactions

Answer(s): D


Reference:

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






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

C2090-320 Exam Discussions & Posts