- All Exams Instant Download
Which is NOT a valid privilege/authority for executing CREATE TYPE (array)?
Which is NOT a valid privilege/authority for executing CREATE TYPE (array)?A . SYSADMB . SYSOPRC . SYSCTRLD . CREATEIN on the schemaView AnswerAnswer: A
Which DB2 subsystem parameter limits the number of concurrent active TSO requests?
Which DB2 subsystem parameter limits the number of concurrent active TSO requests?A . IDBACKB . IDFOREC . MAXDBATD . CONDBATView AnswerAnswer: B
Which utilities and service aids CANNOT help to provide useful additional info to diagnose the problem?
An application receives an 00C90110 reason code. See the following manual explanation of the code. " 00C90110The data manager detected an inconsistent data condition. This may be caused by an inconsistency in either the DB2P' catalog or the DB2 directory. In this case, the OBD for the requested OBID cannot...
Which type of column can be dropped from a table via the ALTER TABLE ... DROP COLUMN ... SQL statement?
Which type of column can be dropped from a table via the ALTER TABLE ... DROP COLUMN ... SQL statement?A . XML columnB . LOB columnC . DOCID columnD . Hidden ROWID columnView AnswerAnswer: A
What other DB2 supplied information could be reviewed to learn more about the updated data?
An Audit report shows that data on the CUSTOMER table was successfully updated by an unknown USERID. What other DB2 supplied information could be reviewed to learn more about the updated data?A . BSDSB . SYSIBC . SYSPACKDEPD . DB2 Active and Archive LogsE . SYSIBF . SYSAUDITPOLICIESView AnswerAnswer: D
Which statement regarding triggers is true?
Which statement regarding triggers is true?A . A trigger can use global variables and change their contents.B . A trigger can use global variables but cannot change their contents.C . A trigger cannot use global variables but can change their contents.D . A trigger cannot use global variables and cannot...
How would you find this information?
You are having problems accessing SYSIBM.SYSTABLES in your data sharing environment and you want to know who is using the table space DSNDB06.SYSTSTAB. How would you find this information?A . -DIS THREAD (') TYPE(SYSTEM)B . -DIS DB(DSNDB06) SP(SYSTSTAB) USEC . -DIS GROUPBUFFERPOOL(GBPO) CONNLIST(YES)D . -DIS BUFFERPOOL (BPO) DB(DSNDB06) SP(SYSTSTAB) LIST(ACTIVE)View...
