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

IBM Informix 12.10 System Administrator

Question No: 1

Which ONCONFIG parameter would you use to disable the automatic creation or extension of chunks?

  1. SP_WAITTIME

  2. SP_THRESHOLD

  3. SP_AUTOEXPAND

  4. SP_CHUNKEXTEND

Answer: C

Question No: 2

Which statement is valid about Data consolidation using send-only replicates?

  1. You can have more than one target server.

  2. You cannot modify a server to change its mode to send-only.

  3. You cannot use this replicate for tables that include TimeSeries columns.

  4. You need to define a different replicate for each send-only primary server.

Answer: C

Question No: 3

What is the earliest version you can migrate / upgrade directly to Informix 12.10?

A. 7.30

B. 8.0

C. 9.40

D. 10.0

Answer: D

Question No: 4

Which object can be compressed?

  1. dictionary table

  2. temporary table

  3. attached b-tree index

  4. detached b-tree index

Answer: D

Question No: 5

Which two statements are true about Enterprise Replication of TimeSeries data types? (Choose two.)

  1. ATS and RIS files must be in XML format.

  2. The replicate must be a mastered replicate.

  3. The conflict resolution rule must be always-apply.

  4. The WHERE clause in the participant definition must include a TimeSeries column.

  5. CDR_TSINSTANCEID configuration parameter must be set to the same value for every replication server.

Answer: B,C

Question No: 6

Which Informix utility can be used to display contents of logical-log files, either from disk or from backup?

  1. onlog

  2. onclean

  3. ondblog

  4. onspaces

Answer: A

Question No: 7

Which statement about DataBlade modules is true?

  1. All DataBlades located in the $INFORMIXDIR/extend are automatically registered.

  2. All built-in extensions are automatically registered when the extension is first accessed.

  3. All built-in extensions are automatically registered each time the database sever is started.

  4. All built-in extensions are automatically registered when the database server is first initialized.

Answer: B

Question No: 8

In which table can you find a history of all SQL Administration API functions executed in the last 30 days?

  1. sysadmin:admin_history

  2. sysmaster:admin_history

  3. sysadmin:command_history

  4. sysmaster:command_history

Answer: C

Question No: 9

The purge policy CANNOT be executed for a rolling window table utilizing which method?

  1. By calling the syspurge function.

  2. By the purge_tables task of the Scheduler.

  3. By setting up the server to automatically run the purge policy.

  4. By running ALTER FRAGMENT with the PURGE NOW predicate.

Answer: D

Question No: 10

The Rolling Window clause of the ALTER FRAGMENT MODIFY INTERVAL statement CANNOT define a purging policy on a table that has which two attributes? (Choose two.)

  1. The table has a ROWID shadow column.

  2. The table has a Fragment By Range index.

  3. The table has a Unique Key being used by ER.

  4. The Fragment Key is defined with multiple columns.

  5. The Primary Key for the table is referenced by a foreign key constraint.

Answer: A,E

100% Ensurepass Free Download!
Download Free Demo:C2090-619 V13 Demo PDF
100% Ensurepass Free Guaranteed!
Download 2017 EnsurePass C2090-619 V13 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