We're so confident of our products that we provide no hassle product exchange.
IBM Assessment: DB2 10.1 Advanced DBA for LUW Sample Questions:
1. A DBA wants to create a set of tables in a storage group named SG_1, but no table spaces have been assigned to this group. What kind of table spaces must the DBA assign to the storage group before the desired tables can be created?
A) Database managed space (DMS) table spaces that use FILE containers
B) Automatic storage (AS) table spaces
C) Database managed space (DMS) table spaces that use RAW containers
D) System managed space (SMS) table spaces
2. What must be done to convert a populated base table to a multidimensional clustering (MDC) table?
A) Execute the ALTER TABLE ... ORGANIZE BY DIMENSIONS statement to convert the table.
B) Export the data, execute the ALTER TABLE ... ORGANIZE BY DIMENSIONS statement to convert the table, and then import or load the datainto the converted table.
C) Export the data, create an MDC table, and then import or load the data into the MDC table.
D) Create an MDC table and then move the data in the base table to the MDC table with the db2move command.
3. What is the preferred method for reclaiming unused storage in a DMS table space?
A) Perform a REORG on each table within the table space, then perform an ALTER TABLESPACE...REDUCE operation.
B) Perform a REORG on each table within the table space, then perform an ALTER TABLESPACE...LOWER HIGH WATER MARK operation.
C) Perform an ALTER TABLESPACE...REDUCE operation.
D) Perform an ALTER TABLESPACE...LOWER HIGH WATER MARK operation, and then an ALTER TABLESPACE...REDUCE operation.
4. In which scenario should a DBA consider creating a multidimensional clustering (MDC) table instead of a regular base table?
A) To improve access performance for tables in an OLTP database.
B) To improve query performance in a data warehouse environment.
C) To improve index performance in a data warehouse environment.
D) To improve insert/delete performance for tables in an OLTP database.
5. Prior to migrating to DB2 10.1, a DBA executed the following command on a daily basis: db2_all "<<-1< db2 BACKUP DATABASE sales TO /mnt/backup" Which command can now be used to perform the same backup operation?
A) BACKUP DATABASE sales ON ALL DBPARTITIONNUMS EXCEPT DBPARTITIONNUM (1) TO /mnt/backup
B) BACKUP DATABASE sales ON ALL DBPARTITIONNUMS TO /mnt/backup
C) BACKUP DATABASE sales ON DBPARTITIONNUM (1) TO /mnt/backup
D) BACKUP DATABASE sales ON ALL DBPARTITIONNUMS EXCEPT CATPARTITION TO /mnt/backup
Solutions:
| Question # 1 Answer: B | Question # 2 Answer: C | Question # 3 Answer: D | Question # 4 Answer: B | Question # 5 Answer: A |
By Jonas
