IBM DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade 認定 000-546 試験問題:

1. The following trusted context has been defined:

Which statement is correct?

A) 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) 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 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, it will have role CONTEXT_ROLE associated with the connection.

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

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

3. Which two authorities can grant SELECT privilege on a table? (Choose two.)

A) SYSADM authority on the instance.
B) SECADM authority on the database.
C) DATAACCESS authority on the database.
D) DBADM authority on the database.
E) ACCESSCTRL authority on the database.

4. You are creating a table with 1 LOB column. The size of the LOB column is less than the size of the LOB descriptor. When creating this table you did not specify an INLINE LENGTH. Which option is correct?

A) The ALTER TABLE .. INLINE LENGTH .. command is required so the LOB data can be included in the base table.
B) Only the LOB descriptor will be stored in base table and the LOB data will be stored in the LOB storage object.
C) Both the LOB descriptor and the LOB data will be stored in the base table.
D) Only the LOB data will be stored in the base table.

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

A) db2set DB2_HADR=STANDBY
B) db2set DB2_HADR_ROS=ON
C) db2set DB2_HADR=ROS
D) db2set DB2_HADR_READ=STANDBY

質問と回答：