We're so confident of our products that we provide no hassle product exchange.
IBM DB2 10.1 Advanced DBA for Linux UNIX and Windows Sample Questions:
1. For a multi-partitioned database, what is the default behavior of the BACKUP DATABASE command?
A) It will backup just the catalog partition.
B) It will backup just the partitions that reside on the host that the command is executed from.
C) It will backup just the partition that the command is executed from.
D) It will backup all partitions simultaneously.
2. In which situation would you NOT use a redirected restore?
A) To move table space containers onto different physical devices.
B) To restore a backup image from one operating system to another.
C) To restore a backup image to a target machine that is different from the source machine.
D) To redefine the paths of a defined storage group.
3. Which statement about the initiation of parallel I/O is correct?
A) For list prefetching, each list of data pages is divided into smaller lists according to extent boundaries and assigned to different I/O servers.
B) For sequential prefetching, parallel I/O is initiated when the prefetch size is a multiple of the extent size for a table space. Each prefetch request is divided into smaller requests and assigned to different I/O servers.
C) For sequential prefetching, parallel I/O is initiated when the extent size is a multiple of the prefetch size for a table space. Each prefetch request is divided into smaller requests and assigned to different I/O servers.
D) For read-ahead prefetching, each list of data pages is divided into smaller lists according to extent boundaries and assigned to different I/O servers.
4. You need to restore a table space that was backed up earlier, but before you begin a restore operation you want to determine whether any tables in the table space were
populated with a LOAD ... NONRECOVERABLE operation. What can be used to provide this information?
A) The db2dart command
B) The database recovery history file
C) The INSPECT utility
D) The db2pd command
5. The following message is frequently seen in the DB2 Diagnostics Log file (db2diag.log): MESSAGE : ADM5502W The escalation of "28581" locks on table "TEST.TABLE1" to lock intent "X" was successful. Which two database configuration parameter settings should be checked? (Choose two.)
A) MAXAGENTS
B) MAXLOCKS
C) LOCKTIMEOUT
D) MAXAPPLS
E) LOCKLIST
Solutions:
| Question # 1 Answer: C | Question # 2 Answer: B | Question # 3 Answer: B | Question # 4 Answer: B | Question # 5 Answer: B,E |
By Xaviera
