000-541 - DB2 9.7 DBA for Linux UNIX and Windows

Go back to IBM

Example Questions

You want to grant user BOB the ability to create tables in table space PLANS and to grant this privilege to others Which command would you use? 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? 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? Which statement is true about using the EXPORT utility with a table that contains XML data? Which three table features can be used concurrently in the same table? (Choose three.) Which SQL statement will execute successfully? What will collect information about dynamic and static SQL statements? The event monitor for transactions has been replaced in DB2 9.7 with which tool? Which group of memory consumers can be adjusted by the Self-Tuning Memory Manager (STMM)? Which DB2 tool is a Java-based, generic XML parser which produces readable text output from the data generated by an event monitor? Which two plug-in types does the DB2 database system provide? (Choose two.) 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? Scheduled tasks are executed by the DB2 autonomic computing daemon (db2acd). Every five minutes the daemon checks for new or updated tasks. If a task is scheduled to run every five minutes and for some reason, the task takes seven minutes to complete, the daemon will not execute another instance of the task at the next 5 minute interval. Which minute mark will allow the next task to run? 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? 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 When using table partitioning, which three operations are valid? (Choose three.) 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 method may be used to collect deadlock information in DB2 9.7? Index TAB 1X1 was created as shown below: CREATE INDEX tablxl ON tab1(col_1) Which modification to index TAB 1X1 can be performed with an ALTER INDEX statement? 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.) What are two purposes of the db2mtrk command? (Choose two.) You have a UTIL_IMPACT_LIM of 50 and a UTIL_IMPACT_PRIORITY of 60 for the backup utility What are the maximum amount of system resources that the backup utility can use? Which feature introduced in DB2 9.7 allows faster roll-in and roll-out of data partitions? How does the DB2 Server identify the list of GSS-API plug-ins it supports? You are asked to create a new database called PRODDB where no privileges will be dautomatically granted to PUBLIC Which CREATE statement will accomplish this? When are packages automatically rebound? 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- 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.) Which three authorizations allow you to execute db2pd? (Choose three.) Which method may be used to collect deadlock information in DB2 97? 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.) If this command is executed: db2advis -d sample -g What is the Design Advisor using to perform its analysis? You want to federate communication between two databases What are two key requirements? (Choose two.) Which statement is correct when describing the AUTOCONFIGURE command? Which statement is correct about informational constraints? Which three types of work can be defined for a Workload Management service class set? (Choose three.) Which two tasks can DB2 Workload Management do? (Choose two.) Which statement is true about unique constraints? Which administrative authority is needed to run the audit stored procedures and table functions such as the AUDIT_DELIM_EXTRACT stored procedure? 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? A database administrator takes a full backup of the PRODUCTS database every Sunday. During the week, two other backups are taken, one on Tuesday and one on Thursday. The PRODUCTS database is about 800 GB in size, and about 20 percent of the data is modified throughout a week. Assuming that backup times need to be kept to a minimum, which command should be used to produce the Tuesday and Thursday backup images? 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 two SOL statements are explainable statements? (Choose two.) Which two data types can be in-lined to enhance compression? ( Choose two.) 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? Which two tools can create a compression dictionary? (Choose two.) You are unable to configure a data source using DB2 Discovery What are three reasons why this is happening? (Choose three.) Which two can be replicated using HADR? (Choose two.) You have a job scheduled to run every Saturday; the scheduler is turned off on Friday and then restarted on Monday. The job scheduled for Saturday is now a job that is scheduled in the past. Which configuration parameters will allow your Saturday job to run when the scheduler is restarted? What are three system and database level authorizations available with DB2? (Choose three.) What is the purpose of the XMLPARSE() function?