C2090-546 by IBM Actual Free Exam Q&As

Question 1

Which two are valid BASED UPON CONNECTION attributes for a trusted context? (Choose two.)

A. Data stream encryption B. System authorization id C. Date and time D. Application program name E. Database role

Discussion 0

Correct Answer: A,B Vote an answer

Question 2

A range-partitioned table TAB1 has been created with COL1 and COL2 with COL1 as the partitioning column. What is the result of running the following statement? CREATE UNIQUE INDEX xcol2 ON tab1(col2) PARTITIONED

A. The index will be created as a unique non-partitioned index and a warning will be returned. B. The uniqueness will be enforced locally within each partition. C. The index will be created as a non-unique index and a warning will be returned. D. The statement will be rejected and an error will be returned.

Discussion 0

Correct Answer: D Vote an answer

Question 3

You have created a Trusted Context by using following command:

What is the ENCRYPTION type for the '9.26.146.201' address, the AUTHENTICATION type for
PUBLIC, and is MYCTX enabled?

A. None, WITHOUT AUTHENTICATION, Yes B. High, WITH AUTHENTICATION, Yes C. High, WITHOUT AUTHENTICATION, No D. None, WITH AUTHENTICATION, No

Discussion 0

Correct Answer: A Vote an answer

Question 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 -a B. db2val -i INSTANCE_NAME -v C. db2val -i INSTANCE_NAME -o D. db2val -i INSTANCE_NAME -s

Discussion 0

Correct Answer: D Vote an answer

Question 5

What authority is required to grant SECADM authority to roles and groups?

A. System Administrator B. Database Administrator with DATAACCESS and ACCESSCTRL privileges C. Database Administrator D. Security Administrator

Discussion 0

Correct Answer: D Vote an answer

Question 6

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

A. SSL_CLNT_KEYDB B. SSL_CLIENT_KEYDB C. SSL_CLIENT_KEYSTASH D. SSL_CLIENT_STASH E. SSL_CLNT_STASH

Discussion 0

Correct Answer: A,E Vote an answer

Question 7

Regardless of the value set for the mon_obj_metrics parameter, data is always collected for monitor elements reported by which of the two following table functions? (Choose two.)

A. MON_GET_TABLESPACE B. MON_GET_BUFFERPOOL C. MON_GET_CONTAINER D. MON_GET_TABLE E. MON_GET_INDEX

Discussion 0

Correct Answer: D,E Vote an answer

Question 8

Which of the following SQL statements will return monitoring information of tables in the DB2USER schema that begin with the letter 'A'?

A. SELECT * FROM TABLE(mon_get_table('DB2USER','A%',-2)) B. SELECT * FROM mon_get_table('DB2USER','A%',-2) C. SELECT * FROM TABLE(mon_get_table('DB2USER','',-2)) WHERE TABNAME LIKE 'A%' D. SELECT * FROM mon_get_table('DB2USER',",-2) WHERE TABNAME LIKE 'A%'

Discussion 0

Correct Answer: C Vote an answer

IBM DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade - C2090-546 Exam Practice Test