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;
Which statement is FALSE about dbspace configurable page sizes?
Which technology does NOT use the Secure Sockets Layer (SSL) protocol for an end-to-end secure connection?
Which type of device does Primary Storage Manager support?
Given the following statement: UPDATE STATISTICS LOW FOR TABLE customer (customer_num); Which catalog table data is NOT updated?
Given an OLTP environment with a very large table, which configuration parameter can be set to allocate more memory for sorting when building an index on the large table?
Which Informix utility can be used to customize the onconfig file?
To potentially reduce table extent interleaving, an Informix administrator would execute which storage optimization operation?
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.)
How can you ensure to hold the an update lock until the end of a transaction when fetching rows from a cursor?
When the server is in administration mode, which users are NOT allowed to connect?
The purge policy CANNOT be executed for a rolling window table utilizing which method?
When using the deployment assistant, which two statements are true? (Choose two.)
Which statement is FALSE?
Which statement is valid about Data consolidation using send-only replicates?
In addition to examining the Connection Manager log file, what are two ways to monitor the Connection Manager status? (Choose two.)
Which option maximizes performance in an Informix Warehouse (DSS) environment?
When free memory is limited, which configuration parameter should be set to allow critical database activities to complete successfully?
The sector option for cdr utility is used to perform what operation?