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

Which approach is always valid when migrating data across differing hardware and operating system architectures?

  1. dbexport source system then dbimport into target.

  2. ontape backup from source then restore backup onto target.

  3. onunload the source to tape and onload the tape to the target.

  4. Set up HDR primary and secondary between source and target.

Answer: A

Question No: 52

Which statement is FALSE about Informix Automatic checkpoint Feature?

  1. Automatic checkpoints cause less logical log activity.

  2. Automatic checkpoints try to avoid transaction blocking.

  3. Automatic checkpoints cause the database server to trigger more frequent checkpoints.

  4. Automatic checkpoints can be dynamically enabled or disabled by using onmode -wm or onmode -wf.

Answer: A

Question No: 53

Which statement describes the behavior of an Informix instance when the IFX_EXTEND_ROLE configuration parameter is set to ON.

  1. All users with the EXTEND role can grant it to other users.

  2. All users with the default role can register external routines.

  3. All users can create external routines in the database server.

  4. All users with the EXTEND role can register external routines.

Answer: D

Question No: 54

Which parameter is used to enable transactions to complete after failover of the primary server?

  1. HA_FOC_ORDER

  2. FAILOVER_CALLBACK

  3. CLUSTER_TXN_SCOPE

  4. FAILOVER_TX_TIMEOUT

Answer: D

Question No: 55

Which action can be taken if an instance is down?

  1. A point-in-time mixed restore.

  2. Warm restore of non-critical storage spaces.

  3. Cold restore by onbar using storage space backups taken by ontape on tape devices.

  4. A mixed restore using onbar whole system backup and incremental dbspace level backups.

Answer: A

Question No: 56

Which statement is FALSE regarding SBSPACES?

  1. They are recoverable.

  2. They do not obey transaction isolation modes.

  3. They have read, write, and seek properties similar to a standard UNIX file.

  4. Smart large objects within table rows are not required to be retrieved in one statement.

Answer: B

Question No: 57

Which OpenAdmin Tool feature is used to analyze the state of the Informix database server and can alert the DBA through email?

  1. SQL Toolbox

  2. Health Advisor

  3. Server Administration

  4. Performance Analysis

Answer: B

Question No: 58

When you take a level 2 backup, what data is backed up?

  1. All new data since the last level 1 backup.

  2. All new data since the last level 2 backup.

  3. All logical logs which have not previously been backed up.

  4. All new data since the last level 0, level 1 or level 2 backup.

Answer: A

Question No: 59

Which two statements are true? (Choose two.)

  1. Logical log files must always reside in rootdbs.

  2. Having too little log space does not affect performance.

  3. Having too much log space does not affect performance.

  4. Simple large objects in blobspaces are not logged and they are included in the log backup in which the object was created.

  5. Simple large objects in blobspaces are not logged and they are not included in the log backup in which the object was created.

Answer: C,D

Question No: 60

quot;informix_storesquot; is an established primary server with a SDS server. What is the effect of running the following command? EXECUTE FUNCTION sysadmin:admin(quot;ha sds clearquot;, quot;informix_storesquot;);

  1. Shuts down the primary server and converts the secondary server to be the primary.

  2. Clears the log position of the SDS servers and restarts replication.

  3. Converts the shared disk secondary server to a standard server and shuts down the primary server.

  4. Stops replication to the shared disk secondary servers and converts the primary server to a standard server.

Answer: D

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.