ibm db2 udb v8.1 database admin for linux unix&windows

1.Which of the following statements is required to register a federated database source?
A.CREATE VIEW
B.CREATE WRAPPER
C.CREATE TRANSFORM
D.CREATE TYPE MAPPING
Correct:B
2.On which of the following event types can a WHERE clause be used to filter the data returned by the event monitor?
A.TABLES
B.DEADLOCKS
C.TABLESPACES
D.CONNECTIONS
Correct:D
3.Assuming a user has CREATETAB privileges, which of the following privileges will allow the user to create a table T2 with a foreign key that references table T1?
A.SYSCTRL
B.SYSMAINT
C.UPDATE on table T1
D.CONTROL on table T1
Correct:D
4.Which of the following is required to specify the output data during an EXPORT?
A.Union
B.Key range
C.Equi-join
D.Fullselect
Correct:D
5.Given an application with the embedded static SQL statement: INSERT INTO admin.payroll (employee, salary) VALUES ("Becky Smith",80000) Which of the following privileges must a user hold to run the application?
A.ALTER on the table
B.INSERT on the table
C.DBADM on the database
D.EXECUTE on the package
Correct:D
6.Which two of the following are only possible using a redirected restore?
A.Redefining table space containers
B.Replacing a damaged recovery history file
C.Recovering table spaces in roll-forward pending
D.Specifying an alternate log path for roll forward
E.Restoring the database onto a different server with the same operating system
Correct:A E
7.Which two of the following DB2 commands can be used independently to update the statistical information used by the optimizer when choosing an access path?
A.REORG
B.IMPORT
C.REBIND
D.RUNSTATS
E.CREATE INDEX
Correct:D E
8.Which of the following DB2 utilities can insert data into a view?
A.LOAD
B.UPLOAD
C.IMPORT
D.LOADVIEW
Correct:C
9.After a successful table space restore command, which of the following states will the table space be in?
A.Restore pending
B.Recovery pending
C.Restore in progress
D.Roll forward pending
Correct:D
10.Which of the following will the REORGCHK command display?
A.Only packages that need to be rebound
B.Only tables that need to be reorganized
C.Information to determine which tables need to be reorganized
D.The timestamp indicating the last time each table was reorganized
Correct:C
11.Given the following DB2DIAG.LOG entry: "Crash Recovery is needed." and the database configuration parameter AUTORESTART is set to off. Which of the following would be required to initiate crash recovery?
A.CONNECT TO
B.RESTART database
C.RECOVER database
D.RESTORE database
Correct:B
12.Given an application with the embedded static SQL statement: INSERT INTO admin.payroll (employee, salary) VALUES ("Joe Smith",30000) Which two of the following privileges are required to successfully bind the application?
A.ALTER
B.INSERT
C.UPDATE
D.BINDADD
E.EXECUTE
Correct:B D
13.Given the following tables:

A.Foreign key on table CANDIDATE
B.Primary key on table CANDIDATE
C.Foreign key on table TEST_TAKEN
D.Primary key on table TEST_TAKEN
Correct:B
14.Given the following statement: CREATE TABLESPACE dms1 MANAGED BY DATABASE USING (FILE 'dms01' 1024K) How many pages will be created for the table space?
A.128
B.256
C.512
D.1024
Correct:B
15.Instances that are down are reported in the Health Center as which of the following alert states?
A.Alarm
B.Normal
C.Warning
D.Attention
Correct:D
16.Which of the following is supported when LOGRETAIN is OFF and USEREXIT is OFF?
A.Log archiving
B.Crash recovery
C.Rollforward recovery
D.Infinite active logging
Correct:B
17.A DBA has created three related backup tasks in the Task Center. After all three of these tasks are completed, a fourth task must be run. Which of the following describes how the DBA can automate the running of the fourth task based on the results of the first three tasks?
A.Indicate on the schedule for the fourth task that it is to begin when the first three tasks are completed.
B.Set a notification on the first three tasks that sends a note to the DBA indicating that the fourth task can be initiated.
C.Create a grouping task for the three backup tasks. Create a task action for the fourth task to be run on the completion of the group.
D.When creating the fourth task, indicate on the Success Code Set field that the first three tasks must run successfully before running this one.
Correct:C
18.To examine the exhibit, press the exhibit button. Given the following statement: SELECT id, deptname, manager FROM staff, org WHERE dept=deptnumb ORDER BY deptname Which operator in the Visual Explain is performing the ORDER BY?
A.SORT(5)
B.SORT(11)
C.SORT(19)
D.FILTER(15)
Correct:A
19.Given the following command:

