C2090-919 Online Practice Questions and Answers

Which two corrective actions may be taken if following message is logged in the online message log during a failed attempt to bring an instance online? (Choose two)

18:15:44

Size of resident + virtual segments 100000KB + 60000KB > 150000KB

18:15:44

total allowed by configuration parameter SHMTOTAL

A.

Decrease SHMADD

B.

Increase SHMTOTAL

C.

Decrease SHMBASE

D.

Increase SHMVIRTSIZE

E.

Decrease buffer pool size

Which two options can be used to monitor PDQ resources? (Choose two.)

A. onstat -l.

B. onstat -p.

C. onstat -D.

D. onstat -g ath.

E. SET EXPLAIN output.

When adding space to the storagepool, which correctly describes the type of storage which may be placed in the storagepool?

A. Cooked file only.

B. Raw devices only.

C. Cooked files andRaw devices only.

D. Cooked files,Raw devices and Directories.

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

A. ALTER

B. AMEND

C. MODIFY

D. RENAME

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.

Which statement about compression is NOT true?

A. If you use High-Availability clusters, data that is compressed on the primary will not be compressed on the secondary(s).

B. If you use Enterprise Replication, compressing data on one replication server does not affect the data on any other replication server.

C. You cannot perform compression operations on a High-Availability cluster secondary.

D. The query optimizer may choose different query plans because compressed data covers fewer pages and has more rows per page than uncompresseddata.

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 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

Which of the following is NOT a step in setting up HDR for the first time?

A. Take a level 0 backup of the primary.

B. Useoninit -v to bring up the secondary.

C. Execute a physical restore on the secondary.

D. Useonmode -d to specify the secondary instance name.

Which would provide the greatest performance benefit in a warehousing environment?

A. Indexes on searched data.

B. Short checkpoint durations.

C. Large number ofbufferpool buffers.

D. Optimize decision support memory.