pass4sure ibm 000-706

By PassGuide-IBM Study Guide | Oct 11, 2008
Visited 170 times, 1 so far today

db2 v8.1 for linux,unix and windows db admin upgrade : 000-706 Exam
Test Information:
• Number of questions: 30
• Time allowed in minutes: 40
• Required passing score: 55%

Related certifications:
• IBM Certified Database Administrator — DB2 Universal Database V8.1 for Linux UNIX and Windows
• IBM Certified Advanced Database Administrator – DB2 9 for Linux UNIX and Windows
• IBM Certified Application Developer – DB2 9

Exam Topics Include:
• DB2 Server Management
• Data Placement
• Database Access
• Monitoring DB2 Activity
• DB2 Utilities
• Backup and Recovery
Product Description

Exam Number/Code: 000-706

Exam Name:db2 v8.1 for linux,unix and windows db admin upgrade

“db2 v8.1 for linux,unix and windows db admin upgrade”, also known as 000-706 exam, is a IBM certification. With the complete collection of questions and answers, Pass4sure has assembled to take you through 60 questions to your 000-706 Exam preparation. In the 000-706 exam resources, you will cover every field and category in DB2 helping to ready you for your successful IBM Certification.

Exam Details

Job Role Description / Target Audience If you are knowledgeable with DB2 Universal Database V8.1 and are capable of performing the intermediate to advanced skills required in the day-to-day administration of DB2 instances and databases, you may benefit from this certification role. To attain the IBM Certified Database Administrator – DB2 UDB V8.1 for Linux, UNIX and Windows certification, candidates must either pass 2 tests or be certified as an IBM Certified Solutions Expert – DB2 Universal Database V7.1 Database Administration for UNIX, Windows and OS/2 and pass 1 test.

QUESTION 1:

Given the following command
Create database payroll alias paynew on path/drive
Using codeset codesst Territory territory 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

Answer: A

QUESTION 2:

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.” Sqlstate=42501
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

Answer: C

QUESTION 3:
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

Answer: B

QUESTION 4:

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 Answer: C
QUESTION 5:

The status of jobs scheduled by the Task Center can be monitored using which of the following?

A. Journal
B. Health Center
C. Snapshot Monitor
D. Information Catalog Center

Answer: A

QUESTION 6:

Which of the following authorities can be used to following through database logo. But
NOT restore a backup image into a new database?

A. DBADM B. SYSADM C. SYSCTRL
D. SYSMAINT Answer: A
QUESTION 7:

Giving the following information:
1. A full database backup of DB1 was tacken at 1:00 PM
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 Answer: B.D
QUESTION 8:

A table is experiencing frequent inserts. Which of the following options can defer how frequently DB2 must allocate additional index pages?

A. CLUSTER B. PCTFREE
C. MINPCTUSED
D. SPECIFICATION ONLY Answer: B
QUESTION 9:
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 Answer: C
QUESTION 10:

Exhibit
Which of the statements and in what order must they be called to prevent normal users from seeing SALARIES, but allow them to see NAMES?

A. 1
B. 2

*pass4sure ibm 000-706 Questions and Answers : 60 questions
* Updated: October 2nd , 2008
* Price: $159.99 $99.99
Free down:Testking ibm 000-706
Free down:Pass4sure ibm 000-706