Abreast Of The Times C2090-619 Testing Engine 2021

NEW QUESTION 1
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 2
Which command line utility does NOT have the equivalent functionality using the SQL Administration API?

• A. oninit
• B. onmode
• C. onspaces
• D. onparams

Answer: A

NEW QUESTION 3
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 4
Which statement is true regarding the selective row-level auditing feature in Informix?

• A. You can create audit masks corresponding to row-level events of a specific table.
• B. Selective row-level auditing must be explicitly turned on using the onshowaudit utility.
• C. When you create a table, you can specify if row-level auditing should be enabled for the table.
• D. When you create a database, you can specify if row-level auditing should be enabled for all the tables within the database.

Answer: C

NEW QUESTION 5
In which table can you find a history of all SQL Administration API functions executed in the last 30 days?

• A. sysadmin:admin_history
• B. sysmaster:admin_history
• C. sysadmin:command_history
• D. sysmaster:command_history

Answer: C

NEW QUESTION 6
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 7
Which threshold setting applies when configuring automatic memory management?

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

Answer: A

NEW QUESTION 8
The Rolling Window clause of the ALTER FRAGMENT MODIFY INTERVAL statement CANNOT define a purging policy on a table that has which two attributes? (Choose two.)

• A. The table has a ROWID shadow column.
• B. The table has a Fragment By Range index.
• C. The table has a Unique Key being used by ER.
• D. The Fragment Key is defined with multiple columns.
• E. The Primary Key for the table is referenced by a foreign key constraint.

Answer: AE

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

• A. Only logical restore.
• B. Only physical restore.
• C. Only point in time restore.
• D. Physical, logical, and point in time restores.

Answer: D

NEW QUESTION 10
Which technology does NOT use the Secure Sockets Layer (SSL) protocol for an end-to- end secure connection?

• A. On-disk encryption
• B. Enterprise Replication
• C. High-Availability Data Replication
• D. Server-to-server distributed query communication

Answer: A

NEW QUESTION 11
Which table attribute defines the percentage of changes (insert/update/delete) threshold to consider the statistics as stale?

• A. STATAUTO
• B. STATFORCE
• C. FORCE AUTO
• D. STATCHANGE

Answer: D

NEW QUESTION 12
The sector option for cdr utility is used to perform what operation?

• A. Dynamically convert ER cluster instances in order to perform rolling upgrades.
• B. Dynamically convert H/A cluster instances in order to perform rolling upgrades.
• C. Dynamically reconfigure Connection Manager SLAs for ER clusters in order to perform rolling upgrades.
• D. Dynamically reconfigure Connection Manager SLAs for H/A clusters in order to perform rolling upgrades.

Answer: B

NEW QUESTION 13
The purge policy CANNOT be executed for a rolling window table utilizing which method?

• A. By calling the syspurge function.
• B. By the purge_tables task of the Scheduler.
• C. By setting up the server to automatically run the purge policy.
• D. By running ALTER FRAGMENT with the PURGE NOW predicate.

Answer: D

NEW QUESTION 14
For a query to be processed by the accelerator, the query or query block should meet the certain criteria. Which statement is FALSE?

• A. The query or query block must include at least 2 fact tables.
• B. The query or query block must refer to a subset of the tables in the AQT.
• C. The scalar and aggregate functions in the query or query block must be supported bythe Informix Warehouse Accelerator.
• D. The table references or joins specified in the query or query block must be the same as the references in the data mart definition.

Answer: A

NEW QUESTION 15
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 16
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 17
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 18
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 19
When configuring Informix server for DRDA connection, which statement is true?

• A. The connection protocol must be drsoctcp.
• B. The database server name for DRDA connection must correspond to the DBSERVERNAME onconfig parameter.
• C. The database server name for DRDA connection must correspond to the DBSERVERALIASES onconfig parameter.
• D. The database server name should correspond to either the DBSERVERNAME or the DBSERVERALIASES onconfig parameter.

Answer: C

NEW QUESTION 20
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 21
You have started a violations table for a target table with a non default name. (For example: "START VIOLATIONS TABLE FOR customer USING exceptions, reasons;"). How can you determine the relationship between the violations table and the target table later?

• A. Using dbschema utility
• B. Using 'oncheck -pT' command
• C. Querying sysdepends system catalog table
• D. Querying sysviolations system catalog table

Answer: D

NEW QUESTION 22
Which statement is true about restartable restore?

• A. ontape can perform restartable restores if a backup is taken to disk.
• B. Restartable restore is the ability to restart a failed restore using onbar.
• C. Restartable restore is the ability to restart a failed restore using ontape.
• D. Restartable restore is the ability to restart an instance using a restore from some other computer.

Answer: B

NEW QUESTION 23
Which command would you use to export and import backup object metadata from one database server to another in conjunction with Primary Storage Manager?

• A. onbar -E
• B. dbexport
• C. onsmsync
• D. ontape -exp

Answer: C

NEW QUESTION 24
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 25
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 26
......