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
 

Garrick

 
 

 

Braindumps of 000-513
DB/2 Administration for Windows, Linux & OS/2

Exam Questions, Answers, Braindumps (000-513)

Hi all. passed it today. It was easy. It’s my contribution.

QUESTION 1.
Given the following piece of a LIST APPLICATIONS output:
Exhibit missing. Will be fixed in later versions
Which of the following commands terminates the client application's connection?
A. KILL APPLICATION (7)
B. FORCE APPLICATION
C. DISCONNECT APPLICATION (7)
D. KILL APPLICATION payroll.exe
E. FORCE APPLICATION payroll.exe
F. DISCONNECT APPLICATION payroll.exe
Answer: F.
QUESTION 2.
Which of the following statements is TRUE?
A. DB2MOVE does not support LOBs.
B. DB2MOVE supports the data links data type
C. DB2MOVE supports DRDA data resources and targets.
D. DB2MOVE supports LOBs residing on disk in separate files
E. DB2MOVE supports exporting and importing trigger definitions
Answer: D.
QUESTION 3.
In which of the following locations must userids and passwords be defined if using authentication SERVER?
A. The node directory on the server
B. The node directory on the client
C. The system catalog on the server
D. The operating system on the server
E. The operating system on the client
Answer: D.
QUESTION 4.
Which of the following is NOT possible when issuing a FORCE command?
A. IDLE users can be successfully forced
B. Users creating a database can be forced
C. DB2STOP can be successfully executed during a force
D. The database will still successfully accept connections
Answer: C.
QUESTION 5
Given the command:
CREATE DATABASE inventory
CATALOG TABLESPACE MANAGED BY SYSTEM USING ('path1','path2')
EXTENTSIZE 16 PREFETCHSIZE 32
USER TABLESPACE MANAGED BY SYSTEM USING ('patha')
TEMPORARY TABLESPACE MANAGED BY DATABASE USING (FILE 'files' 1000)
WITH "EXTENTSIZE 8"
How many buffer pools are in the inventory database?
A. 0
B. 1.
C. 2
D. 3
E. 4
Answer: B.
QUESTION 6.
Given the following DDL statements:
CREATE TABLE PERSON OF PERSON_T (REF IS OID USER GENERATED)
CREATE TABLE EMP OF EMP_T UNDER PERSON INHERIT SELECT PRIVILEGES
CREATE TABLE STUDENT OF STUDENT_T UNDER PERSON INHERIT SELECT
PRIVILEGES
CREATE TABLE STAFF (COL1 INT, COL2 INT) and
INSERT 1 row into PERSON
INSERT 1 row into EMP
INSERT 1 row into STUDENT
INSERT 2 rows into STAFF
How many rows will be returned after issuing the SQL statement:
SELECT * FROM PERSON?
A. 1
B. 2
C. 3
D. 5
E. 10
Answer: C.
QUESTION 7.
Which of the following tasks is performed by the DB2 Query Patroller Tracker Utility?
A. Accepts, analyzes, prioritizes, and schedules database requests and optionally notifies users when their requests have been processed.
B. Enables the user to monitor query status, view job details, cancel jobs, submit new jobs, drop result tables, and resubmit completed jobs.
C. Allows you to determine which tables and columns have been accessed most frequently, which tables have returned the most result rows, and which jobs have been completed within a specific time period.
D. Enables the system administrator to manage the DB2 Query Patroller system parameters, create or delete profiles for DB2 Query Patroller users, manage nodes, result destinations, data sources and job queues.
Answer: C.

000-513

 

 

 

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