NEW QUESTION 1
Which two types of locks are used by Informix to access a shared memory buffer? (Choose two.)

• A. Byte
• B. Shared
• C. Update
• D. Exclusive
• E. Promotable

Answer: BD

NEW QUESTION 2
Which log file CANNOT be rotated using the default "message log rotate" SQL admin command?

• A. audit log
• B. message log
• C. onbar debug log
• D. onbar activity log

Answer: A

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

• A. SQL Toolbox
• B. Health Advisor
• C. Server Administration
• D. Performance Analysis

Answer: B

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

• A. onlog
• B. onclean
• C. ondblog
• D. onspaces

Answer: A

NEW QUESTION 5
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 6
Click on the exhibit. Which type of join is occurring?

• A. Star Join
• B. ANSI Join
• C. Index Self-Join
• D. Multi Index Join

Answer: A

NEW QUESTION 7
After executing the following commands: onmode -j -U karin,dave onmode -j -U karin,sarah onmode -j -U sarah which user(s) have access to the instance?

• A. sarah
• B. karin and dave
• C. karin and sarah
• D. karin, dave and sarah

Answer: A

NEW QUESTION 8
Which of the following is NOT possible during a non-root Informix Server installation?

• A. Role Separation
• B. Create users and groups
• C. Create a database server instance
• D. Secure the Informix installation directory

Answer: B

NEW QUESTION 9
Which Informix utility is used to print information about runtime statistics for all threads in the server?

• A. onstat -g sta
• B. onstat -g act
• C. onstat -g rea
• D. onstat -g cpu

Answer: D

NEW QUESTION 10
Several operating-system kernel configuration parameters can affect the use of shared memory by the database server. Which two kernel parameters may need to be configured? (Choose two.)

• A. Memory page size.
• B. Total number of available semaphores.
• C. Lower-boundary address for shared memory.
• D. Total memory presented to the operating system.
• E. Maximum operating-system shared-memory segment size.

Answer: CE

NEW QUESTION 11
Which one keyword in this query makes the AVG an OLAP window expression instead of the regular aggregate operator? SELECT AVG(SUM(dollars)) OVER() FROM sales;

• A. SUM
• B. OVER
• C. FROM
• D. AVG (SUM(dollars))

Answer: B

NEW QUESTION 12
The following message is received: Lock table overflow - user id user32, session id 54. What action should be taken to prevent this problem in the future?

• A. Run onclean utility to clear the lock table.
• B. Increase the LOCKS configuration parameter.
• C. Turn on the AUTO_TUNE configuration parameter.
• D. Change the DEF_TABLE_LOCKMODE configuration parameter from page to row.

Answer: B

NEW QUESTION 13
The DBA has defined the following configuration parameters in the onconfig file:

What are the actual values for LMM START THRESHOLD and LMM STOP THRESHOLD computed internally by the database server?

• A. LMM START THRESHOLD = 2MB and LMM STOP THRESHOLD = 3MB
• B. LMM START THRESHOLD = 20MB and LMM STOP THRESHOLD = 30MB
• C. LMM START THRESHOLD = 500MB and LMM STOP THRESHOLD = 333MB
• D. LMM START THRESHOLD = 2% and LMM STOP THRESHOLD = 3% of physicalmemory in the system

Answer: B

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
What is the primary benefit of a Storage Pool?

• A. It allows data to be shared across instances.
• B. It allows data to be shared across dbspaces.
• C. It allows space to automatically be added to dbspaces.
• D. It allows space to be reserved for critical database operations.

Answer: C

NEW QUESTION 16
Assuming network connectivity between two Informix instances, which file may need additional configuration to allow distributed queries?

• A. sqlhosts
• B. /etc/services
• C. $ONCONFIG
• D. /etc/hosts.equiv

Answer: D

NEW QUESTION 17
Which statement is true for starting Connection Manager?

• A. Only user root and informix.
• B. Any user of the DBSA group.
• C. Any user who is granted privileges to connect to the sysadmin database.
• D. Only a user of the DBSA group with privilege to connect to the sysadmin database.

Answer: D

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

• A. dbexport source system then dbimport into target.
• B. ontape backup from source then restore backup onto target.
• C. onunload the source to tape and onload the tape to the target.
• D. Set up HDR primary and secondary between source and target.

Answer: A

NEW QUESTION 19
How do the MAX_PDQPRIORITY onconfig parameter and the PDQPRIORITY environment variable work together to constrain access to PDQ resources?

• A. PDQPRIORITY is the only constraint.
• B. MAX_PDQPRIORITY is the only constraint.
• C. The minimum of the two values is the actual constraint.
• D. The constraint is MAX_PDQPRIORITY / 100 * PDQPRIORITY / 100.

Answer: D

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

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

Answer: A

NEW QUESTION 21
Given the following statement: UPDATE STATISTICS LOW FOR TABLE customer (customer_num); Which catalog table data is NOT updated?

• A. sysdistrib
• B. systables
• C. sysindexes
• D. syscolumns

Answer: A

NEW QUESTION 22
Which storage manager allows specification of a larger size than others for BAR_XFER_BUF_SIZE?

• A. Informix Storage Manager (ISM)
• B. Informix Primary Storage Manager (PSM)
• C. Informix Secondary Storage Manager (ISSM)
• D. Informix Archive Restore Storage Environment (IARSE)

Answer: B

NEW QUESTION 23
What does the following SQL administration command do? EXECUTE FUNCTION task("onmode", "wi", "/tmp/cfg_20130601");

• A. Apply the new values for all configuration parameters in memory.
• B. Reset the values for dynamically updatable configuration parameters to the default values and save them in onconfig.
• C. Apply the new values for all dynamically updatable configuration parameters from the file "/tmp/cfg_20130601" in memory.
• D. Apply the new values for all dynamically updatable configuration parameters from the file "/tmp/cfg_20130601" and save them in onconfig.

Answer: C

NEW QUESTION 24
......