IBM Certification problems
- 1. 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
Correct Answer: Replication Center
- 2. 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
Correct Answer: Telnet to the virtual console.
- 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
Correct Answer: in the system catalog tables
- 4. 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
Correct Answer: a contiguous unit of disk space
- 5. 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
Correct Answer: Visual Explain
- 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
Correct Answer: dirty read
- 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
Correct Answer: repeatable read
- 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
Correct Answer: Equijion predicates
Programming
Copyright ©CuriousTab. All rights reserved.