Discussion
Home ‣ Certification ‣ IBM Certification Comments
- Question
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
- Correct Answer
- Visual Explain
- 1. 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
- 2. 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
- 3. 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
- 4. 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
- 5. How To improve system redundancy using its grid architecture, where in the XIV System can a partition be mirrored?
Options- A. on same disk in different modules
- B. on disks in other modules
- C. on different disks in the same module
- D. on same disk, in same module, and in different modules Discuss
- 6. Which isolation level does a database without logging default to?
Options- A. committed read
- B. dirty read
- C. mode ANSI
- D. repeatable read Discuss
- 7. 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
- 8. 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
- 9. 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
- 10. 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
IBM Certification problems
Search Results
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: on disks in other modules
Correct Answer: dirty read
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.
Comments
There are no comments.Programming
Copyright ©CuriousTab. All rights reserved.