Q: - Which of the following is NOT a valid method of authentication that can be used by DB2 9?

A. SERVER

B. SERVER_ENCRYPT

C. CLIENT

D. DCS

The correct answer is D. In DB2 9, the following authentication types are available: SERVER, SERVER_ENCRYPT, CLIENT, KERBEROS, KRB_SERVER_ENCRYPT,DATA_ENCRYPT, DATA_ENCRYPT_CMP, GSSPLUGIN, and GSS_SERVER_ENCRYPT. (Although DCS was a valid method of authentication in DB2 UDB Version 7.x, it is no longer supported.)

Submitted By:-Vikas             Email-ID: - vikas123.singh@yahoo.com

Q: -In which of the following scenarios would a stored procedure be beneficial?

A. An application running on a remote client needs to be able to convert degrees Celsius to degrees Fahrenheit and vice versa

B. An application running on a remote client needs to collect three input values, perform a calculation using the values provided,and store the input data, along with the results of the calculation in two different base tables

C. An application running on a remote client needs to track every modification made to a table that contains sensitive data

D. An application running on a remote client needs to ensure that every new employee that joins the company is assigned a unique, sequential employee number

The correct answer is B. A scalar user-defined function would be the best option for the requirements outlined in answer A; an UPDATE trigger and a DELETE trigger that inserts records into an activity table every time update and delete operations are performed on a table containing sensitive data would be the best way to accomplish the requirements outlined in answer C; and an identity column or sequence could be used to address the requirements shown in answer D.

Submitted By:- Vikas            Email-ID: - vikas123.singh@yahoo.com