NEW QUESTION 1
Your current authorization ID is DBA. Only one of your secondary authorization IDs, DB2, has the privilege to drop an existing index DB2.AAA on a table. The appropriate SQL statement is "DROP INDEX AAA". Which of the following statements must precede th$ DROP statement so that it drops the index?

• A. SET CURRENT PATH = 'DB2';
• B. SET CURRENT RULES = 'DB2';
• C. No preceding statement is needed
• D. SET CURRENT SCHEMA = 'DB2':

Answer: A

NEW QUESTION 2
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 3
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 4
An array value CANNOT be specified using which of the following methods?

• A. Invocation of an INSERT statement
• B. Invocation of the ARRAY_AGG function
• C. Invocation of the ARRAY_DELETE or TRIM_ARRAY built-in functions
• D. A simple reference to an SQL variable, or SQL parameter that is a user-defined array type

Answer: D

NEW QUESTION 5
Which statement about an application-period temporal table is TRUE?

• A. It has SYSTEM_TIME defined
• B. It has an end column defined using WITH DEFAULT NULL
• C. It must have the index clause BUSINESS_TIME WITHOUT OVERLAPS
• D. It has a begin column defined as TIMESTAMP(6) NOT NULL or DATE NOT NULL

Answer: C

NEW QUESTION 6
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 7
Which of the following is NOT TRUE?

• A. An index can be created on XML columns
• B. Length must be specified for an XML column
• C. XML columns can be added to existing tables
• D. Triggers can be created on tables with XML columns

Answer: D

NEW QUESTION 8
A clone table can only be created in which of the following?

• A. A simple table space
• B. A universal table space
• C. An auxiliary table space
• D. A classic segmented table space

Answer: B

NEW QUESTION 9
Which of the following actions can you take in order to prevent users from obtaining implicit privileges as a result of object ownership?

• A. Create the object in a trusted context that is defined with the ROLE AS OBJECT OWNER AND QUALIFIER clause
• B. Create the object after activating the SEPARATE_SECURITY=YES DSNZPARM
• C. Let somebody with SYSCTRL authority create the object
• D. Create the object after activating an audit policy that will apply to the table that you are about to create

Answer: A

NEW QUESTION 10
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 11
Which of the following elements is affected by a ROLLBACK statement?

• A. LOB table spaces
• B. Changes in cursor positioning
• C. Acquisition and release of locks
• D. Caching of rolled back statements

Answer: A

NEW QUESTION 12
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 13
Which package level privileges does the user smith have when the following statement is executed? GRANT ALL ON PACKAGE clct1.pkg1 TO smith;

• A. GRANT, COPY, BIND, RUN
• B. BIND, EXECUTE, COPY, RUN
• C. CREATE, COPY, RUN, EXECUTE
• D. COPY, BINDADD, SQL, EXECUTE

Answer: B

NEW QUESTION 14
To ensure only positive values are entered into a column, you add a constraint on the SALARY column of a previously populated table If D32 cannot guarantee the existing values in the column are positive, it will place the table space or partition that contains the table into which of the following states?

• A. CHECK PENDING
• B. REORG PENDING
• C. REBUILD PENDING
• D. ADVISORY REORG PENDING

Answer: A

NEW QUESTION 15
Given the following sequence of events:
* 1) COL1 in SCHEMA.TABLE has a value of 10
* 2) Update COL1 in SCHEMA.TABLE to 20
* 3)SetSAVEPOINTA
* 4) Update COL1 in SCHEMA.TABLE to 30
* 5)SetSAVEPOINTB
After issuing the statement: ROLLBACK TO SAVEPOINT
What will be the value in COL1 of the SCHEMA.TABLE?

• A. 10
• B. 20
• C. 30
• D. An -880 SQLCODE will be issued when the statement is executed

Answer: D

NEW QUESTION 16
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 17
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 18
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 19
When the following SQL statement is executed, user smith will NOT be able to do which of the following? REVOKE USE OF STOGROUP stogr1 FROM smith;

• A. CREATE TRIGGER...;
• B. CREATE TABLE... IN dbl.ts1;
• C. CREATE DATABASE ... STOGROUP stogr1;
• D. CREATE TABLESPACE... USING STOGROUP stogr1;

Answer: C

NEW QUESTION 20
You have created a new index. What is the command to potentially change the access path for a static package?

• A. FREE
• B. RESET
• C. REBIND
• D. REFRESH

Answer: A

NEW QUESTION 21
Which SQL statement supports an insert or an update in a single SQL statement?

• A. MERGE
• B. UPSERT
• C. UPDATE or INSERT INTO....
• D. INSERT INTO table... ON DUPLICATE KEY ....

Answer: D

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