C2090-619 Exam - IBM Informix 12.10 System Administrator (C2090-619)

NEW QUESTION 1
Which option provides the greatest performance benefit in an Informix warehouse environment?

• A. Setting lower value of PDQPRIORITY.
• B. Increasing the number of B-Tree cleaners.
• C. Setting higher value of DS_TOTAL_MEMORY.
• D. Setting value of OPT_GOAL configuration variable to 0.

Answer: C

NEW QUESTION 2
Which is a valid Pluggable Authentication Module (PAM) mode in Unix?

• A. Login mode
• B. Client mode
• C. Server mode
• D. Password mode

Answer: D

NEW QUESTION 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

NEW QUESTION 4
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 5
You are running an UPDATE statement on a table using dbaccess. What kind of lock type is expected?

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

Answer: D

NEW QUESTION 6
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 7
Which configuration parameter can toggle the automatic expansion of storage spaces?

• A. SP_AUTOGROW
• B. SP_AUTO_SPACE
• C. SP_AUTOEXPAND
• D. SP_EXPAND_ENABLE

Answer: C

NEW QUESTION 8
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 9
Which is NOT a valid index fragmentation strategy?

• A. Fragment by Range
• B. Partition by Expression
• C. Fragment by Expression
• D. Fragment by Round Robin

Answer: D

NEW QUESTION 10
Where are the Primary Storage Manager catalog tables stored?

• A. sysutils database
• B. sysadmin database
• C. sysmaster database
• D. A location as specified by the PSM_CATALOG_PATH configuration parameter

Answer: D

NEW QUESTION 11
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 12
Given the following:

How many locks will be used on tab1 to run the query?

• A. 1
• B. 2
• C. Depends on the number of index pages accessed

Answer: A

NEW QUESTION 13
How can you ensure to hold the an update lock until the end of a transaction when fetching rows from a cursor?

• A. Use the 'Committed Read' isolation level.
• B. Use the RETAIN UPDATE LOCKS clause with isolation level.
• C. Use the 'Cursor Stability' isolation level along the WITH HOLD clause.
• D. Use the SET TRANSACTION command to with SERIALIZABLE clause.

Answer: B

NEW QUESTION 14
Which statement is FALSE regarding SBSPACES?

• A. They are recoverable.
• B. They do not obey transaction isolation modes.
• C. They have read, write, and seek properties similar to a standard UNIX file.
• D. Smart large objects within table rows are not required to be retrieved in one statement.

Answer: B

NEW QUESTION 15
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 16
Which two statements are true? (Choose two.)

• A. Logical log files must always reside in rootdbs.
• B. Having too little log space does not affect performance.
• C. Having too much log space does not affect performance.
• D. Simple large objects in blobspaces are not logged and they are included in the log backup in which the object was created.
• E. Simple large objects in blobspaces are not logged and they are not included in the log backup in which the object was created.

Answer: CD

NEW QUESTION 17
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 18
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 19
Which Enterprise Replication command CANNOT be used on replicates that include TimeSeries columns?

• A. cdr start
• B. cdr sync
• C. cdr realize
• D. cdr remaster

Answer: D

NEW QUESTION 20
In an organization, all employees are authenticated via domain wide Kerberos single sign- on. The DBSA wants to provide access to the database server for an employee without requesting the Operating System (OS) administrator to create a OS level user account. Which Informix feature does the DBSA need to leverage?

• A. Mapped users
• B. Role based users
• C. Table level access for users
• D. Label based access for users

Answer: A

NEW QUESTION 21
......