Latesttests
2017 Jan IBM Official New Released P2090-068
100% Free Download! 100% Pass Guaranteed!
http://www.Latesttests.com/P2090-068.html

IBM Information Management Informix Technical Mastery Test v3

Question No: 1

The Flexible Grid technology of Informix offers which of the following benefits?

  1. The ability to communicate with other non-IBM products.

  2. The ability to perform administrative tasks on multiple sites from a single server with no downtime.

  3. The ability to replicate data between different versions and editions of Informix.

  4. Theability to achieve redundancy using expensive hardware and third party software.

Answer: B

Question No: 2

Which of the following is a valid VP class?

  1. PDQ

  2. AIO

  3. MACH11

  4. OBJ

Answer: B

Question No: 3

At the operating system level, what is thename of every Informix process?

  1. informix

  2. oninit

  3. cpuvp

  4. root

Answer: B

Question No: 4

In which of the following scenarios is Informix the best fit?

  1. Applications with variable and dynamic data records.

  2. Large data warehouses requiring cubing and complex multi-dimensional queries.

  3. Applications requiring dedicated hardware as part of the solution.

  4. High-transaction OLTP workloads.

Answer: D

Question No: 5

Which Informix utility allows you to change the logging mode for one or more databases?

  1. oninit

  2. ondblog

  3. onmode

  4. ondbmode

Answer: B

Question No: 6

Which of the following is a Database-level privilege?

  1. CONNECT

  2. EXECUTE

  3. SELECT

  4. REFERENCES

Answer: A

Question No: 7

Which disposition type is not allowed withthe ifxclone utility?

  1. rss

  2. er

  3. Blank.

  4. sds

Answer: D

Question No: 8

Which of the following administrative processes can Informix handle automatically?

  1. Online Archival

  2. Storage Provisioning

  3. Database schema optimization

  4. Datare-distribution

Answer: B

Question No: 9

Which type of high availability server maintains a backup copy of the entire database that applications can access immediately in the event of a catastrophic failure of the primary server?

  1. Remote Primary Server (RPS)

  2. Remote Standalone Secondary (RSS)

  3. Continuous Log Restore (CLR)

  4. High Availability Data Replication (HDR) Secondary

Answer: D

Question No: 10

What is an advantage of using Multi-Index scan?

  1. Multiprocessor support

  2. Multiple disk drive support

  3. Index keys are stored in compressed format

  4. Less indexes need to be defined on a table

Answer: D

100% Free Download!
Download Free Demo:P2090-068 Demo PDF
100% Pass Guaranteed!
Download 2017 Latesttests P2090-068 Full Exam PDF and VCE

Latesttests ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2017 Latesttests IT Certification PDF and VCE