Discussion
Home ‣ Certification ‣ IBM Certification Comments
- Question
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
- Correct Answer
- in the system catalog tables
- 1. 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
- 2. 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
- 3. 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
- 4. A VM/VSE customer wants to implement a WAS on an existing zSeries server. On which of the following operating environments would WAS best be implemented?
Options- A. VSE
- B. z/VM
- C. z/OS
- D. Linux Discuss
- 5. What is a requirement to connect a V6R1 IBM i host to an XIV Storage System?
Options- A. XIV firmware V10.0.8
- B. Host Attachment Kit V1.0.1
- C. SAN Volume Controller (SVC)V4.2
- D. Virtual I/O Server (VIOS) V2.1.1 Discuss
- 6. 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
- 7. 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
- 8. Which isolation level does a database without logging default to?
Options- A. committed read
- B. dirty read
- C. mode ANSI
- D. repeatable read Discuss
- 9. 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
- 10. 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
IBM Certification problems
Search Results
Correct Answer: Telnet to the virtual console.
Correct Answer: Replication Center
Correct Answer: on disks in other modules
Correct Answer: Linux
Correct Answer: Virtual I/O Server (VIOS) V2.1.1
Correct Answer: a contiguous unit of disk space
Correct Answer: Visual Explain
Correct Answer: dirty read
Correct Answer: repeatable read
Correct Answer: Equijion predicates
Comments
There are no comments.Programming
Copyright ©CuriousTab. All rights reserved.