- All Exams Instant Download
Which of the following are contained in the PLAN_TABLE? (Choose two.)
Which of the following are contained in the PLAN_TABLE? (Choose two.)A . RUNSTATS recommendationsB . Access to LOB values, which are stored separately from the base tableC . Access to parent or dependent tables needed to enforce referential constraintsD . Whether an index access or table space scan is used...
Which job log would show all of these?
You want to see all messages that were generated by one specific DB2 subsystem such as log switches and timeout messages. Which job log would show all of these?A . MSTRB . DBM1C . DISTD . IRLMView AnswerAnswer: A
Which of the following is NOT TRUE?
Which of the following is NOT TRUE?A . An index can be created on XML columnsB . Length must be specified for an XML columnC . XML columns can be added to existing tablesD . Triggers can be created on tables with XML columnsView AnswerAnswer: D
Given the following table and index definitions, what type of index will be created?
Given the following table and index definitions, what type of index will be created? A . Non-partitioned indexB . Non-partitioned secondary indexC . Data-partitioned secondary indexD . Data-partitioned partitioning indexView AnswerAnswer: C
Which of the following statements concerning a bi-temporal table is TRUE?
Which of the following statements concerning a bi-temporal table is TRUE?A . It provides business history, but is not useful for audit purposesB . It is defined with both an application period and a system periodC . It is useful for audit purposes, but is not useful for business historyD...
Which of the following statements about a system-period temporal table is TRUE?
Which of the following statements about a system-period temporal table is TRUE?A . Rows can be archived into a history table which is always read onlyB . Every row has a pair of timestamps which is set and managed by the applicationC . AN SQL query for auditing can be...
Which of the following SQL constructs does NOT provide information about the success or failure of the SQL statement that was just executed?
Which of the following SQL constructs does NOT provide information about the success or failure of the SQL statement that was just executed?A . SQLCAB . SQLDAC . SQLCODED . SQLSTATEView AnswerAnswer: B
Which of the following are advantages of DB2 for z/OS data sharing over a standalone DB2 subsystem implementation? (Choose two.)
Which of the following are advantages of DB2 for z/OS data sharing over a standalone DB2 subsystem implementation? (Choose two.)A . Reduced active logsB . Reduced storage useC . Higher transaction ratesD . Reduced lock contentionE . Increased data availabilityView AnswerAnswer: CE
Which of the following statements must precede the CREATE statement so that you can create the index?
Your current authorization ID is DBA. Only one of your secondary authorization IDs, DB2, has the privilege to create an index DB2.AAA on a table. The appropriate SQL statement starts with “CREATE INDEX AAA ON…”. Which of the following statements must precede the CREATE statement so that you can create...
If a unit of work acquires 1001 locks against table space TS1, the lock will be escalated to which of the following levels?
Given a non-partitioned table space TS1 is built with LOCKSIZE ROW, LOCKMAX 1000 and SEGSIZE 64. If a unit of work acquires 1001 locks against table space TS1, the lock will be escalated to which of the following levels?A . PAGEB . TABLEC . PARTITIOND . TABLESPACEView AnswerAnswer: C
