Free Cheat-test Samples and Demo Questions Download
Adobe exams Adobe
Apple exams Apple
Avaya exams Avaya
Check Point exams Check Point
Cisco exams Cisco
Citrix exams Citrix
CIW exams CIW
CompTIA exams CompTIA
CWNP exams CWNP
EC-Council exams EC-Council
EMC exams EMC
Exin exams Exin
Fortinet exams Fortinet
GIAC exams GIAC
Hitachi exams Hitachi
HP exams HP
IBM exams IBM
Isaca exams Isaca
ISC exams ISC
ISEB exams ISEB
Juniper exams Juniper
LPI exams LPI
McAfee exams McAfee
Microsoft exams Microsoft
Oracle exams Oracle
PMI exams PMI
Riverbed exams Riverbed
SNIA exams SAP
Sun exams SAS
Symantec exams Symantec
VMware exams VMware
All certification exams

IBM 000-706 Exam - Cheat-Test.com

Free 000-706 Sample Questions:

1.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
Answer: D

2.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.
Answer: C

3.Where can Health Monitor alerts be viewed?
A:Task Center
B:Health Center
C:Visual Explain
D:Notification Log
Answer: B, D

4.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.
Answer: D

5.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
Answer: C, E

6.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
Answer: C

7.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 <constraint name>
CHECK (<check condition>) ENFORCED ENABLE QUERY OPTIMZATION
B: CREATE TABLE ... CONSTRAINT <constraint name>
CHECK (<check condition>) ENFORCED DISABLE QUERY OPTIMIZATION
C: CREATE TABLE ... CONSTRAINT <constraint name>
CHECK (<check condition>) NOT ENFORCED ENABLE QUERY OPTIMIZATION
D: CREATE TABLE ... CONSTRAINT <constraint name>
CHECK (<check condition>) NOT ENFORCED DISABLE QUERY OPTIMIZATION
Answer: C

8.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
Answer: C

9.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.
Answer: A


© 2014 Cheat-Test.com, All Rights Reserved