Ensurepass.com : Ensure you pass the IT Exams
2018 Jan IBM Official New Released C2090-619
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/C2090-619.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 Demo PDF
100% Ensurepass Free Guaranteed!
C2090-619 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

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.