最新DB2 C2090-546考試題庫，IBM C2090-546課程的擬真試題下載

問題1
When a database is created who is granted SECADM by default?

A. Members of the SECADM_GROUP.

B. The database creator and members of the SYSADM_GROUP.

C. Members of the SYSADM_GROUP.

D. The database creator.

正確答案: D

問題2
A DBA wants to use XQuery on a XML document to determine the number of lock waits for a particular workload. Which of the following table functions should be used?

A. MON_GET_WORKLOAD_DETAILS

B. MON_GET_LOCKS_DETAILS

C. MON_GET_WORKLOAD

D. MON_GET_LOCKS

正確答案: A

問題3
When using an online backup recovery strategy, what steps are required to backup and recover a database to the end of backup timestamp?

A. Backup the database.
Roll forward the database to the end of backup timestamp.

B. Backup the database and include the recovery logs.
Restore the database.
Roll forward the database to the end of backup timestamp.

C. Backup the database.
Restore the database.
Roll forward the database to the end of backup timestamp.

D. Backup the database and include the recovery logs.
Restore the database to the end of backup timestamp.

正確答案: B

問題4
You have installed a copy of DB2 on your windows server. After the installation you only want to verify the instance (INSTANCE_NAME) of this installed copy followed by the starting of this database instance. Which of the following statements is correct?

A. db2val -i INSTANCE_NAME -s

B. db2val -i INSTANCE_NAME -a

C. db2val -i INSTANCE_NAME -v

D. db2val -i INSTANCE_NAME -o

正確答案: A

問題5
Which statement describes the state of the DMS table space TBS_1 after the successful execution of the following script? ALTER TABLESPACE tbs_1 MANAGED BY AUTOMATIC STORAGE

A. The table space TBS_1 is managed by automatic storage, online and all its containers are relocated to the database assigned automatic storage paths.

B. The table space TBS_1 is managed by automatic storage, online and still using its old containers.

C. The table space TBS_1 is managed by automatic storage and in a rebalance pending state waiting for the REBALANCE command.

D. The table space TBS_1 is managed by automatic storage, in a backup pending state and all its containers are relocated to the database assigned automatic storage paths.

正確答案: B

問題6
If the following statement is executed:

What occurs if user USER2 connects from the IP address 10.10.10.10 where the database is cataloged with SERVER_ENCRYPT?

A. The connection will be encrypted with HIGH encryption.

B. The connection will not be encrypted.

C. The connection will be encrypted with NORMAL encryption.

D. The connection will be encrypted with LOW encryption.

正確答案: C

問題7
The following trusted context has been defined:

Which statement is correct?

A. If APP1 establishes a connection to the database, a connection to the database server at address 9.26.113.204 will be enabled using a role of CONTEXT_ROLE.

B. If APP1 connects from address 9.26.113.204, it will have role CONTEXT_ROLE associated with the connection.

C. If USER1 connects to the database from address 9.26.113.204 without providing a password, the connection will run under userid APP1.

D. If APP1 connects from address 9.26.113.204 and no role has been granted to APP1, then and only then will role CONTEXT_ROLE be used.

正確答案: B

問題8
Which command will enable reads on an High Availability and Disaster Recovery (HADR) standby server?

A. db2set DB2_HADR=ROS

B. db2set DB2_HADR_ROS=ON

C. db2set DB2_HADR_READ=STANDBY

D. db2set DB2_HADR=STANDBY

正確答案: B

先試後買

購買之前，你可以先嘗試下載一個試用版本。目前我們只提供PDF版本的試用DEMO，軟件版本只提供截圖。

專業認證

品質保證

輕松通過

Try Before Buy

最新的真實試題

相關鏈接

聯繫我們