C2090-541 - DB2 9.7 DBA for Linux UNIX and Windows Exam

Go back to IBM

Example Questions

Which command will reorg all indexes for a table named TABA? You are asked to create a new database called PRODDB where no privileges will be automatically granted to PUBLIC Which CREATE statement will accomplish this? Which feature introduced in DB2 9.7 allows faster roll-in and roll-out of data partitions? Which method may be used to collect deadlock information in DB2 9.7? A DBA wants to use Label Based Access Control (LBAC) to protect Individual rows in a table. Which data type must be used to create a column to hold the necessary LBAC security data? What are three implementations for DB2 Workload Management? (Choose three.) 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? Which statement is true about using the EXPORT utility with a table that contains XML data? A database named PAYROLL was backed up on Sunday. On Tuesday, a table space in the PAYROLL database was renamed from TBSP1 to EMPINFO_TBSP. On Thursday, the database was restored from the backup image created on Sunday. Which command must be issued to roll the renamed table space forward to the current date and time? For which two events is it recommended to execute RUNSTATS? (Choose two.) What is the purpose of a role? If this command is executed: db2advis -d sample -g What is the Design Advisor using to perform its analysis? Which two tools can create a compression dictionary? (Choose two.) What are three system and database level authorizations available with DB2? (Choose three.) Given the DDL shown below: CREATE TABLE tab1 (coll SMALLINT ); CREATE VIEW v1 AS SELECT coll FROMtabl WHERE coll > 25 ; CREATE VIEW V2 AS SELECT COI1 FROM v1 WITH CASCADED CHECK OPTION CREATE VIEW v3 AS SELECT coll FROM v2 WHERE coll < 100 ; Which statement will fail? A file named db2advise.in contains the following text: -#SET FREQUENCY 100 SELECT COUNTO FROM employee; SELECT AVG(bonus), AVG(salary) FROM employee GROUP BY workdept ORDER BY workdept; Which command will cause the Design Advisor to make recommendations for a database named SAMPLE, using the information found in this file? A file named db2advise.in contains the text shown below: -#SET FREQUENCY 100 SELECT COUNTO FROM employee; SELECT * FROM employee WHERE lastname='HAAS'; What does the line -#SET FREQUENCY 100 convey when this file is used as input for the Design Advisor? Which method may be used to collect deadlock information in DB2 97? BOB and ALICE moved from the DEVELOPER group to the ANALYST group. As the security administrator, which two commands would remove Bob and Alice from the DEVELOPER group? (Choose two.) The SELF_TUNING_MEM database configuration (db cfg) parameter is set to ON. Which three statements will cause the memory tuner to actively tune memory within the database? (Choose three.) When using SQU and JDBC applications to connect to the host DB2 database, which software license must be registered? When are packages automatically rebound? Which statement is true about unique constraints? A database named PAYROLL resides on an IBM System Storage DS8000 and a database administrator would like to use Flash Copy to back up the database. Which command can be used to accomplish this? When using table partitioning, which three operations are valid? (Choose three.) For which two purposes would you run the db2look tool? (Choose two.) Which three authorizations allow you to execute db2pd? (Choose three.) Because of an application abend, a database named PAYROLL needs to be restored to approximately 9:26 am on June 1, 2009. After the database is restored from a backup image, the command shown below is executed: ROLLFORWARD DATABASE payroll TO 2009-06-01-09.26.44.609002 USING LOCAL TIME AND STOP When this command is executed, the error shown below is generated: SQL4970N Roll-forward recovery on database "PAYROLL" cannot reach the specified stop point (end-of-log or point-in-time) because of missing log file(s) on node(s) "0". Which two commands could be used to resolve this error? (Choose two.) When using Optim Database Administrator to generate a change script, users are given which two EXPORT utility output formats to preserve their data when they drop a table then create a new table with the data? (Choose two.) What correctly describes an MDC table rollout cleanup for qualifying DELETE statements after the statement shown below is run? SET CURRENT MDC ROLLOUT MODE IMMEDIATE What will collect information about dynamic and static SQL statements? You are unable to configure a data source using DB2 Discovery. What are three reasons why this is happening? (Choose three.) The event monitor for transactions has been replaced in DB2 9.7 with which tool? A table named CUSTOMER has an XML column named CUSTINFO that contains several XML documents. Which SQL statement will retrieve XML documents from the CUSTOMER table and convert them to character strings? You want to federate communication between two databases. What are two key requirements? (Choose two.) Tables TABLE_A and TABLE_B in database TESTDB have the same data structure (same columns with the same definitions). You wish to unload the data from the two tables into a single file In PC/IXF format. Which command(s) can be used to do this? Which SQL statement will execute successfully? 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? 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? Given a table that is already compressed, if you create a new index on that table, when will the index be compressed? Which list of automatic maintenance parameters can have a policy defined to specify their automatic behavior? How does the DB2 Server identify the list of GSS-API plug-ins it supports? What are two purposes of the db2mtrk command? (Choose two.) Given the following CREATE TABLE statement: CREATE TABLE applicant (id INTEGER NOT NULL PRIMARY KEY, lastname VARCHAR(50)); Which SQL statement will execute successfully? Which two DB2 commands are used to extract, format, and present diagnostic information? (Choose two.) What are three default service classes used by Work Load Management? (Choose three.) Which two SOL statements are explainable statements? (Choose two.) How do you turn on Self-Tuning Memory Manager (STMM)? You are running an IMPORT utility and have specified the option COMMITCOUNT AUTOMATIC Which two reasons will cause the IMPORT utility to COMMIT? (Choose two.) You want to estimate the potential index compression savings for existing indexes on a table What do you use to obtain this information?