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
 

Reynard

 
 

 

Braindumps of 000-704
DB2 UDB V8.1 for Linux,
UNIX and Windows Advanced Database

Exam Questions, Answers, Braindumps (000-704)

Thanks to www.exams.ws and www.examcheats.net

Q No: 1
When creating a regular DMS table space, what is the minimum number of extents that must be specified?
A. 1
B. 3
C. 4
D. 6
E. 8
Answer: D
Q No: 2
Given the following table definition and SQL statement
CREAT TABLE company
(company_id INTEGER
company_name VARCHAR (40)
amount_due Decimal (15,2)
SELECT company_id
From company
WHERE amount_due =
SELECT MAX (amount_due) FROM company)"
Which index definition would provide the best performance for the SQL statement?
A. CREATE INDEX i1 ON company (amount_due ASC)
B. CREATE INDEX i1 ON company (amount_due DESC)
C. CREATE INDEX i1 ON company (company_id,amount_due)
D. CREATE INDEX i1 ON company (amount_due DESC) INCLUDE(company_id)
Answer: B
Q No: 3
A table is defined using DMS table spaces with its index, data, and long data separated into different table spaces. The table space containing the table data is restored from a backup image. Which of the table's other table spaces must also be restored in order to roll forward to a point in time prior to the end of the logs?
A. Long table space
B. Index table space
C. Temporary table space
D. Index and long table spaces
Answer: D.
Q No: 4
Given the following DDL statement
CREATE TABLE "RMW" "TABEL46"
"11" INTEGER'
"D11" DECIMAL (1'0)NOT NULL'
"D12" DECIMAL (1'0) NOT NULL'
"S7" SMALLINT'
"C8" CHAR(1) WITH DEFAULT ' ')
organize by (
("D12" ;"D11"))
How many indexes will be created?
A. 1
B. 2
C. 3
D. 4
Answer: C
Q No: 5
Which of the following is required for the DB2 optimizer to consider a hash join strategy?
A. Equijion predicates
B. Optimization level 1 or above
C. Registry variable DB_ANTIJOIN=YES
D. SORTHEAP large enough to contain the tables being joined
Answer: A
Q No: 6
Which two of the following table space attributes can be changes after the table space has been created?
A. Page size
B. Extent size
C. Transfer rate
D. Table space type
E. Table space name
Answer: B,E
Q No: 7
The DBA can set the registry variable DB2_HASH_JOIN on or off because:
A. hash joins may require more resources to run.
B. hash joins are not used unless outer joins are requested.
C. If hash joins are enabled, no other join method can be used.
D. Hash joins are only needed when the tables are portioned using hash keys.
Answer: A
Q No: 8
Which of the following can be kept in memory when the DB2 configuration parameter KEEPFENCED is enabled?
A. SQLDAS after their cursor is closed.
B. Referential integrity maps after a join.
C. Stored procedure processes after they are run.
D. Tables after they have been read into the buffer pool.
Answer: C

000-704


 

 

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