C2090-619 Exam Questions

Where must the HA_FOC_ORDER configuration parameter be set?

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

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

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

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;

CANNOT define a purging policy on a table that has which two attributes? (Choose two.)

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

Which statement is FALSE about Informix Automatic checkpoint Feature?

Which ONCONFIG parameter would you use to disable the automatic creation or extension

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

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 reques...

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

"informix_stores" is an established primary server with a SDS server. What is the effect of running the following command? EXECUTE FUNCTION sysadmin:admin("ha sds clear", "informix...

Which statement is true for starting Connection Manager?

Which configuration parameter locks the resident and virtual segments of shared memory in operating-system physical memory?

Which SQL statement is valid to monitor database server sessions?

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

Which two statements are true?

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

Where are the Primary Storage Manager catalog tables stored?

What command unlocks the storage catalogs when using the Primary Storage Manager?

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

Which statement is true regarding default roles?

What is the primary benefit of a Storage Pool?

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

Which communication protocol needs additional configuration besides onconfig and sqlhosts?

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

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

Which of configuration parameter can be increased to improve the performance of flushing dirty buffer pages during checkpoints?

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

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?

Which statement is NOT true about a Storage Pool?

Which is NOT a feature of onbar backups?

The IBM Mobile Database is a mobile-optimized version of which IBM product?

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

What is the earliest version you can migrate / upgrade directly to Informix 12.10?

Which value of DRINTERVAL should be used for HDR_TXN_SCOPE configuration parameter to take effect?

To potentially return unused extent pages to the chunk free list, an Informix administrator would execute which storage optimization operation?

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

Which two statements are true about archecker utility? (Choose two.)

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

Which step must be performed to enable Secure Socket Layer (SSL) connections to Informix?

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 determi...

Which is NOT a component of the IBM Mobile Database offering?

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

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

Which statement is FALSE?

Which parameter is used to enable transactions to complete after failover of the primary server?

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

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