Abreast Of The Times DB2 11 Fundamentals For Z/OS C2090-320 Question

NEW QUESTION 1
Which catalog table contains the IN, OUT and INOUT parameters used in a stored procedure?

• A. SYSIBM.SYSSTMT
• B. SYSIBM.SYSPARMS
• C. SYSIBM.SYSROUTINES
• D. SYSIBM.SYSVARIABLES

Answer: C

NEW QUESTION 2
Which catalog table contains the information about definition changes for an object that have not yet been applied by the REORG utility?

• A. SYSIBM.SYSCHECKDEP
• B. SYSIBM.SYSPENDINGDDL
• C. SYSIBM.SYSDEPENDENCIES
• D. SYSIBM.SYSPENDINGOBJECTS

Answer: B

NEW QUESTION 3
The following warning message is issued when the last available active log data set is 5% full: DSNJ110E - LAST COPY n ACTIVE LOG DATA SET IS nnn PERCENT FULL
What will happen if you ignore this message?

• A. DB2 will shut down if it reaches the 100 % full condition
• B. DB2 will overwrite the oldest archive log without archiving
• C. DB2 will stop any activity that requires log writes if it reaches the 100 % full condition
• D. DB2 will automatically allocate more active log data sets as long as there are still less than 93 of them

Answer: A

NEW QUESTION 4
Which BIND option determines when DB2 will do authorization checking?

• A. DEFER
• B. DEPLOY
• C. VALIDATE
• D. CURRENTDATA

Answer: C

NEW QUESTION 5
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

Answer: D

NEW QUESTION 6
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

NEW QUESTION 7
A view is considered read only if which of the following is TRUE?

• A. The first EROM clause identifies only one table
• B. The outer fullselect contains an ORDER BY clause
• C. The first SELECT clause specifies the DISTINCT option
• D. The fullselect includes a column of a base table that is defined as implicitly hidden

Answer: B

NEW QUESTION 8
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

NEW QUESTION 9
Which of the following SELECT statements returns a different data value than the other SQL statements ?

• A. SELECT MONTH (CURRENT TIMESTAMP) FROM SYSIBM.SYSDUMMY1;
• B. SELECT EXTRACT(MONTH FROM CURRENT TIMESTAMP) FROM SYSIBM.SYSDUMMY1;
• C. SELECT LPAD(LTRIM(SUBSTR(CHAR(CURRENTTIMESTAMP(10))l6l2)t,0')l11l") FROM SYSIBM.SYSDUMMY1;
• D. SELECT TIMESTAMPDIFF(64. CHAR( CURRENT TIMESTAMP - TIMESTAMP('2021-01-01-00.00.00'))) FROM SYSIBM.SYSDUMMY1;

Answer: A

NEW QUESTION 10
Which job generates the subsystem parameter module?

• A. DSNTIJIN
• B. DSNTIJJP
• C. DSNTIJUZ
• D. DSNTIJEN

Answer: C

NEW QUESTION 11
In a unique referential constraint, which type of key does a foreign key reference?

• A. Child key
• B. Collation key
• C. Parent key
• D. Secondary key

Answer: C

NEW QUESTION 12
Given a non-partitioned table space TS1 is built with LOCKSIZE ROW, LOCKMAX 1000 and SEGSIZE 64. If a unit of work acquires 1001 locks against table space TS1, the lock will be escalated to which of the following levels?

• A. PAGE
• B. TABLE
• C. PARTITION
• D. TABLESPACE

Answer: C

NEW QUESTION 13
When the following SQL statement is executed, the user SMITH is able to manage all objects in the DB2 subsystem except for which of the following?
GRANT DBADM ON SYSTEM TO smith;

• A. Tables
• B. Traces
• C. Sequences
• D. Security Objects

Answer: A

NEW QUESTION 14
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

NEW QUESTION 15
Which of the following CREATE TABLE or associated CREATE INDEX options are valid when defining a table with the PARTITION BY RANGE clause? (Choose two)

• A. MAXPARTITIONS
• B. ENDING AT clause on a CREATE INDEX statement for the table
• C. MEMBER CLUSTER
• D. ENDING AT clause on the CREATE TABLE statement
• E. A LOB column specified as a column of the partitioning key

Answer: B

NEW QUESTION 16
Which of the following table space types does NOT support the use of REORG TABLESPACE SHRLEVEL(NONE)?

• A. LOB
• B. Simple
• C. Partition-by-range
• D. Partition-by-growth

Answer: A

NEW QUESTION 17
Which of the following automatically maintains historical versions of data over several years?

• A. A partitioned-by-range table
• B. A partitioned-by-growth table
• C. A system-period temporal table
• D. An application-period temporal table

Answer: C

NEW QUESTION 18
What is the proper sequence for running the steps of the program preparation process?

• A. Precompil
• B. compile, link edit, bind
• C. Bind, precompile, compile, link edit
• D. Precompil
• E. bind, link edit, compile
• F. Link edit, precompile, compile, bind

Answer: C

Explanation:
https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/intro/src/tpc/db2z_programprepprocesses.ht

NEW QUESTION 19
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

Answer: CE

NEW QUESTION 20
Which of the following programming techniques can be used to check for any error codes after executing an SQL statement?

• A. Declaring a cursor
• B. Using the WHENEVER statement
• C. Using DCLGEN to produce declarations for tables
• D. Dynamically executing a statement with parameter markers

Answer: D

NEW QUESTION 21
Which of the following is NOT a valid trigger?

• A. MERGE
• B. INSERT
• C. UPDATE
• D. DELETE

Answer: A

NEW QUESTION 22
......