NEW QUESTION 1
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 2
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 3
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 4
Which of the following can activate a trigger?

• A. A row is inserted
• B. A table or view is created
• C. A check constraint is defined
• D. A referential constraint is violated

Answer: D

NEW QUESTION 5
Which of the following effectively and efficiently manages priorities of a mixed workload as a result of its tight integration with DB2 for z/OS?

• A. Data Facility Storage Management
• B. z/OS Parallel Sysplex Configuration
• C. Workload Manager
• D. z Systems Processor Resource

Answer: C

NEW QUESTION 6
What is the implicitly created column in a base table which contains an XML column called?

• A. Node ID
• B. ROWID
• C. LOCATOR
• D. DOCID

Answer: B

NEW QUESTION 7
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 8
Which of the following utilities CANNOT be executed from the DB2 utilities panel in DB2I?

• A. COPY
• B. REORG
• C. STOSPACE
• D. BACKUP SYSTEM

Answer: D

NEW QUESTION 9
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 10
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 11
Which BIND option determines when DB2 will do authorization checking?

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

Answer: C

NEW QUESTION 12
Which protocol provides applications the ability to connect to a server at another location and execute packages that have been previously bound at that server?

• A. CLI
• B. JDBC
• C. DRDA
• D. ODBC

Answer: D

NEW QUESTION 13
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 14
Select the SQL statement which will list the employee(empno) and the project numbers(projno) from the EMPACT table that has an employee(empno) whose salary(salary) is in the top three salaries for all employees from the EMP table.
A)

B)

C)

D)

• A. Option A
• B. Option B
• C. Option C
• D. Option D

Answer: D

NEW QUESTION 15
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 16
How can a stored procedure 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: D

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

NEW QUESTION 18
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 19
Which of the following is used to identify valid source and target combinations and to perform the conversion from one coded character set to another?

• A. EBCDIC tables
• B. z/OS Unicode support
• C. DB2 catalog table SYSIBM.SYSCOLUMNS
• D. DB2's Distributed Relational Database Architecture

Answer: D

NEW QUESTION 20
Which of the following SQL constructs does NOT provide information about the success or failure of the SQL statement that was just executed?

• A. SQLCA
• B. SQLDA
• C. SQLCODE
• D. SQLSTATE

Answer: B

NEW QUESTION 21
Which two of the following functions are synonyms of one another? (Choose two)

• A. CLOB
• B. VALUE
• C. IFNULL
• D. DBCLOB
• E. COALESCE

Answer: CE

NEW QUESTION 22
Which catalog tables are populated by RTS? (Choose two.)

• A. SYSIBM.SYSTABLES
• B. SYSIBM.SYSINDEXES
• C. SYSIBM.SYSINDEXPART
• D. SYSIBM.SYSINDEXSPACESTATS
• E. SYSIBM.SYSTABLESPACESTATS

Answer: DE

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

NEW QUESTION 24
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 25
......