- All Exams Instant Download
Which configuration parameter can be set to quickly return rows to a user while a query continues processing?
Which configuration parameter can be set to quickly return rows to a user while a query continues processing?A . OPTOFCB . OPTMSGC . OPT_GOALD . OPTCOMPINDView AnswerAnswer: C
Which two types of locks are used by Informix to access a shared memory buffer? (Choose two.)
Which two types of locks are used by Informix to access a shared memory buffer? (Choose two.)A . ByteB . SharedC . UpdateD . ExclusiveE . PromotableView AnswerAnswer: B,D
Which statement accurately describes the selective row-level auditing feature in Informix?
Which statement accurately describes the selective row-level auditing feature in Informix?A . Auditing can be configured so that row-level events of only selected views are recorded in the audit trail.B . Auditing can be configured so that row-level events of only selected tables are recorded in the audit trail.C ....
Which table attribute defines the percentage of changes (insert/update/delete) threshold to consider the statistics as stale?
Which table attribute defines the percentage of changes (insert/update/delete) threshold to consider the statistics as stale?A . STATAUTOB . STATFORCEC . FORCE AUTOD . STATCHANGEView AnswerAnswer: D
What is the order of precedence if the -file option is used?
During the database server initialization process, a number of environment variables are required. What is the order of precedence if the -file option is used?A . User local shell, system globalB . System global, user local shellC . System global, user local shell, onconfig fileD . Onconfig file, user local...
Which statement is true?
Consider the following statements: DBSPACETEMP=tempdbs1, tempdbs2, tempdbs3; CREATE DATABASE mydb WITH LOG IN datadbs1; CREATE TEMP TABLE temp1 (col1 int); Which statement is true?A . The temp table will be created in datadbs1.B . The temp table will be created in root dbspace.C . The temp table will be careated...
Which statement is true?
store1, store2, store3 and store4 are defined as four servers participating in a GRID. Which statement is true?A . The SELECT query is not a GRID query.B . The SELECT query will return results from all grid servers.C . The SELECT query will return results from store1 and store2.D ....
Given these statements are executed: which statement is true?
Given these statements are executed: which statement is true? A . The entire query will be accelerated to Informix Warehouse Accelerator (IWA) including the OLAP operators.B . The entire query will be executed on Informix database server, and no portion of it will be accelerated by Informix Warehouse Accelerator (IWA).C...
Which system catalog table can be checked to ensure the uniqueness of the new role name?
You need to create a new role for users on stores database. Which system catalog table can be checked to ensure the uniqueness of the new role name?A . stores:sysusersB . sysmaster:sysrolesC . sysuser:sysroleauthD . sysmaster:sysusersView AnswerAnswer: A
Which type of device does Primary Storage Manager support?
Which type of device does Primary Storage Manager support?A . FileB . TapeC . DirectoryD . Named pipeView AnswerAnswer: A
