Testking ibm 000-706

db2 v8.1 for linux,unix and windows db admin upgrade : 000-706 Exam
Test Information:
• Number of questions: 30
• Time allowed in minutes: 40
• Required passing score: 55%

Related certifications:
• IBM Certified Database Administrator — DB2 Universal Database V8.1 for Linux UNIX and Windows
• IBM Certified Advanced Database Administrator – DB2 9 for Linux UNIX and Windows
• IBM Certified Application Developer – DB2 9

Exam Topics Include:
• DB2 Server Management
• Data Placement
• Database Access
• Monitoring DB2 Activity
• DB2 Utilities
• Backup and Recovery

1.The following command is issued: LOAD FROM staff.ixf OF IXF REPLACE INTO staff What locks
are help during the execution of this load?
A.Share lock on table STAFF B.Exclusive lock on table STAFF
C.Exclusive lock on all table spaces holding components of the STAFF table D.Exclusive lock only on table space holding data component of the STAFF table Correct:B
2.Use the exhibit button to display the exhibit for this question. What is indicated by the output from the Health Monitor in the exhibit?

A.1 warning alert on NTINST, 2 alarm and 1 warning alert on NTDB
B.1 warning alert on NTINST, 1 alarm and 1 warning alert on NTDB
C.1 alarm and 1 warning alert on NTINST, 2 alarm and 1 warning alert on NTDB D.1 alarm and 1 warning alert on NTINST, 1 alarm and 1 warning alert on NTDB Correct:B
3.When using AUTOCONFIGURE and a workload that is of type OLTP, what should be used for the workload_type parameter?
A.dss B.mixed C.simple D.complex Correct:C
4.To determine the state of a table space and the location of all containers for that table space, which of the following commands would be used?
A.LIST TABLESPACES SHOW DETAIL
B.GET SNAPSHOT FOR TABLESPACES ON C.LIST TABLESPACE CONTAINERS FOR
D.GET SNAPSHOT FOR TABLESPACES ON SHOW DETAIL
Correct:B
5.In a system set up for dual logging, to change the location of the second set of logs from c:\logpath2 to d:\seclogpath, which of the following commands should be used?
A.UPDATE DB CFG USING logpath2 d:\seclogpath B.UPDATE DB CFG USING newlogpath d:\seclogpath C.UPDATE DB CFG USING mirrorlogpath d:\seclogpath D.UPDATE DB CFG USING overflowlogpath d:\seclogpath Correct:C
6.Following an ATTACH, to view the current values and the delayed values for database manager configuration, what command should be issued?
A.GET DATABASE MANAGER CONFIGURATION *
B.GET DATABASE MANAGER CONFIGURATION ALL VALUES C.GET DATABASE MANAGER CONFIGURATION SHOW DETAIL
D.GET DATABASE MANAGER CONFIGURATION DELAYED VALUES
Correct:C
7.Which of the following Command Line Processer (CLP) commands will display and make changes to the database manager congfiguration?
A.AUTOCONFIGURE APPLY DBM B.AUTOCONFIGURE CHANGE DBM ONLY C.AUTOCONFIGURE APPLY DB AND DBM D.AUTOCONFIGURE CHANGE DB AND DBM Correct:C
8.USER1 needs to start and stop the DAS on the AIX server. Which ok the following is the minimum authority level that will enable USER1 to be able to do this?
A.USER1 must be in the DASADM_GROUP

