NEW QUESTION 1
Which SQL statement is valid to monitor database server sessions?

• A. EXECUTE FUNCTION task ("onstat","-g ses");
• B. EXECUTE FUNCTION task ("view sessions","all");
• C. EXECUTE FUNCTION task ("check sessions","all");
• D. EXECUTE FUNCTION task ("check server","sessions");

Answer: A

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

• A. All users with the EXTEND role can grant it to other users.
• B. All users with the default role can register external routines.
• C. All users can create external routines in the database server.
• D. All users with the EXTEND role can register external routines.

Answer: D

NEW QUESTION 3
What is the purpose of the GRANT ADMIN privilege?

• A. Grants the admin privilege to create role separation.
• B. Grants the admin privilege to perform DBSA functions.
• C. Grants the admin privilege to use the Open Admin Tool.
• D. Grants the admin privilege to run SQL administration API commands.

Answer: D

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

• A. All new data since the last level 1 backup.
• B. All new data since the last level 2 backup.
• C. All logical logs which have not previously been backed up.
• D. All new data since the last level 0, level 1 or level 2 backup.

Answer: A

NEW QUESTION 5
Which objects can be compressed?

• A. CLOBs
• B. smart BLOBs
• C. partition BLOBs
• D. blobspace BLOBs

Answer: C

NEW QUESTION 6
To potentially reduce table extent interleaving, an Informix administrator would execute which storage optimization operation?

• A. Shrink
• B. Repack
• C. Compress
• D. Defragment

Answer: D

NEW QUESTION 7
The 'onstat -k' output is showing '56 lock table overflows'. Which catalog table can be used to display the relevant lock statistics?

• A. syslocks
• B. systables
• C. sysprofile
• D. sysoverflow

Answer: C

NEW QUESTION 8
When executing the following command: execute function sysadmin task("table compress", "customer") what will happen to the customer table?

• A. Only newly added rows will be compressed.
• B. Only existing data will be compressed, new data will remain uncompressed.
• C. Row data and partition blobs will be compressed and any free table space will be released.
• D. Row data and partition blobs will be compressed and the space allocated to the table will remain.

Answer: C

NEW QUESTION 9
Which threshold setting applies when configuring automatic memory management?

• A. SHMTOTAL
• B. BUFFERPOOL
• C. SHMVIRTSIZE
• D. DS_TOTAL_MEMORY

Answer: A

NEW QUESTION 10
Which statement about Storage Provisioning is true?

• A. Only raw devices can be extended.
• B. Only cooked devices can be extended.
• C. Only unmirrored spaces can be extended.
• D. Mirrored and unmirrored spaces can be extended.

Answer: C

NEW QUESTION 11
Consider the following statements: DBSPACETEMP=tempdbs1, tempdbs2, tempdbs3; CREATE DATABASE mydb WITH LOG IN datadbs1; CREATE TEMP TABLE temp1 (col1
int); Which statement is true?

• A. The temp table will be created in datadbs1.
• B. The temp table will be created in root dbspace.
• C. The temp table will be careated in one of the dbspaces listed in DBSPACTEMP.
• D. The temp table will be created round-robin across the dbspaces in DBSPACETEMP.

Answer: B

NEW QUESTION 12
Which statement is FALSE about dbspace configurable page sizes?

• A. Dbspace page size can only be set for non-critical dbspaces.
• B. Possible page sizes are multiples of the default page size up to 16 kb.
• C. Configure page sizes as close to the backup / restore and network buffer size as possible for efficient data transfer across the wire.
• D. Dbspace page size should be configured to accommodate the greatest number of average row sizes with a minimum of remainder pages being used.

Answer: C

NEW QUESTION 13
Which configuration parameter should be set to enable asynchronous page requests when the database server detects that a query is waiting on I/O?

• A. DIRECT_IO
• B. DBUPSPACE
• C. AUTO_AIOVPS
• D. AUTO_READAHEAD

Answer: D

NEW QUESTION 14
Where must the HA_FOC_ORDER configuration parameter be set?

• A. Any server in the cluster.
• B. The primary server only.
• C. The SDS secondary only.
• D. The HDR secondary only.

Answer: B

NEW QUESTION 15
Which statement accurately describes the selective row-level auditing feature in Informix?

• A. Auditing can be configured so that row-level events of only selected views are recorded in the audit trail.
• B. Auditing can be configured so that row-level events of only selected tables are recorded in the audit trail.
• C. Auditing can be configured so that events of only selected rows within a table are recorded in the audit trail.
• D. Auditing can be configured so that row-level events of only selected partitions are recorded in the audit trail.

Answer: B

NEW QUESTION 16
Which Informix utility can be used to customize the onconfig file?

• A. ifxdeploy
• B. genoncfg
• C. dbaccess
• D. onparams

Answer: B

NEW QUESTION 17
Which HDR configuration parameter provides three synchronization modes to control when transaction commits are returned to client applications?

• A. DELAY_APPLY
• B. HDR_TXN_SCOPE
• C. LOG_INDEX_BUILDS
• D. FAILOVER_TX_TIMEOUT

Answer: B

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

• A. SP_WAITTIME
• B. SP_THRESHOLD
• C. SP_AUTOEXPAND
• D. SP_CHUNKEXTEND

Answer: C

NEW QUESTION 19
Which two logging modes are compatible between two databases participating in a distributed query? (Choose two.)

• A. ANSI and non-ANSI
• B. Buffered and Unbuffered
• C. Buffered and Non-logging
• D. Non-logging and Unbuffered
• E. Non-logging and Non-logging

Answer: BE

NEW QUESTION 20
What are two requirements for the "ifxclone" utility? (Choose two.)

• A. All databases must use logging.
• B. The source server must be a secondary server.
• C. Only one server clone process can occur at a time.
• D. Both the source and target servers must be part of a trusted network environment.
• E. Both the source and target servers must use the same type of disk space (raw or cooked).

Answer: CD

NEW QUESTION 21
......