IBM C2090-320 DB2 11 Fundamentals for z/OS exam Online Training
IBM C2090-320 Online Training
The questions for C2090-320 were last updated at Nov 23,2024.
- Exam Code: C2090-320
- Exam Name: DB2 11 Fundamentals for z/OS exam
- Certification Provider: IBM
- Latest update: Nov 23,2024
While DSN is running, which of the following commands CANNOT be successfully executed?
- A . CSTOP DB2
- B . CSTART DB2
- C . CTERM UTILITY
- D . CDISPLAY UTILITY
Which of the following is TRUE for using LOAD on a partition-by-growth table space?
- A . Data can only be loaded at the partition level
- B . Data can only be loaded at the table space level
- C . Data can only be loaded using a clustering index
- D . Data can be loaded at either the table space level or the partition level
Which of the following can be defined on the basis of a query?
- A . An alias
- B . A base table
- C . An accelerator-only table
- D . A materialized query table
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 .
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
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
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 .
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
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
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
Latest C2090-320 Dumps Valid Version with 123 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