B.USER1 must be in the SYSADM_GROUP
C.USER1 must be in the SYSCTRL_GROUP D.USER1 must be in the SYSMAINT_GROUP Correct:A
9.A table space delta backup contains which of the following?
A.A copy of all table space data that has changed since the last successful backupl of the table space
B.A copy of all table space data that has changed since the most recent, successful, full backup operation
C.A list of all the table spaces that have been added to the database since the most recent, successful, full backup operation
D.A formatted list of all the database operations that have occurred against the table space since the most recent, successful, full backup operation
Correct:A
10.The following command is issued: REORG INDEXES ALL FOR TABLE staff Which of the following identifies the concurrent access allowed during the running of this REORG command? A.The table STAFF is not accessible
B.The table STAFF is accessible, but its indexes cannot be used.
C.The table STAFF and all of its indexes are available for read only access.
D.The table STAFF and all of its indexes are accessible for read or write access.
Correct:A
11.Which of the following combinations of constraint attributes causes the constraint to be used
by the SQL compiler, but could allow for data that does not meet the constraint to be inserted into the table?
A.CREATE TABLE … CONSTRAINT CHECK () ENFORCED ENABLE QUERY OPTIMZATION B.CREATE TABLE … CONSTRAINT CHECK () ENFORCED DISABLE QUERY OPTIMIZATION C.CREATE TABLE … CONSTRAINT CHECK () NOT ENFORCED ENABLE QUERY OPTIMIZATION D.CREATE TABLE … CONSTRAINT CHECK () NOT ENFORCED DISABLE QUERY OPTIMIZATION Correct:C
12.If type­1 indexes exist on table ADMIN.EMP, which of the following will change them to type­2
indexes?
A.RUNSTATS ON TABLE admin.emp AND INDEXES ALL B.REORG INDEXES ALL FOR TABLE admin.emp CONVERT
C.REORG INDEXES ALL FOR TABLE admin.emp CLEANUP ONLY ALL D.REORG INDEXES ALL FOR TABLE admin.emp CLENAUP ONLY PAGES Correct:B
13.Given the following command and output: LOAD QUERY TABLE staff ……. Tablestate: Load in Progress Read Access Only Which of the following LOAD commands is currently executing? A.LOAD FROM staff.ixf OF IXF INSERT INTO staff
B.LOAD FROM staff.ixf OF IXF REPLACE INTO staff
C.LOAD FROM staff.ixf OF IXF REPLACE INTO staff ALLOW READ ACCESS
D.LOAD FROM staff.ixf OF IXF INSERT INTO staff ALLOW READ ACCESS USE tempspace1
Correct:D
14.Given that there are two containers in table space TS1 and following statement: ALTER TABLESPACE ts1 REDUCE (ALL 100 M) Which of the following describes the result of the

