C2090-919 Online Practice Questions and Answers

Which statement about auditing is NOT true?

A. You can enable auditing row updates for all rows in the table.

B. You can enable auditing row updates just for a subset of rows in the table.

C. You can enable auditing row updates for all rows from all tables in the database except for system catalog tables.

D. You can enable auditing row updates for all rows from all tables in the database and for the system catalog tables.

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 statement about automatic space management is true?

A. Spaces cannot be extended manually.

B. Onlyunmirrored spaces can be extended.

C. Mirrored andunmirrored spaces can be extended.

D. The time interval for low storage space checks is not user configurable.

Which of the following is NOT in the machine notes?

A. Operating system requirements.

B. Critical kernel tuning parameters.

C. A descriptive list of the new features in the port.

D. Featuresthat are not available for the version and O/S.

If SQLTRACE is enabled, what information is displayed by this statement? select max(sql_runtime) from syssqltrace;

A. The SQL statement with the least wait time.

B. The SQL statement with the least I/O wait time.

C. The SQL statement with the most I/O wait time.

D. The SQL statement with the most execution time.

What is used during Fast Recovery to return pages to the original state?

A. Logical Log

B. Physical Log

C. External Tables

D. TemporaryDBSpaces

On which node of an Informix H/A cluster can you execute an external backup without disturbing cluster operations?

A. Primary

B. Shared disk secondary

C. Remote standalone secondary

D. High-availability data replication secondary

Which of the following schema privileges allows you to rename a fragment?

A. ALTER

B. AMEND

C. MODIFY

D. RENAME

Which storage space should be used to store columns defined as a BLOB or a CLOB?

A. sbspace

B. dbspace

C. extspace

D. blobspace

Most, but not all Virtual Processors, can be modified via the onmode -p command. Which CANNOT be modified?

A. ADM

B. BTS

C. CPU

D. CSM