61.
A database administrator needs to benchmark a database for both SQL and XQUERY.What utility can be
used to accomplish this task?
- A.db2batch
- B.db2explain
- C.db2analyze
- D.db2benchmark
- Answer
- Report
Answer : [A]
62.
Given the following situation:
Table space ts1 with tables t1, t2, t3
Table space ts2 with tables t4, t5
Tables t1 and t4 have defined referental integrity on them(t1 is the parent, t4 is the child)
What happens after restoring the table space ts1 and issuing the following command? db2 rollforward db sample to 2006-06-16-14.21.56 and stop tablespace(ts1)
Table space ts1 with tables t1, t2, t3
Table space ts2 with tables t4, t5
Tables t1 and t4 have defined referental integrity on them(t1 is the parent, t4 is the child)
What happens after restoring the table space ts1 and issuing the following command? db2 rollforward db sample to 2006-06-16-14.21.56 and stop tablespace(ts1)
- A.The roll forward is executed to the end of logs.
- B.The roll forward is not executed and an error message is generated.
- C.The roll forward is executed and table t4 is placed in set integrity pending state.
- D.The roll forward is executed and tables t1 and t4 are placed in set integrity pending state.
- Answer
- Report
Answer : [C]
63.
Which of the following utilities provides a report of memory status for instances, databases, and agents?
- A.db2mtrk
- B.db2mchk
- C.db2expln
- D.db2memview
- Answer
- Report
Answer : [A]
64.
Which of the following REORG table options will compress the data in a table using the existing
compression dictionary?
- A.KEEPEXISTING
- B.KEEPDICTIONARY
- C.RESETDICTIONARY
- D.EXISTINGDICTIONARY
- Answer
- Report
Answer : [B]
65.
Which of the following statements about SCHEMA objects is true?
- A.A schema must always be associated with a user.
- B.Triggers and sequences do not have schemas associated with them.
- C.After creating a new database, all users who successfully authenticate with the database have the ability to create a new schema.
- D.If a schema is not explicitly specified in a SQL statement, the PUBLIC schema is assumed.
- Answer
- Report
Answer : [C]
|
|
||||||||||||||||||||||||||||
