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
 
Walker
 
 

 

Braindumps of 000-918
System Administration for IBM Informix Dynamic Server V11

 

Exam Questions, Answers, Braindumps (000-918)
Thanks to www.exams.ws and www.examcheats.net


QUESTION 1
You detected excessive memory usage that might be caused by a memory leak in the application. Which two commands would be useful in this scenario? (Choose two.)
A. onstat -u
B. onstat -g sql -r 120
C. onstat -g ses -r 60
D. onstat -g mgm
E. onstat -g mem
ANS C, E


QUESTION 2
A user wants to save SQL explain output to the file: /tmp/myexplain.out. Which syntax should be used?
A. set explain on file to /tmp/myexplain.out
B. set explain on file /tmp/myexplain.out
C. set explain file /tmp/myexplain.out
D. set explain file to /tmp/myexplain.out
ANS D


QUESTION 3
Both standard and temporary dbspaces are listed in the DBSPACETEMP configuration parameter or environment variable. Which rule applies?
A. Sort, backup, implicit, and non-logging explicit temporary tables are created in temporary dbspaces if adequate space exists.
B. Backup, implicit, and non-logging explicit temporary tables are created in temporary dbspaces if adequate space exists. Sort temporary tables are specified by the PSORT_DBTEMP environment variable.
C. Sort, backup, implicit, and non-logging explicit temporary tables are created in all available dbspaces if adequate space exists.
D. Explicit temporary tables created without the WITH NO LOG option are created in the root dbspace.
ANS A


QUESTION 4
You are receiving an error when trying to drop a chunk that you think is empty. Which command will show you if any object is still allocating part of the chunk?
A. oncheck -pe
B. onstat -d
C. oncheck -cD
D. oncheck -cc
ANS A


QUESTION 5
How can a database administrator remotely view the entire online.log?
A. Query the sysadmin database command_history table.
B. Execute oncheck -showlog.
C. Query the sysmaster database sysonlinelog table.
D. Execute onstat -m.
ANS C


QUESTION 6
Which two utilities will help a database administrator diagnose problems with IDS archive media? (Choose two.)
A. oncheck
B. onlog
C. onbar
D. archecker
E. onmonitor
ANS C, D


000-918


 

 

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