최신 IBM certifications I A2090-541 무료샘플문제:
1. A database named FINANCE must be available to users 24x7x365. Which command should be used to create a backup image of the FINANCE database without having a significant impact on running applications?
A) BACKUP DATABASE finance ONLINE TO /mnt/backup UTIL_IMPACT_LIM 50
B) BACKUP DATABASE finance ONLINE TO /mnt/backup PARALLELISM 5
C) BACKUP DATABASE finance ONLINE TO /mnt/backup UTIL_IMPACT_PRIORITY 15
D) BACKUP DATABASE finance ONLINE TO /mnt/backup COMPRESS
2. Click the Exhibit button.
Refer to the exhibit for information on how tables TABA and TABB were created. What would be the number of extents allocated for each table after the successful creation of both tables?
A) TABA: 1 extent TABB: 1 extent
B) TABA: 4 extents TABB: 40 extents
C) TABA: 2 extents TABB: 20 extents
D) TABA: 1 extent TABB: 10 extents
3. 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) Incremental backup images for the original database can be used to restore the new database.
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) Existing packages will be copied to the new database and can be used immediately.
4. 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
5. Table TAB_A is already populated with a large number or rows, and you wish to insert more rows from a file named data.del. While these row are added, you want users to still have full access to the table in read/Write mode. Which command should you use to do this?
A) LOAD FROM data.del OF DEL INSERT INTOtab_a
B) IMPORT FROM data.del OF DEL INSERT INTOtab_a ALLOW WRITE ACCESS
C) IMPORT FROM data.del OF DEL INSERT INTOtab_a
D) LOAD FROM data.del OF DEL INSERT INTO taba ALLOW WRITE ACCESS
질문과 대답:
질문 # 1 정답: C | 질문 # 2 정답: B | 질문 # 3 정답: B,C | 질문 # 4 정답: A,D | 질문 # 5 정답: C |