DB2 UDB v8.1 for Linux, UNIX and Windows
Database Administration Upgrade
Exam Questions, Answers,
I think it was tough but thanks to www.examcheats.net
. I purchased their study material and got through.
The stuff had drag and drops, exhibits and all that
is required for the exam.
Given the following command
Create database payroll alias paynew on path/drive
Using codeset codesst
Collate using identity
How is character data compared within the database?
A. Byte for byte
B. Based on the codest
C. Based on the codepage
D. Based on the territory
Given the following statement
Drop table payroll. Employee"
Returns the following message.
Solo55in "user" does not have the priviege
to perform operation
"drop" on object "pavroll. Employee."
Which of the following will correct the situation?
A. GRANT DROP AUTHORITY TO user1
B. GRANT DROPIN ON SCHEMA user1 TO user1
C. GRANT DROPIN ON SCHEMA payroll TO user1
D. GRANT DROPIN ON SCHEMA employee TO user1
Which of the following is required to support infinite
active log space?
A. USEREXIT = ON, LOGSECOND = 0
B. USEREXIT = ON, LOGSECOND = -1
C. LOGRETAIN = RECOVERY, LOGSECOND = 0
D. LOGRETAIN = RECOVERY, LOGSECOND = -1
Which of the following commands can be issued in a Command
Line Processor (CLP) session to capture explain information
for subsequent SQL statements that can be formatted
using db 2exfmt?
A. SET CURRENT SNAPSHOT YES
B. SET CURRENT QUERY EXPLAIN
C. SET CURRENT EXPLAIN MODE EXPLAIN
D. SET CURRENT EXPLAIN SNAPSHOT EXPLAIN
The status of jobs scheduled by the Task Center can
be monitored using which of the following?
B. Health Center
C. Snapshot Monitor
D. Information Catalog Center
Which of the following authorities can be used to following
through database logo. But NOT restore a backup image
into a new database?
Giving the following information:
1. A full database backup of DB1 was tacken at 1:00
2. A table space TS1 was backed up at 1:15PM
3. A table in TS1 was dropped at 2:00 PM
Which two of the following commands are valid after
restoring table space TS1 from the full database backup
taken at 1:00PM?
A. ROLLFORWARD DATABASE db1 TO 1:15PM
B. ROLLFORWARD DATABASE db1 TO 2:30PM
C. ROLLFORWARD TABLESPACE ts 1 TO 2:30PM
D. ROLLFORWARD DATABASE db1 TO END OF LOGS
E. ROLLFORWARD TABLESPACE ts 1 TO END OF LOGS
A table is experiencing frequent inserts. Which of the
following options can defer how frequently DB2 must
allocate additional index pages?
D. SPECIFICATION ONLY
Which of the following requires each row in a table
to be unique?
A. A foreign key
B. A bidirectional index
C. An index with include columns
D. An index created using PCTFREE