Discussion
Home ‣ Certification ‣ IBM Certification Comments
- Question
Which isolation level does a database without logging default to?
Options- A. committed read
- B. dirty read
- C. mode ANSI
- D. repeatable read
- Correct Answer
- dirty read
- 1. Which of the following tools can be used to identify inefficient SQL statements without executing them?
Options- A. QMF
- B. Task Center
- C. Visual Explain
- D. Development Center Discuss
- 2. What is a chunk when using raw devices?
Options- A. a dynamic unit of disk space
- B. a location in shared memory
- C. a contiguous unit of disk space
- D. a data table Discuss
- 3. Where is fragment information stored?
Options- A. in the physical logs
- B. in the reserved pages
- C. in the system catalog tables
- D. in the first page of the database tblspace Discuss
- 4. Suppose a customer is planning to create a non-hosted Linux partition on an i825. Linux will have only direct-attach devices. What is the Linux console option?
Options- A. Use OS/400 VNC support.
- B. Telnet to the virtual console.
- C. Share the primary partitions console.
- D. Allocate a console IOA to the Linux partition. Discuss
- 5. Which of the following tools is used to create subscription sets and add subscription?set members to subscription sets?
Options- A. Journal
- B. License Center
- C. Replication Center
- D. Development Center Discuss
- 6. If there is a lock on an adjacent key, an insert will fail if the isolation level is set to what?
Options- A. committed read
- B. repeatable read
- C. share read
- D. indexed read Discuss
- 7. Which of the following is required for the DB2 optimizer to consider a hash join strategy?
Options- A. Optimization level 1 or above
- B. Equijion predicates
- C. Registry variable DB_ANTIJOIN=YES
- D. SORTHEAP large enough to contain the tables being joined Discuss
- 8. What does Mean Time to Repair (MTTR) mean?
Options- A. Average uptime of a service
- B. Average downtime of a service
- C. Average time between two consecutive incidents
- D. Average time of the breakdown-free period within a measured period Discuss
- 9. Which of the following BEST describes a Service Desk?
Options- A. A dedicated number of staff handling Incidents and service requests
- B. A process within Service Operation providing a single point of contact
- C. A dedicated number of staff handling service requests
- D. A dedicated number of staff answering questions from users Discuss
- 10. Which functions are included in IT Operations Management?
Options- A. IT Operations Control and Facilities Management
- B. Network Management and Application Management
- C. Facilities Management and Release Management
- D. Technical Management and Change Management Discuss
IBM Certification problems
Search Results
Correct Answer: Visual Explain
Correct Answer: a contiguous unit of disk space
Correct Answer: in the system catalog tables
Correct Answer: Telnet to the virtual console.
Correct Answer: Replication Center
Correct Answer: repeatable read
Correct Answer: Equijion predicates
Correct Answer: Average downtime of a service
Correct Answer: A dedicated number of staff handling Incidents and service requests
Explanation:
A dedicated number of staff handling Incidents and service requests best describes a Service Desk.
Correct Answer: IT Operations Control and Facilities Management
Explanation:
IT Operations Control and Facilities Management are included in IT Operations Management. Those operations include ::
1. Technical Management
2. IT Operations Control
3. Application Management
4. Facilities Management
5. Standard Operating Procedures (SOP)
6. IT Operations Management
7. Service Desk
8. Operations Log
and more.
Comments
There are no comments.Programming
Copyright ©CuriousTab. All rights reserved.