[Free] 2018(Jan) Dumps4cert Braindumps IBM C2090-919 Dumps with VCE and PDF Download 1-10

Dumps4cert.com : Latest Dumps with PDF and VCE Files 2018 Jan IBM Official New Released C2090-919
100% Free Download! 100% Pass Guaranteed!
http://www.Dumps4cert.com/C2090-919.html

Informix 11.70 System Administrator

Question No: 1 – (Topic 1)

Which $ONCONFIG parameter triggers an automatic increase to a chunk or space based on remaining free space?

  1. SP_AUTOGROW

  2. SP_THRESHOLD

  3. SP_AUTOEXPAND

  4. SP_CHUNKEXTEND

Answer: B

Question No: 2 – (Topic 1)

When executing the SQL Admin API quot;defragment tablequot; and quot;table repackquot; commands on the customer table, what will happen to the table? (Choose two.)

execute function sysadmin:task(quot;defragment tablequot;,quot;customerquot;); execute function sysadmin:task(quot;table repackquot;, quot;customerquot;);

  1. Fragments of a table will be combined.

  2. Rows will be moved to the beginning of table.

  3. Given sufficient resources the number of extents in the table will be reduced.

  4. Free space at the end of the table will be released to the dbspace for other tables to use.

  5. The table will be locked preventing inserts from happening for the duration of the commands.

Answer: B,C

Question No: 3 – (Topic 1)

Which sysmaster table can be queried to find the logging status of a database?

  1. sysdb

  2. sysdblog

  3. sysdatabases

  4. sysdblogstatus

Answer: C

Question No: 4 – (Topic 1)

To maximize the performance of your OnBar backup and recovery operations, what should you do?

  1. Use a commercial storage manager.

  2. Use the bundled Informix Storage Manager (ISM).

  3. Use a combination of disk-based and tape-based backup devices.

  4. Use separate storage devices for instance spaces and logical logs.

Answer: D

Question No: 5 – (Topic 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#39; home directory.

  3. The $INFORMIXDIR/tmp directory.

  4. The dbspace in which the active database was created.

  5. The /tmp directory or PSORT_DBTEMP.

Answer: A,D,E

Question No: 6 – (Topic 1)

Which onstat command will allow the gathering of statistics about the Informix Database Scheduler tasks that are currently running or scheduled to be run?

  1. onstat -g dbc

  2. onstat -g sch

  3. onstat -g adm

  4. onstat -g tsk

Answer: A

Question No: 7 – (Topic 1)

Which statement about in-place migration is true?

  1. In-place migration is possible when an Informix instance is migrated from a non-Informix database management system.

  2. In-place migration is possible when an Informix instance is migrated from an older version of Informix on the same operating system.

  3. In-place migration is possible when an Informix instance is migrated from an older version of Informix on a different operating system.

  4. In-place migration requires that the DBA copy the database schema, user data, and user objects from the older version to the newer version of Informix.

Answer: B

Question No: 8 – (Topic 1)

Identify a scenario when you CANNOT use in-place migration?

  1. When you want to change database locale.

  2. When you want to migrate from a 32-bit to a 64-bit port of Informix.

  3. When you want to defragment some of the heavily fragmented tables.

  4. When you want to use new configuration features in the new Informix version.

Answer: A

Question No: 9 – (Topic 1)

What statement about users accessing a Flexible Grid is true?

  1. Every user can execute commands on the Flexible Grid.

  2. Only user informix can execute commands on a Flexible Grid.

  3. Users have to be authorized to execute Flexible Grid commands.

  4. Commands can only be executed from the node on which the Flexible Grid was created.

Answer: C

Question No: 10 – (Topic 1)

Which object can be defragmented?

  1. index

  2. external table

  3. temporary table

  4. system catalog table

Answer: A

100% Dumps4cert Free Download!
Download Free Demo:C2090-919 Demo PDF
100% Dumps4cert Free Guaranteed!
C2090-919 Dumps

Dumps4cert 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