Download Informix 11.70 System Administrator.C2090-919.ActualTests.2015-03-25.123q.vcex

Vendor: IBM
Exam Code: C2090-919
Exam Name: Informix 11.70 System Administrator
Date: Mar 25, 2015
File Size: 494 KB
Download Exam

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAM_HUB

Discount: 20%

ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator

Demo Questions

Question 1
Without explicitly setting DBSPACETEMP and TEMPTABLE_NOLOG, where will temporary tables be created by default? (Choose three.)
  1. The root dbspace.
  2. The users' home directory.
  3. The $INFORMIXDIR/tmp directory.
  4. The dbspace in which the active database was created.
  5. The /tmp directory or PSORT_DBTEMP.
Correct answer: ADE
Explanation:
answer is perfected.
answer is perfected.
Question 2
What two onconfig parameters will help improve performance of new network connections? (Choose two.)
  1. NETTYPE
  2. VPCLASS
  3. NS_CACHE
  4. FET_BUF_SIZE
  5. NUMFDSERVERS
Correct answer: CE
Question 3
Given the following SQL command where the DBSPACETEMP onconfig and environment variables are set to valid dbspaces:
create temp table mytemp (columns) with no log;
in what order will the instance evaluate where to place this table?
  1. DBSPACETEMP environment variable, root dbspace, dbspace where the database was created, DBSPACETEMP onconfig parameter.
  2. DBSPACETEMP environment variable, DBSPACETEMP onconfig parameter, dbspace where the database was created, root dbspace.
  3. DBSPACETEMP onconfig parameter variable, DBSPACETEMP environment variable, root dbspace, dbspace where the database was created.
  4. DBSPACETEMP onconfig parameter variable, root dbspace, dbspace where the database was created, DBSPACETEMP environment variable.
Correct answer: B
Question 4
What ONCONFIG parameter can be tuned to increase memory for hash joins?  
  1. RESIDENT
  2. EXTSHMADD
  3. VP_MEMORY_CACHE_KB
  4. DS_NONPDQ_QUERY_MEM
Correct answer: D
Question 5
Which two options can be used to monitor PDQ resources? (Choose two.)
  1. onstat -l.
  2. onstat -p.
  3. onstat -D.
  4. onstat -g ath.
  5. SET EXPLAIN output.
Correct answer: DE
Question 6
Which statement about updating statistics is NOT true?
  1. UPDATE STATISTICS HIGH scans the entire table.
  2. Data distributions are updated every time UPDATE STATISTICS LOW is executed.
  3. UPDATE STATISTICS operations will benefit by tuning the DBUPSPACE environment variable.
  4. An UPDATE STATISTICS LOW command will ignore tables and indexes with modifications less than STATCHANGE.
Correct answer: B
Question 7
Most, but not all Virtual Processors, can be modified via the onmode -p command. Which CANNOT be modified?
  1. ADM
  2. BTS
  3. CPU
  4. CSM
Correct answer: A
Question 8
Which of the following gives a good initial estimate for the physical log size?
  1. 110% of rootdbs.
  2. 110% the default buffer pool.
  3. 110% of the logical log space.
  4. 110% of combined buffer pool.
Correct answer: D
Question 9
Which two onconfig parameters can be set to backup/restore to/from a cloud storage location? (Choose two.)
  1. TAPEDEV
  2. TAPEBLK
  3. LTAPEBLK
  4. LTAPEDEV
  5. BAR_BSALIB_PATH
Correct answer: AD
Question 10
Which two objects are NOT included in a backup? (Choose two.)
  1. Tables
  2. Indexes
  3. External tables
  4. Simple blob data stored in simple blobspaces
  5. Basic text search indexes stored in external dbspaces
Correct answer: CE
CONNECT US
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!