REAL QUESTIONS SUBMIT MATERIAL ADVERTISE
Braindumps

Microsoft

Cisco

Citrix

CIW

CompTia

CWNA

Apple

Adobe

HP

Legato

Exin

Filemaker

Brocade

Ericsson

TIA

Veritas

ISEB

SCP

IISFA

ISM

OMG

Apc

Mile2

Foundry

Huawei

McData

Symantec

TeraData

RedHat

Solar Winds

Blue Coat

Riverbed

 

 
 
Click on name of dumper to view the dump
 

Gavrilla

 
 

 

Braindumps of 000-706
DB2 UDB v8.1 for Linux, UNIX and Windows
Database Administration Upgrade

Exam Questions, Answers, Braindumps (000-706)

Hi all.
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.

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

000-706


 

 

Braindumps Real exam questions and verified answers - 100% passing guarantee - cheap prices.

 

Free brain dumps Braindumps, notes, books for free

 

Braindumps and Exams - Instant download real exam questions - Passing guarantee.

Follow us on FaceBook
Braindumps on Facebook
 
 
 
 
 

CheckPoint

Linux

Novell

DB/2

Network Appliance

EC-Council

Nortel

McAfee

Juniper

ISACA

PMI

Sybase

EMC

HDI

SNIA

ISC

Sair

IBM

Lotus

Exam Express

3COM

BICSI

DeLL

Enterasys

Extreme Networks

Guidance Software

Computer Associates

Network General

SAS Institute

Alcatel Lucent

SeeBeyond

TruSecure

Polycom

Hyperion

Hitachi

Nokia

Fortinet

Vmware

Fujitsu

Tibco

Intel

PostgreSQLCE

BusinessObjects

RESSoftware

BlackBerry

AccessData

ICDL

Isilon

SAP

The Open Group

ACSM

Altiris

Avaya

Cognos

F5

Genesys

SDI

ACI

ASQ

Google

H3C

HIPAA

HRCI

SOA

IIBA

Zend