Free IBM C1000-078 Exam Dumps Questions & Answers

Which type of trace is used to record transaction-level data that is written when the processing for a transaction is completed?

• A.Accounting
• B.Monitor
• C.Statistics
• D.Audit

The remote clients are receiving SQLCODE -30062 RDB ACCESS FAILURE, which means access to the database failed because the session data is expired. How can you increase the number of minutes that applications can remain inactive before the associated session data token becomes invalid because of timeout?

• A.Issue the -MODIFY DDF SESSIDLE command to increase session timeout
• B.Change the RESOURCE TIMEOUT field (IRLMRWT subsystem parameter)
• C.Change the POOL THREAD TIMEOUT field (POOLINAC subsystem parameter)
• D.Change the UTILITY TIMEOUT field (UTIMOUT subsystem parameter)

Before execution of the CHECK DATA utility, which of the following should be performed?

• A.Start the object in question with FORCE to remove any CHECK PENDING status
• B.Alter the object to remove any table or referential constraint definitions
• C.Execute CHECK INDEX on the primary key and foreign key indexes
• D.Execute the REPAIR utility with SET NOCHECKPEND

Which of the following is an advantage of role-based security?

• A.Within a trusted connection. DB2 allows multiple roles to be associated with any given thread at any point in time
• B.Roles are used to provide a more flexible technique than security group definitions or userids in assigning and controlling authorization
• C.If a role creates an object, a user requires no additional privileges to access the object if the access uses that role as the object owner in the SQL statement
• D.If you DROP a role that owns objects, those objects will also be dropped

When using a persistent thread bound with RELEASE(DEALLOCATE), which subsystem parameter setting will permit a REBIND PACKAGE at a COMMIT or ROLLBACK in this thread?

• A.ABIND=COEXIST
• B.BINDNV=BIND
• C.PKGREL COMMIT=YES
• D.APPLCOMPAT=YES