Regenerate C2090-320 Question For DB2 11 Fundamentals For Z/OS Certification

NEW QUESTION 1
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 2
A summary table can be easily maintained using which of the following?

• A. An auxiliary table
• B. A partitioned table
• C. A bi-temporal table
• D. A materialized query table

Answer: D

NEW QUESTION 3
In order to evaluate the real-time relative disorganization of an index, which catalog table would you query?

• A. SYSIBM.SYSINDEXES
• B. SYSIBM.SYSINDEXPART
• C. SYSIBM.SYSINDEXSTATS
• D. SYSIBM.SYSINDEXSPACESTATS

Answer: B

NEW QUESTION 4
Which catalog table would you query in order to determine the relevant statistics for an index?

• A. SYSIBM.SYSKEYS
• B. SYSIBM.SYSFIELDS
• C. SYSIBM.SYSCOLUMNS
• D. SYSIBM.SYSINDEXSTATS1

Answer: D

NEW QUESTION 5
Which of the following utilities or utility control statements require datasets for execution?

• A. LISTDEF
• B. OPTIONS
• C. TEMPLATE
• D. CHECK LOB

Answer: A

NEW QUESTION 6
You want to reduce lock contention that results from uncommitted insert and delete operations by enabling transactions that read data to access only the currently committed data rather than waiting for the uncommitted changes to be resolved. How can you accomplish this?

• A. Bind your application with ISOLATION(UR)
• B. Bind your application with ISOLATION(CS)
• C. Bind your application with CONCURRENTACCESSRESOLUTION (WAITFOROUTCOME)
• D. Bind your application with CONCURRENTACCESSRESOLUTION (USECURRENTLYCOMMITTED)

Answer: D

NEW QUESTION 7
The DB2 subsystem DSN has been correctly configured to access a remote DB2 location MYREMOTE. Which of the following processes can be used on subsystem DSN to access MYUSER.EMP table at MYREMOTE location?

• A. SELECT * FROM MYUSER.EMP;
• B. CONNECT TO MYREMOTE;SELECT * FROM MYUSER.EMP;
• C. SELECT * FROM MYUSER.MYREMOTE.EMP;
• D. CREATE ALIAS EMP_ALIAS FOR LOCATION.MYREMOTE.MYUSER.EMP;SELECT * FROM MYUSER.EMP_ALIAS;

Answer: B

NEW QUESTION 8
What is the purpose of an auxiliary table?

• A. To hold the data for a column that is defined in a base table
• B. To hold only XML data
• C. To hold data temporarily
• D. To store rows that are deleted from another table

Answer: D

NEW QUESTION 9
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 10
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

NEW QUESTION 11
Your application has a read-only cursor. You cannot tolerate uncommitted data but want to make sure that it provides the best concurrency. Which of the following bind options would provide the locking you need with optimistic locking?

• A. ISOLATION(UR)
• B. ISOLATION(RS)
• C. ISOLATION(CS)CURRENTDATA(NO)
• D. ISOLATION(CS)CURRENTDATA(YES)

Answer: C

NEW QUESTION 12
Which of the following tables can be used to set the default of the special register CURRENT APPLICATION COMPATIBILITY for remote users?

• A. The resource limit facility table authid.DSNRLMTxx
• B. The DB2 catalog table SYSIBM.SYSENVIRONMENT
• C. The profile table SYSIBM.DSN_PROFILE_ATTRIBUTES
• D. The communications database table SYSIBM.USERNAMES

Answer: C

NEW QUESTION 13
User1 creates table user1 .customers in a partitioned-by-growth (PBG) table space DB1.TS1
Which of the following operations CANNOT be performed by user1 with implicit owner privileges on the table?

• A. Run the LOAD utility to load data
• B. Create a VIEW on the customers table
• C. Run the REORG utility to reorganize the data
• D. Issue an SQL LOCK TABLE statement against the customers table

Answer: A

NEW QUESTION 14
Which command displays the DB2 catalog level and migration mode?

• A. DSNC DISPLAY
• B. MODIFY irlmproc,STATUS
• C. DISPLAY GROUP DETAIL
• D. DISPLAY DATABASE (DSNDB06)

Answer: B

NEW QUESTION 15
Given the following INDEX definition, which attributes apply to this index? (Choose two.)

• A. The index is partitioned
• B. The index data sets are user-managed
• C. The index data sets are DB2-managed
• D. The index is unique and in ascending order
• E. The maximum total size of the index is 1 GB

Answer: AB

NEW QUESTION 16
Which statement is TRUE regarding catalog table SYSIBM.SYSROUTINES?

• A. Contains scheduled tasks for the administrative scheduler
• B. Contains information about UDFs, BIFs and stored procedures
• C. Contains information about bound packages
• D. Contains information about UDFs and stored procedures

Answer: D

NEW QUESTION 17
How can a user-defined function (UDF) be invoked?

• A. Via an SQL SELECT statement
• B. Via a CALL statement using SPUFI
• C. Directly via a RUN PROGRAM command
• D. Via a CALL statement from within an application program

Answer: B

NEW QUESTION 18
Which of the following are contained in the PLAN_TABLE? (Choose two.)

• A. RUNSTATS recommendations
• B. Access to LOB values, which are stored separately from the base table
• C. Access to parent or dependent tables needed to enforce referential constraints
• D. Whether an index access or table space scan is used for each access to a table
• E. The join methods and types that are used, and the order in which DB2 joins the tables

Answer: DE

NEW QUESTION 19
Which isolation level is described by the following?
The ISOLATION (..) option allows maximum concurrency with data integrity. Under the ISOLATION (..) option, a transaction holds locks only on its uncommitted changes and on the current row of each of its cursors.

• A. CS
• B. UR
• C. RR
• D. RS

Answer: A

NEW QUESTION 20
You want to see all messages that were generated by one specific DB2 subsystem such as log switches and timeout messages. Which job log would show all of these?

• A. MSTR
• B. DBM1
• C. DIST
• D. IRLM

Answer: A

NEW QUESTION 21
Which of the following are valid objects created using DDL? (Choose two)

• A. PLAN
• B. PACKAGE
• C. DATABASE
• D. SEQUENCE
• E. COLLECTION

Answer: DE

NEW QUESTION 22
In the parent table of a referential constraint, a parent key must be which of the following? (Choose two.)

• A. A unique key
• B. A foreign key
• C. A primary key
• D. A duplicate key
• E. A secondary key

Answer: AC

NEW QUESTION 23
......