Click the Exhibit button
Refer to the logging configuration parameters shown in the exhibit.
If there are currently 100 active log files and there is an error with archiving log file 1. What will happen when DB2 attempts to create log file 101?
A. DB2 will attempt to archive log file 1 to the regular archive location up to five times. If log archival still fails after the fifth attempt, the application will receive a "log full" error and at least one transaction will be rolled back.
B. The transaction that prompts DB2 to try and create log file 101 receives a "log full" error and is rolled back because the active log space is full. Since the physical log path is not full, the BLK_LOG_DSK_FUL parameter does not take effect, so the database does not appear hung.
C. The database will appear hung because the active log space will be full and BLK_LOG_DSK_FUL is set to YES. Once log file 1 is archived, DB2 will begin normal processing.
D. DB2 will continue normal processing. It will create log file 101 while attempting to archive log file 1 up to five times. If the fifth attempt to archive log file 1 to the regular archive location fails, it will be placed in the FAILARCHPATH location until the regular archive location becomes available.
正解:D
質問 2:
You are running a LOAD utility and have not provided an exception table. What will happen if duplicates for a unique key get Inserted during the LOAD phase due to duplicates in the input file?
A. LOAD will complete but the table being loaded will be placed in SET INTEGRITY PENDING state
B. LOAD will create the exception table.
C. LOAD will fail and generate an error message.
D. LOAD will eliminate the duplicate rows from the table and give a warning message.
正解:D
質問 3:
Which two operations allow you to control the creation of the compression dictionary using the KEEPDICTIONARY/RESETDICTIONARY options? (Choose two.)
A. REORG
B. LOAD
C. TRUNCATE
D. IMPORT
正解:A,B
質問 4:
What are three authorization categories in DB2? (Choose three.)
A. Object-level
B. System-level
C. Instance-level
D. Database-level
E. Network-level
正解:A,B,D
質問 5:
Click the Exhibit button.
IBM 000-541: Practice Exam
Given the TCP/IP configuration shown in the exhibit, to what must the alternate server be set on the Primary, to allow Automatic Client Reroute to connect to the Standby after a HADR takeover?
A. 192.168.2.1
B. 192.168.1.102
C. 192.168.1.1
D. 192.168.2.102
正解:D
質問 6:
Which command will reorg all indexes for a table named TABA?
A. REORG INDEXES ALL FOR TABLEtaba
B. REORG INDEXES FORtaba
C. REORG TABLEtaba AND INDEXES ALL
D. REORG TABLEtaba INDEXES INPLACE
正解:A
質問 7:
When using SQU and JDBC applications to connect to the host DB2 database, which software license must be registered?
A. DB2 Connect
B. DB2WSE
C. IBM Data Server Driver for JDBC and SQU
D. DB2 ESE
正解:A
質問 8:
A database administrator created a new database from an existing full database backup image. If the original database resided on a 64-bit AIX server and the new database was created on a different 64-bit AIX server, which two statements are correct? (Choose two.)
A. Existing packages will be copied to the new database and can be used immediately.
B. Existing SQL procedures must be dropped and re-created in the new database before they can be used.
C. Incremental backups are not allowed until a non-incremental backup is taken.
D. Incremental backup images for the original database can be used to restore the new database.
正解:B,C
早瀬** -
とても詳細に記述されている解説はわかりやすいので
C2090-541に苦手意識があるかたでも読みやすいです。それのお陰で高得点です。就職上手くいけそう。