Interview Questions Answers.ORG

Interviewer And Interviewee Guide

Top IBM Certification Interview Questions & Answers:

Download Interview PDF

1. Explain With database logging, where are transaction records first placed?

A. in a temporary database table
B. in the logical log buffer
C. in the primary chunk
D. in the physical buffer

B.in the logical log buffer

2. Suppose an installed z/OS customer also has Power6 Servers. They are investigating consolidation of both types of servers to z/OS.
Which of the following will establish the capacity for a new z/OS server?

A. AD Tools
B. Estimate the AIX load and add to CP3000 results.
C. CP3000
D. Run AIX in a z/OS LPAR to establish the loadWArialTimes New RomanZ

B.Estimate the AIX load and add to CP3000 results.

3. Explain the Given following DDL statement
CREATE TABLE RMW TABEL46″
11″ INTEGER
D11″ DECIMAL (1′0)NOT NULL
D12″ DECIMAL (1′0) NOT NULL
S7″ SMALLINT
C8″ CHAR(1) WITH DEFAULT)
organize by (
(D12″ ;D11″))
How many indexes will be created?

A. 1
B. 2
C. 3
D. 4

C.3

4. Explain Which of the following DB2 data types CANNOT be used to contain the date an employee was hired?
A.CLOB
B.TIME
C.VARCHAR
D.TIMESTAMP

B.TIME

5. When Disk space for a table is allocated in one or more units called what?

A. tblspaces
B. extents
C. blobs
D. chunks

B.extents

6. Suppose an application bound with isolation level Uncommitted Read updates a row. Which of the following is true regarding the locking of this row?
A.No row lock is acquired when the row is updated.
B.The row lock is released when the cursor accessing the row is closed.
C.The row lock is released when the application issues a COMMIT statement.
D.The row lock is released when the cursor accessing the row is moved to the next row.

C.The row lock is released when the application issues a COMMIT statement.

7. The DBA can set the registry variable DB2_HASH_JOIN on or off because:
A. hash joins may require more resources to run.
B. hash joins are not used unless outer joins are requested.
C. If hash joins are enabled, no other join method can be used.
D. Hash joins are only needed when the tables are portioned using hash keys.

A.Hash joins may require more resources to run.

8. Explain When creating a regular DMS table space, what is the minimum number of extents that must be specified?

A. 1
B. 3
C. 4
D. 6
E. 8

D.6

9. Explain Which of the following commands will format a new disk drive partition in Linux on iSeries?

A mkts -e2 <path to device>
B mkfs.ext2 <path to device>
C mkfs -ext2 &It;path to device >
D mkfs format -e2 <path to device>

B.B mkfs.ext2 <path to device>

10. Which of the following extenders allows data to be presented in a three?dimensional format?
A.DB2 AVI Extender
B.DB2 XML Extender
C.DB2 Text Extender
D.DB2 Spatial Extender

D.DB2 Spatial Extender

Download Interview PDF

SHARE

Disclaimer

Interview Questions Answers .ORG is responsive and optimized web portal for individuals to get preparation for their job interviews, learning and training. Content at Interview Questions Answers .ORG might be simplified to improve our users experience. We constantly review our content to avoid errors and copyright violations, but we cannot warrant full correctness of all the content. While using this site, you agree to have read and accepted our terms of use, cookie and privacy policy. Copyright 2007-2023 by Interview Questions Answers .ORG All Rights Reserved.