最新のC2090-619問題集で試験を準備する

IBM C2090-619 試験概要:

IBM C2090-619 試験シラバストピック:

IBM Informix 12.10 System Administrator 認定 C2090-619 試験問題：

問題 #1

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. OVER
B. FROM
C. SUM
D. AVG (SUM(dollars))

問題 #2

Which option is available through ifx_grid_connect()?

A. Rename a replicated database.
B. Enable use of TimeSeries columns in tables.
C. Defer propagation of DDL statements to other servers in the grid.
D. Enable automatic creation of templates in a grid.

問題 #3

Which statement is FALSE regarding SBSPACES?

A. They do not obey transaction isolation modes.
B. They have read, write, and seek properties similar to a standard UNIX file.
C. They are recoverable.
D. Smart large objects within table rows are not required to be retrieved in one statement.

問題 #4

For a query to be processed by the accelerator, the query or query block should meet the certain criteria. Which statement is FALSE?

A. The query or query block must refer to a subset of the tables in the AQT.
B. The query or query block must include at least 2 fact tables.
C. The scalar and aggregate functions in the query or query block must be supported by the Informix Warehouse Accelerator.
D. The table references or joins specified in the query or query block must be the same as the references in the data mart definition.

問題 #5

Which two actions can you perform with ontape? (Choose two.)

A. Restartable restore
B. Backup to cloud
C. Backup specific storage spaces
D. Restore specific storage spaces
E. Parallel backup of storage spaces

解説：