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: 21

Which Informix utility is useful in debugging failedtransactions, the time period of a transaction, and changes that are made to a tablespace?

  1. onlog

  2. onload

  3. onbar

  4. onunload

Answer: A

Question No: 22

Which of the following components is used to create, schedule, and execute maintenance,monitoring and administrative tasks?

  1. Scheduler

  2. Optimizer

  3. PDQ

  4. ON-Bar

Answer: A

Question No: 23

Which of the following Informix security methods protects network data transmitted between a server and a client?

  1. Set-column level encryption

  2. Cell-level encryption

  3. Column-level encryption

  4. Network data encryption

Answer: D

Question No: 24

Which Informix utility can be used to create a snapshot of an instance, including the data?

  1. dbaccess

  2. onspaces

  3. onbar

  4. ifxdeploy

Answer: D

Question No: 25

What can be used to generate a custom configuration for DSS and/or OLTP environments?

  1. onconfig

  2. onstat

  3. ifxclone

  4. genoncfg

Answer: D

Question No: 26

Which of the following statements about the ontape utility is TRUE?

  1. Itcan be used to backup a database to a tape device or file system, or directory.

  2. It can be used to backup operating system files in addition to databases.

  3. It can be used to backup and restore different storage spaces in parallel.

  4. It can be used tobackup a database to tape devices only.

Answer: A

Question No: 27

A small dentist office uses Informix as the backend database for their operational system. A small Intel-based system with a single processor and 2 GB of memory is used. It also runs theWindows operating system. Which edition of Informix is the minimum required?

  1. Informix Growth Edition

  2. Informix Ultimate Edition

  3. Informix Choice Edition

  4. Informix Innovator-C Edition

Answer: D

Question No: 28

In which segment of database shared memory are bufferpools created by default?

  1. Resident portion

  2. Flash portion

  3. Extended portion

  4. Volatile portion

Answer: A

Question No: 29

Which of the following is a key benefit of Informix?

  1. Database extensions can be added to supportnew business problem domains.

  2. Chunks can be two gigabytes in size.

  3. Uptime of at most 80% can be achieved using continuous availability features.

  4. Databases can be administered by a local database administrator.

Answer: A

Question No: 30

What isthe purpose of the sysmaster database?

  1. To provide information about the current state of the database server.

  2. To provide an entry point so you can change tablespaces.

  3. To allow you to modify data within tables.

  4. To allow you to drop a database or any of its tables.

Answer: A

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