최신 IBM certifications I A2090-541 무료샘플문제:

1. Which two can be replicated using HADR? (Choose two.)

A) database configuration changes
B) CREATE TABLE... NOT LOGGED INITIALLY operations
C) LOAD operations
D) Data Definition Language (DDL) statements

2. A DBA wants to use Label Based Access Control (LBAC) to protect Individual rows in a table. Which data type must be used to create a column to hold the necessary LBAC security data?

A) SYSPR0C.DB2LBACU\BEL
B) SYSPR0C.DB2SECURITYU\BEL
C) SYSIBM.DB2LBACLABEL
D) SYSIBM.DB2SECURITYLABEL

3. Which two plug-in types does the DB2 database system provide? (Choose two.)

A) Group retrieval
B) Kerberos authentication
C) Encryption authentication
D) Server authentication

4. Which statement is correct about using the TAKEOVER HADR command?

A) The TAKEOVER HADR command can only be issued on the primary database and the primary database is connected to the standby database when the command is issued.
B) The TAKEOVER HADR command can only be issued to switch the roles of the primary and standby databases if the standby database is in local catchup state.
C) The TAKEOVER HADR command can only be issued to switch the roles of the primary and standby databases if the databases are in peer state.
D) The TAKEOVER HADR command can only be issued on the standby database and the primary database is not connected to the standby database when the command is issued.

5. Index TAB 1X1 was created as shown below:
CREATE INDEX tablxl ON tab1(col_1)
Which modification to index TAB 1X1 can be performed with an ALTER INDEX statement?

A) ALTER INDEXtablxl PCTFREE 40
B) ALTER INDEXtablxl CLUSTER
C) ALTER INDEXtablxl ADD COLUMN (col_2)
D) ALTER INDEXtablxl COMPRESS YES

질문과 대답: