IBM C2090-320 Free Practice Questions

NEW QUESTION 1
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 2
The PERIOD BUSINESS_TIME clause on a DDL statement is used in which of the following? (Choose two)

• A. A bitemporal table
• B. A system-period temporal table
• C. A created global temporary table
• D. A declared global temporary table
• E. An application-period temporal table

Answer: CD

NEW QUESTION 3
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 4
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 5
Consider the following question: “What is the average salary by sex within education level?” An occasional uncommitted record can be tolerated in the average. Which of the following is the most appropriate isolation level for this?

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

Answer: A

NEW QUESTION 6
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 7
Which of the following is NOT a valid lock size in DB2?

• A. Table
• B. Partition
• C. Database
• D. Table space

Answer: C

NEW QUESTION 8
Given the following SQL statement:
GRANT DELETE ON TABLE customer TO used; Which of the following statements is TRUE?

• A. User1 can only remove the customer table
• B. User1 can only remove rows from the customer table
• C. User1 can remove the customer table and grant the privilege to remove the customer table to other users
• D. User1 can remove rows from the customer table and can grant the privilege to remove rows from the customer table to other users

Answer: C

NEW QUESTION 9
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 10
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 11
You need to add the employee picture to the employee table. Which of the following is the appropriate built-in data type for storing images?

• A. BLOB
• B. CLOB
• C. DBCLOB
• D. VARGRAPHIC

Answer: B

NEW QUESTION 12
What are two major encoding schemes? (Choose two.)

• A. UNIX
• B. Linux
• C. CCSID
• D. Unicode
• E. EBCDIC

Answer: DE

NEW QUESTION 13
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 14
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 15
Which of the following coupling facility structures are used by DB2 in a data sharing environment?

• A. List structure, DB2 logs, and group buffer pools
• B. Work file database, list structure, and virtual buffer pools
• C. Lock structure, shared communications area, and group buffer pools
• D. Lock structure, shared communications area, and bootstrap data sets

Answer: C

NEW QUESTION 16
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 17
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 18
An external stored procedure is invoked using a CALL :hv (host variable). Which special register identifies the location of the procedure?

• A. CURRENT PATH
• B. CURRENT SCHEMA
• C. CURRENT PACKAGESET
• D. CURRENT ROUTINE VERSION

Answer: D

NEW QUESTION 19
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 20
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 21
Which of the following is a characteristic of a stand-alone utility?

• A. It can only be executed using JCL
• B. It can only be executed by a user with SYSADM
• C. It can only be executed if no other utilities are running
• D. It can only be executed in a non-data sharing environment

Answer: A

NEW QUESTION 22
......