IBM DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade Sample Questions:
1. Which command will enable Oracle applications to work within a DB2 9.7 environment?
A) db2set DB2_COMPATIBILITY=ORACLE
B) db2set DB2_COMPATIBILITY_VECTOR=ORA
C) db2set DB2_COMPATIBILITY=ORA
D) db2set DB2_COMPATIBILITY_VECTOR=ORACLE
2. A table named HR.PAYROLL resides in table space TS4 and has a page size of 4K. You want to change the page size of this table to 16K without taking the table offline. Assuming a table space named TS16 with a page size of 16K exists, which command can be used to accomplish this goal?
A) CALL ADMIN_MOVE_TABLE (R? AYROLL? S16? S16?, , , , ,OVE?CALL ADMIN_MOVE_TABLE (?R? ?AYROLL? ?S16? ?S16??, ?, ?, ?, ?,?OVE?
B) CALL ADMIN_MOVE_TABLE (R? AYROLL? S16? S16?, , , , ,OPY?CALL ADMIN_MOVE_TABLE (?R? ?AYROLL? ?S16? ?S16??, ?, ?, ?, ?,?OPY?
C) CALL ADMIN_COPY_TABLE (R? AYROLL? S16? S16?, , , , ,OVE?CALL ADMIN_COPY_TABLE (?R? ?AYROLL? ?S16? ?S16??, ?, ?, ?, ?,?OVE?
D) CALL ADMIN_COPY_TABLE (R? AYROLL? S16? S16?, , , , ,OPY?CALL ADMIN_COPY_TABLE (?R? ?AYROLL? ?S16? ?S16??, ?, ?, ?, ?,?OPY?
3. When using an online backup recovery strategy, what steps are required to backup and recover a database to the end of backup timestamp?
A) Backup the database and include the recovery logs.
Restore the database to the end of backup timestamp.
B) Backup the database.
Roll forward the database to the end of backup timestamp.
C) Backup the database and include the recovery logs.
Restore the database.
Roll forward the database to the end of backup timestamp.
D) Backup the database.
Restore the database.
Roll forward the database to the end of backup timestamp.
4. A table named TAB_A has a primary key and 2 additional indexes that were created by the DBA. If the ADMIN_MOVE_TABLE procedure is used to MOVE table TAB_A from a table space named TS4K to a table space named TS16K, how many indexes will be on the table after the procedure finishes running?
A) 2
B) 0
C) 3
D) 1
5. Which of the following is NOT a valid workload name?
A) SYS_WKLOAD
B) DBA_WKLOAD
C) &WKLOAD
D) #WKLOAD
Solutions:
Question # 1 Answer: B | Question # 2 Answer: A | Question # 3 Answer: C | Question # 4 Answer: C | Question # 5 Answer: A |
Frequently Bought Together - IBM 000-546 Value Pack
$119.98 $69.99
50%
Price for 000-546 Q&A Value Pack (.pdf version and testing engine):
PDF is easy for reading, and Testing Engine can enhance your memory in an interactive manner. So many customers want to have both of them, for which we launched a large discount. Now buy the two versions of our material, you will get a 50% discount.
DB2 000-546 Value Pack is a very good combination, which contains the latest 000-546 real exam questions and answers. It has a very comprehensive coverage of the exam knowledge, and is your best assistant to prepare for the exam. You only need to spend 20 to 30 hours to remember the exam content that we provided.
ITCertKing is the best choice for you, and also is the best protection to pass the IBM 000-546 certification exam.
Fast delivery after payment
The moment you have paid for our DB2 000-546 training vce torrent, you will receive our exam study materials in as short as five minutes. I believe a seasoned veteran as you are, you have fast understanding about what time really means for those who make preparations for the test. Therefore, fast delivery is of great significance for them, which is also the reason why customers are prone to buy 000-546 study materials that can be delivered fast. To cater to the customers’ demand, our 000-546 : DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade latest study pdf provide them with timely dump “battery”, which must be in aid of them. Here under the guidance of our 000-546 study materials, the customers will attain their ambition in the near future.
Free renewal in one year
For the benefit of our customers, our IBM 000-546 exam prep vce offer free renewal to keep them informed of the latest questions in one year, which is utterly a privilege for them compared with that of other exam study materials in the field. What's more, our experts who are in charge of the renewal matters will be in the first time send the renewed dumps to mailboxes of their customers as long as the experts scent out the renewal. As a kind of people who is as vigilant to the renewal of 000-546 training vce torrent as a cat that is vigilant to the mouse, our experts will never miss any of the renewal in the DB2 000-546 exam dump torrent.
if you still did not pass the exam, then as long as you provide us with the scan of authorized test centers (Prometric or VUE) transcript, we will FULL REFUND after the confirmation. We absolutely guarantee that you will have no losses.