Up To The Immediate Present C2090-320 Preparation For DB2 11 Fundamentals For Z/OS Certification

NEW QUESTION 1
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 2
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 3
What is the result XQuery FLWOR expression when running the following scenario?

• A. Joe Smith
• B. <name> Joe Smith </name>
• C. <employeeinfo><name> Joe Smith </name></employeeinfo>
• D. <name> Joe Smith </name><department name>DB2</department name>

Answer: A

NEW QUESTION 4
Which option is used with the RECOVER utility when the data sets of the target objects have already been restored to a point of consistency by another process offline?

• A. LOGONLY
• B. FROMDUMP
• C. TOLASTCOPY
• D. CURRENTCOPYONLY

Answer: A

NEW QUESTION 5
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 6
Given the following:

ALTER TABLE POLICY_INFO_AET ENABLE ARCHIVE USE POLICY_INFO_ARC: SET SYSIBMADM.MOVE_TO_ARCHIVE = T; ***
Which of the following occurs automatically when rows are deleted from POLICY_INFO_AET?

• A. The deleted rows are moved from POLICY_INFO_AET table to PaOLICY_INFO_ARC table
• B. The logically deleted rows are removed from POLICY_INFO_ARC table during the REORG
• C. The deleted rows are removed from both POLICY_INFO_AET and POLICY_INFO_ARC tables
• D. The deleted rows are moved from POLICY_INFO_AET table to POLICY_INFO_ARC table during theREORG

Answer: D

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

NEW QUESTION 10
You want to limit the access of a table to allow users to only see certain columns and/or rows. Which of the following options CANNOT be used to accomplish this?

• A. A view
• B. Multilevel security
• C. An MQT (Materialized Query Table)
• D. A combination of row permissions and column masks

Answer: C

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

Answer: C

NEW QUESTION 12
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 13
Which of the following statements about a table with a LOB column is TRUE?

• A. It doesn’t need an auxiliary table if it has an inline LOB
• B. It must also have a ROWID column and an auxiliary table
• C. It doesn’t need a ROWID column (implicit or explicit) if a LOB locator will be used
• D. It must be in a partitioned by growth (PBG) universal table space with a ROWID column

Answer: B

NEW QUESTION 14
An application program is running much longer than expected. The PLAN_TABLE shows the following access path information:
ACCESSTYPE = 'R' PREFETCH = 'S'
What access path does this represent?

• A. IN-list access
• B. Direct row access
• C. Dynamic prefetch access
• D. Table space scan access

Answer: D

NEW QUESTION 15
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 16
Assume DELETE triggers exist on the employee table. Which of the following statements will delete all the rows in the employee table and ignore any DELETE triggers?

• A. TRUNCATE employee;
• B. DELETE FROM employee;
• C. DELETE FROM employee WHERE…;
• D. TRUNCATE employee RESTRICT WHEN DELETE TRIGGERS;

Answer: B

NEW QUESTION 17
A stored procedure needs to issue a dynamic SQL statement (SELECT) at runtime. The stored procedure's owner ID must be used for the authorization check (whether or not the SELECT is allowed).
Which BIND parameter setting can you use to accomplish this ?

• A. DYNAMICRULES(RUN)
• B. DYNAMICRULES(BIND)
• C. DYNAMICRULES(INVOKERUN)
• D. DYNAMICRULES(DEFINEBIND)

Answer: B

NEW QUESTION 18
Which SQL statement will retrieve the department number (WORKDEPT)
and the highest salary (SALARY) for each department in a table
named EMPLOYEE and arrange the result set in ascending order by department?

• A. SELECT workdept, salary FROM employee GROUP BY workdept ORDER BY workdept;
• B. SELECT workdept MAX(salary) FROM employee ORDER BY workdept GROUP BY 2;
• C. SELECT workdept MAX(salary) FROM employee ORDER BY workdept;
• D. SELECT workdept MAX(salary) FROM employee GROUP BY workdept ORDER BY 1;

Answer: B

NEW QUESTION 19
The metadata for which of the following objects is NOT stored in the DB2 catalog table SYSIBM.SYSTABLES?

• A. A view
• B. A temporal table
• C. A created global temporary table
• D. A declared global temporary table

Answer: B

NEW QUESTION 20
Which CREATE TABLESPACE option specifies that a table space is partition-by-growth?

• A. DSSIZE
• B. PARTITION
• C. NUMPARTS
• D. MAXPARTITIONS

Answer: D

NEW QUESTION 21
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 22
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 23
You are designing a payroll table that will contain a salary column. Which of the following is the appropriate built-in data type for a salary column?

• A. REAL
• B. BIGINT
• C. DECIMAL
• D. INTEGER

Answer: C

NEW QUESTION 24
......