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

To enable Secure Sockets Layer (SSL) encryption for data in transit in DB2, the DB2COMM registry variable must be configured to include SSL. By setting `DB2COMM=SSL, TCPIP`, DB2 is instructed to listen for both SSL-encrypted and unencrypted TCP/IP connections, allowing for secure communication. This ensures that data exchanged between clients and the DB2 server is encrypted.

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

The `db2set` command is used to manage DB2 registry variables. The `-i` option specifies that the setting applies to the current instance, and `DB2_FMP_COMM_HEAPSZ=256000` sets the FMP communication heap size to 256000 pages (which is 1GB if a page is 4KB). This command must be executed by the instance owner to apply the change specifically to that instance.

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

When an XML storage object dictionary already exists and `REORG TABLE mytable KEEPDICTIONARY` is executed, the existing dictionary is preserved. This means that only new or updated data will be compressed using the existing dictionary, while previously uncompressed data remains in its original state. To compress existing data, the `RESETDICTIONARY` option would be required to rebuild the dictionary and recompress all data.

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

For a database protected by native encryption in DB2, the `ENCROPTS` database configuration parameter stores the encryption options. Checking this parameter allows administrators to determine the current encryption settings, such as the encryption algorithm and key management details, applied to the database. This is the primary method for verifying native encryption settings.

Question 5

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

Accepted Answer

SYSIBM

Answer

In DB2, `SYSIBM` is the schema name for many built-in global variables, functions, and system catalog views. The `TRUSTED_CONTEXT` global variable, which provides information about the trusted context under which a session is running, resides within this system schema. This schema is reserved for system objects and ensures consistency across DB2 installations.

IBM Certification Practice Test

IBM Certification Practice Test

Free IBM Certification SQL Database Question and Answers