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
 
Adrian
 
 

 

Braindumps of 000-731
DB2 9 DBA for Linux UNIX and Windows

 

Exam Questions, Answers, Braindumps (000-731)
Thanx to www.examcheats.net for providing helpful material.Here is my contribution.


QUESTION 1
Which of the following event monitor types is defined and active for all by default?
A. DATABASE
B. DEADLOCKS
C. BUFFERPOOLS
D. CONNECTIONS
Answer: B
QUESTION 2
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: A
QUESTION 3
Which of the following TWO commands will apply AUTOCONFIGURE recommended changes to buffer pools?
A. AUTOCONFIGURE USING <options> APPLY NONE
B. AUTOCONFIGURE USING <options> APPLY DB ONLY
C. AUTOCONFIGURE USING <options> APPLY db AND dbm
D. AUTOCONFIGURE USING <options. APPLY BUFFERPOOLS ONLY
E. AUTOCONFIGURE USING <options> APPLY DB AND BUFFERPOOLS ONLY
Answer: B,C
QUESTION 4
Which of the following settings would allow 20 sorts with a maximum of 10MB each to run currently on a 64-bit instance?
A. Set the DB SHEAPTHERS to 50000 and DB SORTHEAP to 2500
B. Set the DBM SHEAPTHERES to 50000 and DB SORTHEAP to 2500
C. Set the DBM SHEAPTHERS to 50000 and DBM SORTHEAP to 2500
D. Set the DBM SHEAPTHERS_SHR to 50000 and DBM SHEAPTHRES to 2500
Answer: B
QUESTION 5
Which of the following is the most complete list of methods by which the EXPORT utility can be invoked?
A. Control Center and the CLP
B. Control Center, CLI and the CLP
C. Control Center, CLP and the ADMIN_CMD stored procedures
D. Control Center, CLI,CLP and ADMIN_CMD stored procedures
Answer: D
QUESTION 6
Which of the following authorities should a user have in order to QUIESCE the DB2 instance?
A. DBADM
B. SECADM
C. SYSMON
D. SYSMAINT
Answer: D
QUESTION 7
A Database administrator has HADR enabled and wants to do a LOAD WITH COPY NO option on the primary server. What happens on the standby server?
A. The Load is replicated without problems
B. The Load will stop with an appropriate error message
C. The Load will be automatically converted to NONRECOVERABLE and the standby database will be marked bad
D. The Load will be automatically converted to COPY YES if the directory or device specified on the primary server is accessible for the standby database
Answer: C
QUESTION 8
A Recovery of database DB1 is started by issuing RECOVERY DATABSE DB1 TO END Of LOGS. The Recovery fails during the rollforward phase. In order to continue the recovery from the point of failure, which of the following commands should be executed?
A. RECOVER DATABASE DB1 TO RESTART
B. RECOVER DATABSAE DB1 TO END OF LOGS
C. RECOVER DATABSAE DB1 TO END OF LOGS RESTART
D. RECOVER DATABSAE DB1 CONTINUE TO END OF LOGS
Answer: B

000-931


 

 

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