FREE IBM Certification SQL Database Question and Answers

Question 1

Which of the following settings must be specified if Secure Sockets Layer is necessary to encrypt data in transit?

Accepted Answer

Set the DB2COMM registry variable to DB2COMM=SSL, TCPIP

Answer

Set the AUTHENTICATION configuration parameter to SERVER_ENCRYPT

Answer

Set the AUTHENTICATION configuration parameter to DATA_ENCRYPT

Answer

Set the DB2COMM registry variable to DB2COMM=SSL

Question 2

Which of the following, exclusively for the instance db2inst1, will set the DB2 FMP COMM HEAPSZ registry variable for Linux and Unix systems to 1 GB (or 256000 pages)?

Accepted Answer

As the db2 instance owner (db2inst1) execute the command:db2set i DB2_FMP_COMM_HEAPSZ=256000

Answer

As the db2 instance owner (db2inst1)execute the command:db2set i db2inst1 DB2_FMP_COMM_HEAPSZ=256000

Answer

Add to the following line to the userprofile (db2inst1): DB _FMP_COMM_HEAPSZ=256000

Answer

As the db2 instance owner (db2inst1) execute the command:exportDB2_FMP_COMM_HEAPSZ=256000

Question 3

An XML storage object dictionary already exists, and the table MYTABLE has an XML column. What happens if compression is enabled and REORG TABLE mytable KEEPDICTIONARY is then executed?

Accepted Answer

Existing data will remain uncompressed because the RESETDICTIONARY option of the REORG command was not used.

Answer

New and existing XML columns will be compressed but other columns remain unchanged.

Answer

Only new or updated data for XML columns will be compressed.

Answer

All data, both new and existing, will becompressed.

Question 4

To obtain the current encryption settings for a database protected by native encryption, which of the following activities is required?

Accepted Answer

Check ENCROPTS database configuration parameter for encryption options

Answer

Checkthe encrypted database parameter in database configuration

Answer

Run the db2ckbkp command and verify the compression settings

Answer

Select from the ADMIN_GET_ENCRYPTION_INFO table function

Question 5

What does the built-in global variable TRUSTED_CONTEXT in DB2 have as its schema name?

Accepted Answer

SYSIBM

Answer

SYSIBMADM

Answer

SYSCAT

Answer

SYSFUN

Question 6

What is the Data Server Manager (DSM) statement that is TRUE?

Accepted Answer

DSM can be used to efficiently monitor, analyze, identify, and solve a performance issue

Answer

DSM can be used for configuration management of DB2 Data Server drivers

Answer

DSM cannot be used for database administration

Answer

DSM can be used for reviewing audit trails

Question 7

Which of the following assertions regarding auditing procedures is TRUE?

Accepted Answer

If a user is switched within a trusted connection, the applicable audit policies are re- evaluated for the new user without regard to audit policies for the original user.

Answer

The audit policy applied to a table is automatically applied to any view based on that table.

Answer

Multiple audit policies can be associated with the same table at the same time.

Answer

Audit policy changes are applied instantly and affect all inflight transactions.

Question 8

What choices are acceptable for an online reorganization operation?

Accepted Answer

FULL and RECLAIM EXTENTS

Answer

CLEAN OVERFLOWS and RECLAIM EXTENTS

Answer

FULL and CLEANUP OVERFLOWS

Answer

CLASSIC and RECLAIM EXTENTS

Question 9

Which command in a DB2 pureScale system enables explicit hierarchical locking (EHL)?

Accepted Answer

UPDATE DB CFG USING CF_LOCK_SZ AUTOMATIC

Answer

UPDATE DB CFG USING LOCKLIST AUTOMATIC MAXLOCKS AUTOMATIC

Answer

UPDATE DB CFG USING LOCKLIST 4096 MAXLOCKS 90

Answer

UPDATE DB CFG USING OPT_DIRECT_WRKLD YES

Question 10

Which of the following commands will display a list of every disk configuration for a DB2 pureScale cluster's DATAFS file system?

Accepted Answer

db2cluster –cfs –listconfig –filesystem datafs

Answer

db2cluster –cfs –displayconfig –filesystem datafs

Answer

db2cluster –cfs –display –filesystem datafs

Answer

db2cluster –cfs –list –filesystem datafs