An audit trace shows that TSO user TSOID1 with DBADM authority, is continually attempting to update a table in DB2 subsystem DSN1 that is not supposed to be updated. Which of the following will prevent access to the DB2 subsystem?

Which explicit system privileges allows the user to create new plans and packages without being able to also execute them?

What parameter and option must be set before using a DB2 DBMS?

Which of the following RACF profiles would be used to allow IMS to access DB2 DSN1?

To set up a client that can access DB2 UDB through DB2 Connect Enterprise Edition, which of the following is the minimum software client that must be installed?

What does it mean if the the null indicator = -1

Which is correct about the EXPLAIN statement

A DBA needs to use the DSN command processor to delete DB2 packages that are no longer needed. Which of the following choices is correct for the DBA to use?

What type of parameter is “dbheap”?

What is one way that a query might be rewritten?

To prepare an embedded SQL program for use with a host-language compiler, which of the following database components is required?