C2090-320 DB2 11 Fundamentals for z/OS exam exam is a hot IBM certification exam, Exam4Training offers you the latest free online C2090-320 dumps to practice. You can get online training in the following questions, all these questions are verified by IBM experts. If this exam changed, we will share new update questions.
The following definition for COL1 is given by this statement:
CREATE TABLE… (COL1 BINARY (05))
Which of the following statements will successfully insert data into the table?
A . INSERT INTO… (COL1) VALUES(HEX(‘12345’));
B . INSERT INTO… (COL1) VALUES(BLOB(‘12345’));
C . INSERT INTO… (COL1) VALUES(CHAR(‘12345’));
D . INSERT INTO… (COL1) VALUES(BINARY(‘123456’));
Answer: C
COL1 is defined as CHAR(05) and contains CHAR(‘12345’).
Which of the following expressions returns the digits 12345 for further calculation?
A . HEX(COL1)
B . DEC(COL1)
C . PACK(COL1)
D . DIGITS(COL1)
Answer: B
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
Answer: D
Explanation:
Reference: https://www.ibm.com/developerworks/data/library/techarticle/dm-0509melnyk/
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
Answer: D
In which address space would a native SQL stored procedure run?
A . WLM
B . DIST
C . DBM1
D . The address space of the calling program
Answer: C
Explanation:
Reference: http://www.ibmbigdatahub.com/blog/db2-native-sql-procedures-future-computing
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
Answer: A
Explanation:
Reference: https://www.google.com/url? sa=t&rct=j&q=&esrc=s&source=web&cd=1&cad=rja&uact=8&ved=0ahUKEwjXpIn74tzZAhVRPsAKHRYG BGUQFggnMAA&url=https%3A%2F%2Fwww.ibm.com%2Fsupport%2Fknowledgecenter%2Fen% 2FSSEPEK_11.0.0%2Fintro%2Fsrc%2Ftpc% 2Fdb2z_partitionbygrowthtablespaces.html&usg=AOvVaw0DCKeDA6MfIUE5UQWhFe_G
If a scrollable cursor is INSENSITIVE, which of the following applies?
A . The cursor is read only
B . WITH ROWSET POSITIONING is not allowed
C . The select-statement must not contain an SQL data change statement
D . The cursor has sensitivity to changes that are made to the database after the result table is materialized
Answer: A
Explanation:
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/java/src/tpc/ imjcc_tjvsjscr.html
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
Answer: AC
Explanation:
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/sqlref/src/tpc/ db2z_sql_createtablespace.html
Which of the following locking scenarios requires the least amount of real storage in the IRLM address space?
A . 10 row locks
B . 200 page locks
C . A single table space lock
D . 6 partition locks (given a table space with a total of 10 partitions)
Answer: C
Given the following table and index definitions, what type of index will be created?
A . Non-partitioned index
B . Non-partitioned secondary index
C . Data-partitioned secondary index
D . Data-partitioned partitioning index
Answer: C