Free C2090-320 Exam Dumps Preview

Question 1

Single choice

Given the following:

Which of the following occurs automatically when rows are deleted from POLICY_INFO_AET?

1. A

   The deleted rows are moved from POLICY_INFO_AET table to POLICY_INFO_ARC table

2. B

   The logically deleted rows are removed from POLICY_INFO_ARC table during the REORG

3. C

   The deleted rows are removed from both POLICY_INFO_AET and POLICY_INFO_ARC tables

4. D

   The deleted rows are moved from POLICY_INFO_AET table to POLICY_INFO_ARC table during the REORG

Reveal answer details Close answer details

Correct answerD

Question 2

Single choice

Given the following SQL statement:

GRANT DELETE ON TABLE customer TO user1;

Which of the following statements is TRUE?

1. A

   User1 can only remove the customer table

2. B

   User1 can only remove rows from the customer table

3. C

   User1 can remove the customer table and grant the privilege to remove the customer table to other users

4. D

   User1 can remove rows from the customer table and can grant the privilege to remove rows from the customer table to other users

Reveal answer details Close answer details

Correct answerD

Question 3

Single choice

Which of the following locking scenarios requires the least amount of real storage in the IRLM address space?

1. A

   10 row locks

2. B

   200 page locks

3. C

   A single table space lock

4. D

   6 partition locks (given a table space with a total of 10 partitions)

Reveal answer details Close answer details

Correct answerC

Question 4

Single choice

Which of the following programming techniques can be used to check for any error codes after executing an SQL statement?

1. A

   Declaring a cursor

2. B

   Using the WHENEVER statement

3. C

   Using DCLGEN to produce declarations for tables

4. D

   Dynamically executing a statement with parameter markers

Reveal answer details Close answer details

Correct answerC

Question 5

Single choice

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

1. A

   Node ID

2. B

   ROWID

3. C

   LOCATOR

4. D

   DOCID

Reveal answer details Close answer details

Correct answerB

Question 6

Single choice

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?

1. A

   EBCDIC tables

2. B

   z/OS Unicode support

3. C

   DB2 catalog table SYSIBM.SYSCOLUMNS

4. D

   DB2's Distributed Relational Database Architecture

Reveal answer details Close answer details

Correct answerB

Explanation

References:
https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/intro/src/tpc/
db2z_codedcharsetsandccsids.html

Question 7

Multiple choice

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

1. A

   SYSIBM.SYSTABLES

2. B

   SYSIBM.SYSINDEXES

3. C

   SYSIBM.SYSINDEXPART

4. D

   SYSIBM.SYSINDEXSPACESTATS

5. E

   SYSIBM.SYSTABLESPACESTATS

Reveal answer details Close answer details

Correct answersD, E

Question 8

Single choice

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

1. A

   The resource limit facility table authid.DSNRLMTxx

2. B

   The DB2 catalog table SYSIBM.SYSENVIRONMENT

3. C

   The profile table SYSIBM.DSN_PROFILE_ATTRIBUTES

4. D

   The communications database table SYSIBM.USERNAMES

Reveal answer details Close answer details

Correct answerC

Question 9

Single choice

In which address space would a native SQL stored procedure run?

1. A

   WLM

2. B

   DIST

3. C

   DBM1

4. D

   The address space of the calling program

Reveal answer details Close answer details

Correct answerC

Explanation

References:
http://www.ibmbigdatahub.com/blog/db2-native-sql-procedures-future-computing

Question 10

Single choice

Which command displays the DB2 catalog level and migration mode?

1. A

   DSNC DISPLAY

2. B

   MODIFY irImproc, STATUS

3. C

   -DISPLAY GROUP DETAIL

4. D

   -DISPLAY DATABASE (DSNDB06)

Reveal answer details Close answer details

Correct answerC

Question 11

Single choice

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?

1. A

   A view

2. B

   Multilevel security

3. C

   An MQT (Materialized Query Table)

4. D

   A combination of row permissions and column masks

Reveal answer details Close answer details

Correct answerC

Question 12

Single choice

Which of the following SELECT statements returns a different data value than the other SQL statements?

1. A

   SELECT MONTH (CURRENT TIMESTAMP) FROM SYSIBM.SYSDUMMY1;

2. B

   SELECT EXTRACT(MONTH FROM CURRENT TIMESTAMP) FROM SYSIBM.SYSDUMMY1;

3. C

   SELECT LPAD(LTRIM(SUBSTR(CHAR(CURRENT TIMESTAMP(10)),6,2),'0'),11,'') FROM
   SYSIBM.SYSDUMMY1;

4. D

   SELECT TIMESTAMPDIFF(64, CHAR(CURRENT TIMESTAMP ?TIMESTAMP(`2016-01-01-
   00.00.00'))) FROM SYSIBM.SYSDUMMY1;

Reveal answer details Close answer details

Correct answerD

Question 13

Single choice

Which statement is TRUE regarding ROLLBACK processing?

1. A

   It only reads active logs

2. B

   It always needs archive logs

3. C

   It can never be processed just from memory

4. D

   It uses output buffers, active and archive logs

Reveal answer details Close answer details

Correct answerD

Question 14

Single choice

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?

1. A

   REAL

2. B

   BIGINT

3. C

   DECIMAL

4. D

   INTEGER

Reveal answer details Close answer details

Correct answerC

Explanation

References:
https://www.ibm.com/support/knowledgecenter/en/SS6NHC/com.ibm.swg.im.dashdb.sql.ref.doc/doc/r0000791.html

Question 15

Multiple choice

The PERIOD BUSINESS_TIME clause on a DDL statement is used in which of the following? (Choose two.)

1. A

   A bitemporal table

2. B

   A system-period temporal table

3. C

   A created global temporary table

4. D

   A declared global temporary table

5. E

   An application-period temporal table

Reveal answer details Close answer details

Correct answersA, E

Explanation

References:
http://enterprisesystemsmedia.com/article/traveling-through-time-with-temporal-tables-in-db2-10-for-luw/6#sr=g&m=o&cp=or&ct=-tmc&st=(opu%20qspwjefe)
&ts=1563652020

Question 16

Single choice

How can a stored procedure be invoked?

1. A

   Via an SQL SELECT statement

2. B

   Via a CALL statement using SPUFI

3. C

   Directly via a RUN PROGRAM command

4. D

   Via a CALL statement from within an application program

Reveal answer details Close answer details

Correct answerD

Explanation

References:
https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/sqlref/src/tpc/
db2z_sql_call.html

Question 17

Single choice

Which DB2 address space manages DB2 locking?

1. A

   IRLM

2. B

   DIST

3. C

   DBM1

4. D

   MSTR

Reveal answer details Close answer details

Correct answerA

Explanation

References:
https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/inst/src/tpc/
db2z_irlmaddrspcstgreq.html

Question 18

Single choice

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

1. A

   A simple table space

2. B

   A universal table space

3. C

   An auxiliary table space

4. D

   A classic segmented table space

Reveal answer details Close answer details

Correct answerB

Explanation

References:
https://community.toadworld.com/platforms/ibmdb2/w/wiki/6841.clone-tables

Question 19

Single choice

Which type of lock is obtained when using a `WITH UR' clause on an SQL SELECT statement in a data- sharing environment?

1. A

   U-lock

2. B

   S-lock

3. C

   P-lock

4. D

   No lock is obtained

Reveal answer details Close answer details

Correct answerD