C2090-619 Online Practice Questions and Answers

Which one keyword in this query makes the AVG an OLAP window expression instead of the regular aggregate operator? SELECT AVG(SUM(dollars)) OVER() FROM sales;

A. SUM

B. OVER

C. FROM

D. AVG(SUM(dollars))

The sector option for cdr utility is used to perform what operation?

A. Dynamically convert ER cluster instances in order to perform rolling upgrades.

B. Dynamically convert H/A cluster instances in order to perform rolling upgrades.

C. Dynamically reconfigure Connection Manager SLAs for ER clusters in order to perform rolling upgrades.

D. Dynamically reconfigure Connection Manager SLAs for H/A clusters in order to perform rolling upgrades.

Which statement is FALSE?

A. A new index can be created compressed.

B. Attached indexes cannot be compressed.

C. A compressed index can be uncompressed.

D. A compressed index cannot be uncompressed.

Which statement is FALSE regarding SBSPACES?

A. They are recoverable.

B. They do not obey transaction isolation modes.

C. They have read, write, and seek properties similar to a standard UNIX file.

D. Smart large objects within table rows are not required to be retrieved in one statement.

When KAIO is available and raw disk is used, which statement is true?

A. Logical Log IO is performed by the LIO VP.

B. Physical Log IO is performed by the PIO VP.

C. Logical Log IO is performed by the KAIO VP.

D. Physical Log IO is performed by the CPU VP.

Which HDR configuration parameter provides three synchronization modes to control when transaction commits are returned to client applications?

A. DELAY_APPLY

B. HDR_TXN_SCOPE

C. LOG_INDEX_BUILDS

D. FAILOVER_TX_TIMEOUT

What is the purpose of the GRANT ADMIN privilege?

A. Grants the admin privilege to create role separation.

B. Grants the admin privilege to perform DBSA functions.

C. Grants the admin privilege to use the Open Admin Tool.

D. Grants the admin privilege to run SQL administration API commands.

Which log file CANNOT be rotated using the default "message log rotate" SQL admin command?

A. audit log

B. message log

C. onbar debug log

D. onbar activity log

How can you ensure to hold the an update lock until the end of a transaction when fetching rows from a cursor?

A. Use the 'Committed Read' isolation level.

B. Use the RETAIN UPDATE LOCKS clause with isolation level.

C. Use the 'Cursor Stability' isolation level along the WITH HOLD clause.

D. Use the SET TRANSACTION command to with SERIALIZABLE clause.

Which command line utility does NOT have the equivalent functionality using the SQL Administration API?

A. oninit

B. onmode

C. onspaces

D. onparams