A.0
B.1
C.2
D.3
E.4
Correct:B
20.Given the following piece of a LIST APPLICATIONS output: Auth Id ApplicationApplApplication Id DB # of Name Handle Name Agents ----------------------------------------------------------------------------------- --------- CERTPAYROLL.EXE7*LOCAL.DB2.991004124355 STAFF 1 Which of the following commands will terminate the client application's connection?
A.KILL APPLICATION (7)
B.FORCE APPLICATION (7)
C.DISCONNECT APPLICATION (7)
D.KILL APPLICATION payroll.exe
E.FORCE APPLICATION payroll.exe
F.DISCONNECT APPLICATION payroll.exe
Correct:B
21.To examine the exhibit, press the exhibit button. Which of the following is illustrated by the explain plan in the exhibit?
A.Recursive SQL
B.Sorts due to grouping
C.Query with a UNION ALL
D.Intra-partition parallelism
Correct:D
22.Which two of the following identify which users have SYSCTRL authority?
A.The node directory
B.The system catalog
C.The database configuration
D.The operating system security
E.The database manager configuration
Correct:D E
23.A backup image of the MYDB database exists in the directory. The following restore command was run: RESTORE DATABASE mydb FROM INTO sample NEWLOGPATH REPLACE EXISTING Which two of the following reflect the state of the SAMPLE database after the restore?
A.The database manager configuration file is over-written.
B.The system catalog tables for the database are replaced.
C.The LOGPATH database configuration parameter is retained.
D.The database configuration file for SAMPLE is over-written.
E.The authentication type for the database is reset to the default.
Correct:B D
24.Which of the following can the DB2 Design Advisor recommend?
A.Indexes for provided workload
B.Buffer pool assignments for table spaces
C.Optimal values for database memory configuration
D.Referential integrity constraints for selected tables
Correct:A
25.Which of the following System Catalog Table columns can be examined to see if a foreign key has been validated after a load?
A.SYSCAT.TABLES.CONST_VALID
B.SYSCAT.TABLES.FOREIGN_KEY
C.SYSCAT.TABLES.KEYS_CHECKED
D.SYSCAT.TABLES.CONST_CHECKED
Correct:D
26.In order to resume a failed load operation without reloading the entire input file, which of the following options should be specified during the initial LOAD?
A.ROWCOUNT
B.SAVECOUNT
C.CHECKPOINT
D.WARNINGCOUNT
Correct:B
27.Which of the following is required to allow a DB2 client to connect to a DB2 server using TCP/IP?
A.A named pipe is established between client and server.
B.The server must be on a UNIX operating system.
C.The registry variable DB2COMM on the server includes TCPIP.
D.The registry variable DB2COMM on the client includes TCPIP.
Correct:C
28.Given the following scenario using the Command Line Processor (CLP): The size of buffer pool BP1 is currently 25000 pages user1 issues: CONNECT TO db1 user2 issues: CONNECT TO db1 user1 issues: ALTER BUFFERPOOL bp1 SIZE 10000 user1 issues: CONNECT RESET user1 issues: CONNECT TO db1 When does the new size of the BP1 buffer pool become effective?
A.When database DB1 is backed up
B.When the database is re-activated
C.When database DB1 is restored
D.When USER1 issued the ALTER BUFFERPOOL statement
Correct:D
29.Given the following statement: IMPORT FROM datafile.ixf OF IXF REPLACE_CREATE INTO table1 Which of the following describes how table and index definitions are affected if data is imported into an existing table?
A.Index definitions are changed
B.Table definitions are changed
C.Table and index definitions are created
D.Table and index definitions are not changed
Correct:D
30.To allow incoming connections via TCP/IP to an instance, which of the following must be set on the server?
A.The node directory should have an entry for the instance.
B.The value of the DB2COMM registry variable for the instance should include TCPIP.
C.The value of the AUTHENTICATION parameter for the instance should be set to SERVER.
D.The value of the SVCENAME parameter for the instance should be set to the TCP/IP host name of this machine.
Correct:B