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

In addition to examining the Connection Manager log file, what are two ways to monitor the Connection Manager status? (Choose two.)

  1. onstat

  2. onmode

  3. oncmsm

  4. onmonitor

  5. OpenAdmin Tool

Answer: A,E

Question No: 12

Which is NOT a valid option to improve service for connection requests under TCP/IP protocol?

  1. Adding sm_listen threads.

  2. Adding listener threads for additional ports.

  3. Dynamically increase the number of listener threads using onmode -P commands.

  4. Adding an additional network-interface card to service Informix connection requests.

Answer: A

Question No: 13

Which log file CANNOT be rotated using the default quot;message log rotatequot; SQL admin command?

  1. audit log

  2. message log

  3. onbar debug log

  4. onbar activity log

Answer: A

Question No: 14

The total number of locks allocated equals the value specified by the LOCKS configuration parameter. What is the behavior of the database server when more locks are now requested?

  1. The user encounters a lock request error.

  2. More memory is allocated for additional lock structures from DS_TOTAL_MEMORY.

  3. More memory is allocated for additional lock structures in the VIRTUAL section of shared memory.

  4. More memory is allocated for additional lock structures in the RESIDENT section of shared memory.

Answer: C

Question No: 15

Click on the exhibit. Which type of join is occurring?

  1. Star Join

  2. ANSI Join

  3. Index Self-Join

  4. Multi Index Join

Answer: A

Question No: 16

What is the purpose of the ifx_getMartStat() function?

  1. To display status information about the data mart.

  2. To display update statistics information about the data mart and its tables.

  3. To display statistics about the workers and coordinators defined for the accelerator.

  4. To display status information about the Informix Warehouse Accelerator and all the data marts.

Answer: A

Question No: 17

You have started a violations table for a target table with a non default name. (For example: quot;START VIOLATIONS TABLE FOR customer USING exceptions, reasons;quot;). How can you determine the relationship between the violations table and the target table later?

  1. Using dbschema utility

  2. Using #39;oncheck -pT#39; command

  3. Querying sysdepends system catalog table

  4. Querying sysviolations system catalog table

Answer: D

Question No: 18

Which statement is true regarding default roles?

  1. The DBSA can define a default role to assign only to the PUBLIC group for a particular database.

  2. The privileges associated with a default role takes precedence over the privileges granted to an individual user.

  3. The DBSA can define a default role to assign to individual users or to the PUBLIC group for a particular database.

  4. When a user connects to a database, it is necessary to use the SET ROLE DEFAULT statement in order to gain the default role privileges.

Answer: C

Question No: 19

Role separation provides checks and balances to improve the security of your event- auditing procedures. Which two roles must be associated with group IDs to enable role separation? (Choose two.)

  1. DBSEC: DB Security Officer

  2. AAO: Auditing Analysis Officer

  3. DBASO: DB Audit and Security Officer

  4. DBAMO: DB Audit Management Officer

  5. DBSSO: Database System Security Officer

Answer: B,E

Question No: 20

What kinds of Table Level Restores can be done by the archecker utility?

  1. Only logical restore.

  2. Only physical restore.

  3. Only point in time restore.

  4. Physical, logical, and point in time restores.

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.