最新的IBM C2090-546免費考試真題

問題1

Click on the Exhibit button Given the following DDL statements:

If COL2 contains XML documents similar to the scenario, what is the end result of the CREATE INDEX statement?

A. A non-partitioned index will be created in table space TBSP21 since the INDEX IN clause of the table definition is ignored and XML_INDEX willautomatically be created within the first index partition listed in the create table statement.

B. An error will be returned because it is not possible to create an index for an XML column like COL2

C. A non-partitioned index will be created in the INDEX_TS table space for XML_INDEX.

D. TBSP11 and TBSP12 will each contain one local index for XML_INDEX since the local indexes will physically reside in the same table spaceas the related data.

正確答案: C

問題2

The following trusted context has been defined:

Which statement is correct?

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

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

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

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.

正確答案: C

問題3

How would you set the client information for a particular activity in a database using Workload Manager (WLM)?

A. Use the WLM_SET_CLIENT_INFO table function

B. Use the WLM_SET_CLIENT_INFO audit function

C. Use the WLM_SET_CLIENT_INFO stored procedure

D. Use the WLM_SET_CLIENT_INFO special register

正確答案: C

問題4

Which two database manager configuration parameters were added to support encryption? (Choose two.)

A. SSL_CLNT_KEYDB

B. SSL_CLIENT_KEYSTASH

C. SSL_CLIENT_STASH

D. SSL_CLIENT_KEYDB

E. SSL_CLNT_STASH

正確答案: A,E

問題5

A table named TAB_A has a primary key and 2 additional indexes that were created by the DBA. If the ADMIN_MOVE_TABLE procedure is used to MOVE table TAB_A from a table space named TS4K to a table space named TS16K, how many indexes will be on the table after the procedure finishes running?

A. 3

B. 2

C. 1

D. 0

正確答案: A

問題6

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

A. db2set DB2_HADR=ROS

B. db2set DB2_HADR_READ=STANDBY

C. db2set DB2_HADR_ROS=ON

D. db2set DB2_HADR=STANDBY

正確答案: C

問題7

Table TAB_A and index TABA_IDX were created by executing these SQL statements:

If this SQL statement is executed after 100,000 records have been inserted into table TAB_A:
ALTER INDEX taba_idx COMPRESS NO;
Which statement correctly describes what will happen to index TABA_IDX?

A. The index will remain compressed until the COMPRESS attribute for table TAB_A has been set to NO and both the table and the index have been REORGed.

B. The index will remain compressed until it is REORGed.

C. The index will be uncompressed immediately.

D. The index will remain compressed until the COMPRESS attribute for table TAB_A has been set to NO.

正確答案: B

問題8

If table TAB_A and index TABA_IDX are created as follows:

What can be compressed?

A. Only data in columns C1 and C2 of table TAB_A.

B. Only data in columns C1 and C2 in table TAB_A and index TABA_IDX.

C. All data in table TAB_A and index TABA_IDX.

D. All data in table TAB_

正確答案: B

最新的IBM DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade - C2090-546免費考試真題

聯系我們

站內鏈接

最新更新