A2040-402 by IBM Valid Free Exam Practice Test

Question 1

Michael is creating his IBM Connections databases using the provided scripts for IBM DB2. However, whenever he attempts to execute any of the createDb.sql scripts he gets the following exception: "SQLCODE: -551, SQLSTATE: 42501, DOES NOT HAVE THE PRIVILEGE TO PERFORM OPERATION ON OBJECT". Which of the following best explains the reason Michael is seeing this issue?

A. He failed to follow all the steps required to create databases manually,specifically to execute the appGrants.sql script prior to running thecreateDb.sql script. B. He failed to follow all the steps required to create databases manually,specifically the one to issue the db2start command prior to executing thescripts. C. He failed to follow all the steps required to create databases manually,specifically to copy the db2jcc.jar and db2jcc_license_cu.jar files prior toexecuting the scripts. D. He failed to follow all the steps required to create databases manually,specifically the one to ensure that the owner ID has privileges to createdatabases,tablespaces,tables,and indexes prior to executingthe scripts.

Correct Answer: D

Question 2

How can an IBM WebSphere Application Server environment variable be changed?

A. Using an administrator ID,log into the IBM WebSphere Integrated Solutions Console. Expand Environment,and then click WebSphereVariables. Find the environment variable that needs to be changed and edit it from the list. Save and apply the changes,and then restart theserver. B. Edit the Variables.xml in the LotusConnections-config directory. Once this has been done the server will need to be restarted. C. Using an administrator ID,log into the WebSphere Integrated Solutions Console. Expand Servers,Server types and then WebSphereVariables. Find the environment variable that needs to be changed and edit it from the list. Save and apply the changes,and then restart theserver. D. This can only be done at the time of install.

Correct Answer: A

Question 3

Which statement about the IBM Connections database wizard is true?

A. Besides creating Connections databases,it can also upgrade IBM DB2 to the latest version,provided the install files are located on the samefile system. B. Connections databases can be created locally as well as remotely. C. Besides creating Connections databases,it can also be used to migrate from one database server to another. D. It can only be used to create,update and remove Connections databases.

Correct Answer: D

Question 4

Alla needs to gather logs to send to IBM Support. They are helping her resolve an issue she is having with the installation of an IBM Connections 4.0 environment on Red Hat Linux. Where might she find these files on her system?

A. /tmp/Connections/logs B. /opt/IBM/Connections/logs C. /opt/IBM/WebSphere/AppServer/profiles/AppSrv01/logs/server1 D. /opt/IBM/Connections/data

Correct Answer: B

Question 5

What attributes can be assigned to an employee in the EMPLOYEE table in the PEOPLEDB to indicate whether the employee is listed as a manager of other employees?

A. On or Off B. 1 or 2 C. M or N D. Y or N

Correct Answer: D

Question 6

What should Monica, the IBM Connections specialist, do in order to install Connections 4.0 as a non-root user?

A. Ensure that the non-root user has rwx permissions to the entire file system on the Linux system. B. Ensure that the group the non-root user belongs to has rwx permissions on appserver_root,connections_root,connections_setup,shared_resources,im_root and install_manager directories. C. Ensure that the user account created especially for this purpose is a member of the administrators group in Linux. D. Login to the Linux server using a specially named user account called ConnectionsInstaller.

Correct Answer: B

IBM Assessment: Administering IBM Connections 4.0 - A2040-402 Exam Practice Test