[2026] IBM DB2 10.1 DBA for Linux, UNIX, and Windows

문제1

Which statement about BEFORE triggers is FALSE?

A. A BEFORE trigger's action is executed for each row in the set of affected rows instead of executing the trigger event.

B. A BEFORE trigger's action is executed for each row in the set of affected rows before the trigger event executes.

C. A BEFORE trigger cannot be used to modify data in a database because they are activated before the trigger event is applied to the database.

D. A BEFORE trigger is used to perform validation of input data and to automatically generate values for newly inserted rows.

정답: A

문제2

The following commands are executed against a database named MY_DB, which has been configured to use archival logging:

Which statement is true?

A. Upon completion of the Load, a backup image of table T1 is automatically generated.

B. Upon completion of the Load, the table T1 is placed into "Backup Pending" state.

C. After a Restore and Rollforward operation, the loaded data is stored into a copy-image file and table T1 is fully available.

D. After a Restore and Rollforward operation, table T1 would be marked unavailable and can only be dropped.

정답: D

문제3

What authorization is needed to execute the CREATE MASK statement?

A. SECADM

B. SYSADM

C. SQLADM

D. SYSCTRL

정답: A

문제4

What authorization is needed to use the AUDIT statement to create an audit policy?

A. SECADM

B. DBADM

C. SYSADM

D. SYSMAINT

정답: A

문제5

If the following command is executed:

Which statement is true?

A. While the Load is executing, other transactions can both read and write into table SCHEMA6.T1

B. Rejected records will be inserted into the table SCHEMA2.E1

C. If using a remote database connection, the file "/mnt/datafile.del" must be accessible to the database server host.

D. Any indexes defined on table SCHEMA6.T1 will be marked invalid upon completion of the Load.

정답: B

문제6

Which authority is required to revoke SECADM authority?

A. SECADM

B. DBADM

C. SYSADM

D. SQLADM

정답: A

문제7

Due to a hardware failure, it appears that there may be some corruption in database DB_1 as DB2 is reporting a "bad page". DB2DART is performed for the entire database and it appears that several bad pages were detected in table space TBSP_1. What command should be used to recover the database and repair the corruption in table space TBSP_1?

A. ROLLFORWARD DATABASE

B. RESTORE TABLESPACE

C. RESTART DATABASE

D. RESTORE DATABASE

정답: D

문제8

What must a user possess if they want to run a DB2 Command Line Processor (CLP) script against a database using the Job Manager in IBM Data Studio?

A. Permission to log in to the database client using secure shell (SSH).

B. Permission to log in to the database server using telnet.

C. Permission to log in to the database client using telnet.

D. Permission to log in to the database server using secure shell (SSH).

정답: D

문제9

Which statement is correct when describing Range Clustered Tables (RCT) as compared to regular base tables that use at least one index?

A. RCTs require more logging, less buffer pool space, and more maintenance.

B. RCTs require more logging, more buffer pool space, and less maintenance.

C. RCTs require less logging, more buffer pool space, and less maintenance.

D. RCTs require less logging, less buffer pool space, and less maintenance.

정답: D

문제10

Which of the following table types is NOT supported by the load utility?

A. A Range Partitioned table

B. A Global Temporary table

C. A Temporal table

D. A Multidimensional Clustering table

정답: B

IBM DB2 10.1 DBA for Linux, UNIX, and Windows - C2090-611무료 덤프문제 풀어보기

우리와 연락하기

유용한 링크

최신 업데이트