C2090-919 Online Practice Questions and Answers

When a SELECT statement is executed which statement is true?

A. The number and duration of the locks is dependent on the ISOLATION LEVEL.

B. If COMMITTED READ isolation is in place then the SELECT will never encounter any locking errors.

C. Within a transaction the database server will place row or page locks on anonlogging table.

D. If the SELECT is part of an UPDATE cursor then the database server will place an exclusive lock on the entire dataset.

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.

What two onconfig parameters will help improve performance of new network connections? (Choose two.)

A. NETTYPE

B. VPCLASS

C. NS_CACHE

D. FET_BUF_SIZE

E. NUMFDSERVERS

Which two onconfig parameters can be set to backup/restore to/from a cloud storage location? (Choose two.)

A. TAPEDEV

B. TAPEBLK

C. LTAPEBLK

D. LTAPEDEV

E. BAR_BSALIB_PATH

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

A. sbspace

B. dbspace

C. extspace

D. blobspace

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.

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.

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.

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

A. dbinfo

B. onstat

C. dbschema

D. onmachinfo

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