C2090-558 Online Practice Questions and Answers

Why would you want to create a table with a lock mode row as opposed to a lock mode page?

A. to reduce disk I/O

B. to keep more information in memory for each locked row

C. to increase concurrency among multiple users on the same table

D. to reduce the number of locks when accessing rows out of the table

Which Informix utility listed below will allow an administrator to run ad hoc SQL against the instance?

A. onsql

B. onadmin

C. dbaccess

D. dbschema

Which of the following statements can be used to prevent duplicate values in an indexed column?

A. CREATE HASH INDEX

B. CREATE UNIQUE INDEX

C. CREATE DISTINCT TYPE

D. CREATE CLUSTER INDEX

Click the Exhibit button.

The query.sql file contains the information shown in the exhibit. The following command is run: dbaccess ?query.sql How many rows will be returned by the select query?

A. 1

B. 2

C. 3

D. 4

What functionality is exclusive to onbar (i.e. not present in ontape)?

A. Restore of a single dbspace

B. Level 1 archive of the instance

C. Parallel restore of the instance

D. Change logging modes of a database

Which two commands would create a table t1 with page level locking assuming default configuration parameter settings? (Choose two.)

A. create table t1 (c1 int)

B. create table t1 (c1 int) locking page

C. create table t1 (c1 int) lock level page

D. create table t1 (c1 int) lock mode page

E. create table t1 (c1 int) locking mode page

Which keyword is used to determine whether a comparison is true for every value returned from a subquery?

A. ALL

B. ANY

C. EACH

D. EVERY

Which configuration parameter allows you to reduce the dependency on local OS user accounts and to enable a DBSA to grant database server access to specific users without the OS user accounts?

A. USERMAPPING

B. IFX_EXTEND_ROLE

C. SECURITY_LOCALCONNECTION

D. ADMIN_USER_MODE_WITH_DBSA

You received an error, "Chunk is not empty", while trying to remove a chunk. How do you verify which objects still occupy space in the chunk?

A. onspaces

B. onmonitor

C. oncheck -pe

D. SELECT * from SYSTABLES

Which of the following statement is true of System Monitoring Interface (SMI) tables?

A. SMI tables store database structures.

B. Contains tasks used by the database scheduler

C. SMI tables are also known as System Catalog tables

D. Contains tables that the database server maintains automatically