What output is NOT reported by the dbschema utility?
A. The database logging mode.
B. The schemas of remote databases.
C. The table definitions without owner names.
D. Theonspaces commands to re-create your systems' dbspaces.
Without explicitly setting DBSPACETEMP and TEMPTABLE_NOLOG, where will temporary tables be created by default? (Choose three.)
A. The rootdbspace.
B. The users' home directory.
C. The $INFORMIXDIR/tmp directory.
D. Thedbspace in which the active database was created.
E. The /tmp directory or PSORT_DBTEMP.
Which of the following gives a good initial estimate for the physical log size?
A. 110% ofrootdbs.
B. 110% the default buffer pool.
C. 110% of the logical log space.
D. 110% of combined buffer pool.
Under which condition can table fragments NOT be eliminated during query processing?
A. Tables with non-overlapping fragments and an equality query predicate.
B. Tables with round-robin distribution scheme and a range query predicate.
C. Tables with non-overlapping fragments on a single column and a range query predicate.
D. Tables with overlapping or non-contiguous fragments on a single column and an equality query predicate.
When executing the SQL Admin API "defragment table" and "table repack" commands on the customer table, what will happen to the table? (Choose two.) executefunction sysadmin:task("defragment table","customer"); executefunction sysadmin:task("table repack", "customer");
A. Fragments of a table will be combined.
B. Rows will be moved to the beginning of table.
C. Given sufficient resources the number of extents in the table will be reduced.
D. Free space at the end of the table will be released to thedbspace for other tables to use.
E. The table will be locked preventing inserts from happening for the duration of the commands.
Which of the following privileges is NOT valid for a table fragment?
A. ALL
B. INSERT
C. UPDATE
D. CREATE INDEX
Consider the following selective row-level auditing example:
How many entries will be added to the audit file?
A. 0
B. 3
C. 5
D. 8
Which statement about Informix data compression is NOT true?
A. It can compress, repack and shrink a table in one command.
B. There is no Admin API (sysadmin) interface to automatically compress tables.
C. The 'onstat -g dsk' command can be used to find the progress of currently running compression operations.
D. The compress, repack,repack_offline, uncompress, and uncompress_offline operations can consume large amounts of logs.
Which parameter is used to configure the servers in a high-availability cluster so that transactions complete after failover?
A. SURVIVAL_TX_ENABLE
B. FAILOVER_CALLBACK
C. SURVIVAL_TX_TIMEOUT
D. FAILOVER_TX_TIMEOUT