statement?
A.The total size of table space TS1 will be reduced to 100 MB.
B.Each container in table space TS1 will be reduced in size by 100 MB. C.Each container in table space TS1 will be reduced in size to 100 MB.
D.Each container in table space TS1 that has no data will be reduced in size to 100 MB. E.Each container in table space TS1 that has no data will be reduced in size by 100 MB. Correct:B
15.A Database Administrator (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
16.Which of the following can collect statistics about tables or indexes?
A.INSPECT B.ANALYZE C.RUNSTATS D.ALTER TABLE E.CREATE INDEX Correct:C E
17.An application is connected to the SAMPLE database. To determine the coordinator process or thread id for the application, which of the following can be used?
A.LIST APPLICATIONS SHOW DETAIL
B.GET SNAPSHOT FOR DATABASE ON sample
C.LIST APPLICATIONS FOR DATABASE sample
D.SELECT* FROM TABLE (SNAPSHOT_DBM(­1)) AS dbm_snap
E.SELECT* FROM TABLE (SNAPSHOT_APPL_INFO(‘SAMPLE’,­1)) AS appl_snap
Correct:A E
18.The following command is issued: REORG TABLE userid.staff INPLACE NOTRUNCATE TABLE Which of the following identifies the concurrent access allowed during the running of this REORG command?
A.The table STAFF is not accessible
B.The table STAFF is accessible, but its indexes cannot be used.
C.The table STAFF and all of its indexes are accessible for read only access. D.The table STAFF and of its indexes are accessible for read or write access. Correct:D
19.Which of the following creates event monitor data that can be parsed using SQL?

A.CREATE EVENT MONITOR dlmon FOR STATEMENTS WRITE TO TABLE
B.CREATE EVENT MONITOR dlmon FOR STATEMENTS WRITE TO FILE ‘/file1′ C.CREATE EVENT MONITOR dlmon FOR STATEMENTS WRITE TO PIPE ‘/file1′
D.CREATE EVENT MONITOR dllmon FOR STATEMENTS WRITE TO FILE ‘/file1′ BUFFERSIZE 16
Correct:A
20.What must happen before issuing the following command? DB2 GET DATABASE MANAGER CONFIGURATION SHOW DETALL
A.The user must quiesce the instance B.The user must have syaadm authority C.The user must attach to the instance D.The user must have sysmaint authority Correct:C
21.To only capture messages in the administration notification log for fatal errors and events requiring immediate action, set the database manager configuration parameter NOTIFYLEVEL to : A.0
B.1
C.2
D.3
E.4
Correct:C
22.In order to perform maintenance, the DBA has issued a command that ensures that users without administrative authority are prevented from accessing the SALES database. Which of the following actions would allow all users to access the database again?
A.restart the database B.activate the database C.unquiesce the database D.run the inspect command E.stop and start the instance Correct:C E
23.There in not enough reserved space for the following command: ALTER BUFFERPOOL
ibmdefaultbp IMMEDIATE SIZE 2400 What happens to the buffer pool?
A.An error is returned and the buffer pool is not altered.
B.The changes will take effect on the next database startup.
C.The buffer pool is increased in size until the reserved space is exhausted.
D.A warning is returned and the buffer pool size increases immediately as memory becomes availabe.
Correct:B
24.The following command is issued: INSPECT CHECK DATABASE RESULTS KEEP db.inspect
How can the results of the inspection be viewed?
A.View the db.inspect file with an operating system editor
B.lssue a select using the SNAPSHOT_INSPECT SQL table function
C.Filter the Notification Log results in the Journal to view only INSPECT results
D.Format the db.inspect results to a file using the db2inspf utility, view the output file with an operating system editor

Correct:D
25.Where can Health Monitor alerts be viewed?
A.Task Center B.Health Center C.Visual Explain D.Notification Log Correct:B D
26.With infinite active log space enable, what can an active unit of work span?
A.primary logs
B.primary an archive logs
C.primary and secondary logs D.primary, secondary and archive logs Correct:B
27.A database stored on a mirrored file system has been split and the table spaces are currently in the state SUSPEND_WRITE. What command should be issued to bring the state of the table spaces back to normal?
A.ACTIVATE DB B.UNQUIESCE DB
C.SET WRITE RESUME FOR DB D.db2set SUSPEND_WRITE OFF Correct:C
28.Given the following information Server time is Atlantic Time (CUT­4) Client time is Central
European Time (CUT+1) From the client you must perform a rollforward of the SAMPLE database
on the server to 2002­12­24­14.21.56.245378 Atlantic Time using CLP. Which command is correct?
A.ROLLFORWARD DB sample TO 2002­12­24­14.21.56.245378 AND STOP B.ROLLFORWARD DB sample TO 2002­12­24­09.21.56.245378 AND STOP
C.ROLLFORWARD DB sample TO 2002­12­24­19.21.56.245378 USING LOCAL TIME AND STOP D.ROLLFORWARD DB sample TO 2002­12­24­14.21.56.245378 USING LOCAL TIME AND STOP Correct:D
29.Online table reorganization is done using the “inplace” parameter with the reorg command. For
an indexed table, which of the following is a prerequisite for online table reorganization?
A.All indexes must be type­2
B.All indexes must be type­1
C.All indexes must be extended
D.The table must be in a table space by itself
Correct:A
30.Which of the following can be done to a buffer pool using the ALTER BUFFERPOOL statement?
A.Modify the page size
B.Modify the extent size
C.Modify the prefetch size
D.Modify the buffer pool size
Correct:D

Testking ibm 000-706 Interactive Testing Engine Included!
167 Questions
Updated : 09/18/2008
Price : $87.99 $79.99

Free down:Testking ibm 000-706
Free down:Pass4sure ibm 000-706

Type	Exam Bible	New Questions & Answers	Latest Updated	Download link
	All Ibm 's Exam Pack	767	1 days ago	Download

Random Posts

• Testking ibm 000-731
• Actualtests ibm 000-731
• pass4sure ibm DB2: DB2
• passguide 000-938
• pass4sure ibm Certified Enterprise Developer: Certified Enterprise Developer
• Testking ibm 000-255
• 000-r14
• Actualtests ibm 000-743
• 000-314
• 000-041
• 000-866
• passguide 000-316
• pass4sure ibm 000-222
• passguide 000-020
• 000-315