Ensurepass.com : Ensure you pass the IT Exams
2017 Nov IBM Official New Released C2090-919
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/C2090-919.html

Informix 11.70 System Administrator

Question No: 41 – (Topic 1)

Which environment option can rollback transactions using a table involved in an ALTER FRAGMENT ON TABLE operation?

  1. FORCE_DML_EXEC

  2. FORCE_DDL_EXEC

  3. ROLLBACK_DML_EXEC

  4. ROLLBACK_DDL_EXEC

Answer: B

Question No: 42 – (Topic 1)

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.

Answer: D,E

Question No: 43 – (Topic 1)

If the DYNAMIC_LOGS onconfig parameter is set to 1 and logical log backups are not occurring, what will happen in the instance when the last logical-log file fills?

  1. The instance suspends all processing until the next logical-log file is manually added.

  2. The database server will automatically execute a checkpoint and flush the oldest update

    to disk.

  3. The database server will make use of any logical-log file available regardless of whether the available file is in sequence or not.

  4. The database server will stop processing, then start an automatic backup of the logical- log file and resume normal processing once the automatic back up of the logical-log files is completed.

Answer: A

Question No: 44 – (Topic 1)

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

Answer: C,E

Question No: 45 – (Topic 1)

Given the SQL explain output of this star join query, which is the fact table?

Ensurepass 2017 PDF and VCE

  1. sales

  2. product

  3. region

  4. customer

Answer: A

Question No: 46 – (Topic 1)

When adding space to the storagepool, which correctly describes the type of storage which may be placed in the storagepool?

  1. Cooked file only.

  2. Raw devices only.

  3. Cooked files and Raw devices only.

  4. Cooked files, Raw devices and Directories.

Answer: D

Question No: 47 – (Topic 1)

What output is NOT reported by the dbschema utility?

  1. The database logging mode.

  2. The schemas of remote databases.

  3. The table definitions without owner names.

  4. The onspaces commands to re-create your systems#39; dbspaces.

Answer: A

Question No: 48 – (Topic 1)

Which statement about automatic space management is true?

  1. Spaces cannot be extended manually.

  2. Only unmirrored spaces can be extended.

  3. Mirrored and unmirrored spaces can be extended.

  4. The time interval for low storage space checks is not user configurable.

Answer: B

Question No: 49 – (Topic 1)

Which storage space should be used to store columns defined as a BLOB or a CLOB?

  1. sbspace

  2. dbspace

  3. extspace

  4. blobspace

Answer: A

Question No: 50 – (Topic 1)

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

Answer: A,D

100% Ensurepass Free Download!
Download Free Demo:C2090-919 Demo PDF
100% Ensurepass Free Guaranteed!
Download 2017 EnsurePass C2090-919 Dumps

EnsurePass 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 EnsurePass IT Certification PDF and VCE