C2090-619 実際試験問題と解答 - 模擬練習 - 受験自信を増やす

/ 4

Question No : 1
Which statement is true for starting Connection Manager?

A.Only user root and informix.
B.Any user of the DBSA group.
C.Any user who is granted privileges to connect to the sysadmin database.
D.Only a user of the DBSA group with privilege to connect to the sysadmin database.

正解:

Question No : 2
Which value of DRINTERVAL should be used for HDR_TXN_SCOPE configuration parameter to take effect?

A.-1
B.0
C.1
D.30

正解:

Question No : 3
store1, store2, store3 and store4 are defined as four servers participating in a GRID.

Which statement is true?

A.The SELECT query is not a GRID query.
B.The SELECT query will return results from all grid servers.
C.The SELECT query will return results from store1 and store2.
D.The SELECT query will return results from store3 and store4.

正解:

Question No : 4
Which statement accurately describes the mapped user functionality in Informix?

A.The DBSA can control the access to the database at the table level by creating different security labels for each user.
B.The DBSA can create different roles for each user in order to verify whether the user who is attempting an operation has the necessaryprivileges.
C.The DBSA can configure the server to allow database access by external users who do not have operating system accounts on the hostcomputer.
D.The DBSA can grant access to the database server to users of the host computer operating system by implementing different authenticationmechanisms for each user.

正解:

Question No : 5
Which is a valid Pluggable Authentication Module (PAM) mode in Unix?

A.Login mode
B.Client mode
C.Server mode
D.Password mode

正解:

Question No : 6
Which two technologies use the ENCRYPT_MAC configuration parameter to control the level of message authentication code (MAC) generation? (Choose two.)

A.On-disk encryption
B.Enterprise Replication
C.Column level encryption
D.High-Availability Data Replication
E.Server-to-server distributed query communication

正解:

Question No : 7
What security role is required for you to create trusted-context objects?

A.AAO
B.DBSA
C.DBSSO
D.DBSECADM

正解:

Question No : 8
Which statement describes the behavior of an Informix instance when the IFX_EXTEND_ROLE configuration parameter is set to ON.

A.All users with the EXTEND role can grant it to other users.
B.All users with the default role can register external routines.
C.All users can create external routines in the database server.
D.All users with the EXTEND role can register external routines.

正解:

Question No : 9
Which statement accurately describes the selective row-level auditing feature in Informix?

A.Auditing can be configured so that row-level events of only selected views are recorded in the audit trail.
B.Auditing can be configured so that row-level events of only selected tables are recorded in the audit trail.
C.Auditing can be configured so that events of only selected rows within a table are recorded in the audit trail.
D.Auditing can be configured so that row-level events of only selected partitions are recorded in the audit trail.

正解:

Question No : 10
Given these statements are executed: which statement is true?

A.The entire query will be accelerated to Informix Warehouse Accelerator (IWA) including the OLAP operators.
B.The entire query will be executed on Informix database server, and no portion of it will be accelerated by Informix Warehouse Accelerator (IWA).
C.The underlying SELECT, JOIN, GROUP BY, and PROJECT operation of the query is accelerated to Informix Warehouse Accelerator (IWA), and OLAP expressions are evaluated by Informix database server.
D.The underlying SELECT, JOIN, GROUP BY, and PROJECT operation of the query will be executed by Informix database server, and the OLAPexpressions are evaluated by Informix Warehouse Accelerator (IWA).

正解:

Question No : 11
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 include at least 2 fact tables.
B.The query or query block must refer to a subset of the tables in the AQ
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.

正解:

Question No : 12
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))

正解:

Question No : 13
What kinds of Table Level Restores can be done by the archecker utility?

A.Only logical restore.
B.Only physical restore.
C.Only point in time restore.
D.Physical, logical, and point in time restores.

正解:

Question No : 14
Which two actions can you perform with ontape? (Choose two.)

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

正解:

Question No : 15
Which statement is true about restartable restore?

A.ontape can perform restartable restores if a backup is taken to disk.
B.Restartable restore is the ability to restart a failed restore using onbar.
C.Restartable restore is the ability to restart a failed restore using ontape.
D.Restartable restore is the ability to restart an instance using a restore from some other computer.

正解:

IBM C2090-619 問題練習