C2090-919 Online Practice Questions and Answers

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.

Which command line utility displays real time statistics about the instance?

A. dbinfo

B. onstat

C. dbschema

D. onmachinfo

Which statement about mapped user functionality is true?

A. Mapped users cannot execute distributed operations.

B. Mapped users are allowed to run with multiple names.

C. The DBSA can control the access to tables at a row level using security labels.

D. The DBSA can grant database server access to externally authenticated users with no local account.

How many paging files are required for SD secondary instances?

A. There should always be two.

B. It depends on how many CPU VPs you have.

C. It depends on how many datadbspaces you have.

D. It depends on how many temporarydbspaces you have.

Given the SQL explain output of this star join query, which is the fact table?

A. sales

B. product

C. region

D. customer

Which environment option can rollback transactions using a table involved in an ALTER FRAGMENT ON TABLE operation?

A. FORCE_DML_EXEC

B. FORCE_DDL_EXEC

C. ROLLBACK_DML_EXEC

D. ROLLBACK_DDL_EXEC

The user 'guest' connected to a local database world@lsys and wants to execute the following query:

What two permissions does the user 'guest' need to access the remote table? (Choose two.)

A. User 'guest' must have SELECT permission on 'globe'

B. User 'guest' must have CONNECT permission on 'globe'

C. User 'guest' must have SELECT permission on 'globe@rsys:position'

D. User 'guest' must have CONNECT permission on 'globe@rsys:sadm.position'

E. User 'guest' must have RESOURCE permission on 'world@lsys'

Identify a scenario when you CANNOT use in-place migration?

A. When you want to change database locale.

B. When you want to migrate from a 32-bit to a 64-bit port of Informix.

C. When you want to defragment some of the heavily fragmented tables.

D. When you want to use new configuration features in the new Informix version.

If the DYNAMIC_LOGS onconfig parameter is set to 1 and logical log backups are not occurring, what will happen in the instance when the last logical-log file fills?

A. The instance suspends all processing until the next logical-log file is manually added.

B. The database server will automatically execute a checkpoint and flush the oldest update to disk.

C. The database server will make use of any logical-log file available regardless of whether the available file is in sequence or not.

D. The database server will stop processing, then start an automatic backup of the logical-log file and resume normal processing once the automatic back up of the logical-log files is completed.

How does the Deployment Assistant enable you to reduce the size of the installation to be deployed?

A. By limiting the size ofdbspaces.

B. By removing specific databases.

C. By removing specific product features.

D. By removing all free space at the end of a chunk.

Given the following SQL statement:

WHEN MATCHED THEN DELETE What does the merge statement do?

A. Deletes rows in tab2 that match the condition col1 = c1.

B. Deletes rows in tab1 that match the condition col1 = c1.

C. Deletes rows in tab1 that match the condition col1 = c1 and deletes rows in tab2 that do not match the condition col1 = c1.

D. Deletes rows in tab1 that match the condition col1 = c1 and insert rows in tab1 from those in tab2 that do not match the condition.

Given the following statement:

session A. setlock mode to wait;

select* from tab1;

ifsession A is blocked, which sysmaster table contains the session id holding the lock blocking session A?

A. syslocks

B. sysscblst

C. syssessions

D. syslockholders

Which $ONCONFIG parameter must be set enable parallel OnBar backup operations?

A. BAR_MAX_BACKUP

B. BAR_SIZE_FACTOR

C. BAR_PERFORMANCE

D. BAR_NB_XPORT_COUNT

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

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

A. The rows will be compressed and the table size will decrease.

B. The table will be taken offline and compressed, and the table size will decrease.

C. The rows will be compressed and the space allocated to the table will be the same.

D. The table will be taken offline and compressed, but the space allocated to the table will be the same.