Microsoft
Amazon
CompTIA
Salesforce
Cisco®
SAP
PMI
ISC
ISACA
VMware
HP
Palo Alto Networks
EC-Council
LPI
Google
Fortinet
All Vendors
  2. Home
  3. Exam List
  4. IBM
  5. C2090-320

DB2 11 Fundamentals for z/OS exam
C2090-320 Exam

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




C J
Just to let you know, I passed my exam. Thank you,
- Mexico
Upvote


Mr. P
I just have to say a big thank you to you guys... i passed 70-552 exams with 896. You guys are the bomb! Keep the faith and the flag of being good. A big thank you once again.(10Q ALL).
- GERMANY
Upvote


Darwin
I passed the Novell 640-822 exam on this last Thursday after using your online test and IPad. This is my first experience with your exams. I'll be using your material from now on. In a few days I'll purchase my last study material for the C
- France
Upvote


Bila
Thanks! I passed 070-284 with 880 070-219 next to complete my MCSE.
- Colorado
Upvote


Passed
I just took my Certification testing for 10-184 Microsoft CRM Installation and Configuration. Your test questions definitely covered the essence of the exam material and I easily passed the exam.
- UNITED STATES
Upvote


Ed
I passed the IBM exam successfully
- UNITED STATES
Upvote


Tina
Last week I took the Citrix exam and I passed with a very high mark, more than what I expected. Thanks!!
- Israel
Upvote


Calvin B.
I just took my Certification testing for 10-184 Microsoft CRM Installation and Configuration. Your test questions definitely covered the essence of the exam material and I easily passed the exam.
- Lafayette
Upvote


950+
I just finished my exam this week. It was a good score of 950+.
- UNITED STATES
Upvote


Abdul
I passed the exam on Monday morning and was amazed at how much this site had covered, fortunately that's it for another three years. The tests really did help so thanks!!
- Doha
Upvote

Read more ...