Below we have listed all the IBM Certification Exams Interview Questions and answers. Feel free to comment on any IBM Certification Exams Interview Questions or answer by the comment feature available on the page.
To buy an eBook containing 30,000 Interview Questions, with Answers, Click Here.
View All IBM Certification Exams Interview Questions & Answers - Exam Mode / Learning Mode
IBM Business Analytics Certification provides an industry standard benchmark for technical competence, and offers validation for professionals who work with IBM Business Analytics technologies. IBM Business Analytics Certification offers the only authorized accreditation in the industry for benchmarking and validating your expertise with Cognos or SPSS products.
Subcategories for IBM Certification Exams Interview Questions & Answers :-
Following are sub categories for which Interview Questions & Answers are available under IBM Certification Exams Interview Questions & Answers. Please select the appropriate sub-category:-
|When using the SAN Volume Controller (SVC) as a host for a full 15 module XIV Storage System, how many ports are recommended to be connected to the SVC?
|Using the XCLI, which qualifiers are required to create a thin provisioned pool?
A. pool, hard size, soft size, snapshot size
B. pool, hard size, soft size, read block behavior
C. pool, resize allowed, maximum volumes, maximum snapshots
D. pool, read block behavior, maximum volumes, maximum snapshots
|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?
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.
|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?
|Given the following statements from two embedded SQL programs: Program 1: CREATE TABLE mytab (col1 INT, col2 CHAR(24)) COMMIT Program 2: INSERT INTO mytab VALUES( 20989,�Joe Smith�) COMMIT INSERT INTO mytab VALUES( 21334,�Amy Johnson�) DELETE FROM mytab COMMIT INSERT INTO mytab VALUES( 23430,�Jason French�) ROLLBACK INSERT INTO mytab VALUES( 20993,�Samantha Jones�) COMMIT DELETE FROM mytab WHERE col1=20993
ROLLBACK Assuming Program 1 ran to completion and then Program 2 ran to completion, which
of the following records would be returned by the statement: SELECT * FROM mytab?
A.20989, Joe Smith
B.21334, Amy Johnson
C.23430, Jason French
D.20993, Samantha Jones
E.No records are returned.
|A z10 customer has numerous Unix servers, a large number of Windows servers, and an unidentified number of small department servers that were acquired outside of IT influence. The CIO wants to know how much they are currently spending on IT company wide and determine if software licenses are managed correctly.
Which of the following approaches would provide that information?
A. Perform a TCO analysis
B. An internal review, department by department
C. Review of IT department expense items
D. Interview all department heads
|Given the following two tables: TAB1 TAB2 C1 C2 CX CY ?????? ????? ????? ?????? A 11 A 21 B 12 C 22 C
13 D 23 The following results are desired: C1 C2 CX CY ?????? ????? ????? ?????? A 11 A 21 B 12 ? ? C 13 C
22 Which of the following joins will yield the desired results?
A.SELECT * FROM tab1 INNER JOIN tab2 ON c1=cx B.SELECT * FROM tab2 LEFT OUTER JOIN tab1 ON c1=cx
C.SELECT * FROM tab2 FULL OUTER JOIN tab1 ON c1=cx
D.SELECT * FROM tab1 LEFT OUTER JOIN tab2 ON c1=cx
|Where are table spaces (tblspaces) created?
A. in dbspaces
B. in pages
C. in extents
D. in chunks
|A Linux partition running in a non-hosted environment has only a QIC50GB tape drive. They need
to send a tape of data to a vendor in LTO format to be loaded onto a UNIX system, but the only LTD drive they have is attached to an i5/OS partition. Which of the following will accomplish this goal?
A Create an LTD format tape on the QIC50GC drive and have this tape duped onto a LTO
B Save the data to disk, FTP it to the iSeries, and use the SAV command to save it to the LTO
C In the i5/OS partition, change the LTO tape drive device description to shared by changing the Device Model to *VRT.
D Create a NWSD in the i5/OS partition to control the Linux partition. Shut down the Linux partition, vary on the NWSD, and vary off the tape drive.
|Given that the following statements were executed in order: CREATE TABLE tab1 (c1 CHAR(1))
INSERT INTO tab1 VALUES (�b�) CREATE VIEW view1 AS SELECT c1 FROM tab1 WHERE c1 =�a�
INSERT INTO view1 VALUES (�a�) INSERT INTO view1 VALUES (�b�) How many rows would be returned from the following statement? SELECT c1 FROM tab1
|Given the following SQL statements: CREATE TABLE birthday1 (day INT CHECK(day BETWEEN 1 AND 31), month INT CHECK(month BETWEEN 1 AND 6), year INT) CREATE TABLE birthday2 (day INT CHECK(day BETWEEN 1 AND 31), month INT CHECK(month BETWEEN 7 AND
12), year INT) CREATE VIEW birthdays AS SELECT * FROM birthday1 UNION ALL SELECT * FROM
birthday2 INSERT INTO birthday1 VALUES( 22,10, 1973) INSERT INTO birthday1 VALUES( 40, 8,
1980) INSERT INTO birthday1 VALUES( 8, 3, 1990) INSERT INTO birthday1 VALUES( 22, 10, 1973) INSERT INTO birthday1 VALUES( 3, 3, 1960) What will be the result of the following SELECT statement? SELECT COUNT(*) FROM birthdays
|Certkiller .com has a fully utilized i810 Enterprise Edition. They like their applications and now need to add e-mail and collaboration capabilities for their remote offices. Which of the following will meet the customer�s needs?
A. Uprgrade the i810 to an IBM eServer i5 570 Value Edition and add Lotus Domino.
B. Upgrade the i810 to an IBM eServer i5 520 Enterprise Edition and add Lotus Domino.
C. Upgrade the i810 to an IBM eServer i5 520 Value Edition and add Lotus Notes and
D. Upgrade the i810 to an IBM eServer i5 520 Standard Edition and add Lotus Domino and Instant Messaging.
|The manager of the IT department indicates that their company is pursuing a website expansion because of growing e-business sales. Which of the following people will be able to provide the necessary information to perform ROI analysis for this project?
B. Office manager
C. Marketing manager
D. Purchasing manager
|Which two of the following SQL data types should be used to store a small binary image?
E.VARCHAR FOR BIT DATA
|An iSeries installation is using Linux as a firewall between the public Internet and an OS/400
WebSphere server, and as a DMZ between the WebSphere server and the production OS/400
partitions. Which of the following ports and protocols should be allowed through the DMZ so
WebSphere can access the production data with JDBC?
A TOP port 8471
B UDP ports below 1024
C TOP ports between 63900 and 64500
D UDP port 8471 and TCP ports 6390 to 6450
|Table T1 has a column C1 char(3) that contains strings in upper and lower case letters. Which
of the following queries will find all rows where C1 is the string �ABC� in any case?
A.SELECT * FROM t1 WHERE c1 = �ABC�
B.SELECT * FROM t1 WHERE UCASE(c1) = �ABC�
C.SELECT * FROM t1 WHERE IGNORE_CASE(c1 = �ABC�)
D.SELECT * FROM t1 WHERE c1 = �ABC� WITH OPTION CASE INSENSITIVE
|Which of the following describes an advantage that Linux on iSeries brings to an enterprise?
A Runs all Linux binaries unchanged
B Server consolidation with support for dynamic resource allocation
C Support for high capacity tape drives not otherwise available to Linux
D Provides dedicated, RAID-5 protected, disk drives from OS/400 controlled disk lOAs
|Which fragments an index by expression?
A. FRAGMENT BY EXPRESSION col_1
B. FRAGMENT BY EXPRESSION col_2>=10000IN dbspace 1 AND col_2>10000IN dbspace2
C. FRAGMMENT BY EXPRESSION col_1<10000 AND col_2 IN dbspace 2
D. FRAGMENT BY EXPRESSION col <20000 IN dbspace 1, col> = 20000 IN dbspace 2
|An iSeries administrator is planning a disaster recovery restore. What is the correct restore sequence to assure that the Linux partition will start?
A After completing Restore menu option 21, restore the NWSD followed by the storage spaces.
B Restore the system with Restore menu option 21.
C Restore the storage spaces followed by the Linux NWSD.
D After completing Restore menu option 21, re-create the NWSD from a RTVCFGSRC member.
|Given the SQL statement: ALTER TABLE table1 ADD col2 INT WITH DEFAULT Which of the following is the result of the statement?
A.The statement fails because no default value is specified.
B.A new column called COL2 is added to TABLE1 which would have a null value if selected.
C.A new column called COL2 is added to TABLE1 which would have a value of zero if selected.
D.A new column called COL2 is added to TABLE1 which would require the default value to be set before working with the table.
India News Network
Latest 20 Questions
Payment of time- barred debt is:
Consideration is defined in the Indian Contract Act,1872 in: (a) Section 2(f) (b) Section 2(e) (c) Section 2(g) (d) Section 2(d)
Which of the following is not an exception to the rule, "No consideration, No contract": (a) Natural love and affection (b) Compensation for involuntary services (c) Completed gift (d) Agency
Consideration must move at the desire of: (a) The promisor (b) The promisee (c) The promisor or any other party (d) Both the promisor and the promisee
An offer which is open for acceptance over a period of time is: (a) Cross Offer (b) Counter Offer (c) Standing Offer (d) Implied Offer
Specific offer can be communicated to__________ (a) All the parties of contract (b) General public in universe (c) Specific person (d) None of the above
_________ amounts to rejection of the original offer. (a) Cross offer (b) Special offer (c) Standing offer (d) Counter offer
A advertises to sell his old car by advertising in a newspaper. This offer is caleed: (a) General Offer (b) Special Offer (c) Continuing Offer (d) None of the above
In case a counter offer is made, the original offer stands: (a) Rejected (b) Accepted automatically (c) Accepted subject to certain modifications and variations (d) None of the above
In case of unenforceable contract having some technical defect, parties (a) Can sue upon it (b) Cannot sue upon it (c) Should consider it to be illegal (d) None of the above
If entire specified goods is perished before entering into contract of sale, the contract is (a) Valid (b) Void (c) Voidable (d) Cancelled
______________ contracts are also caled contracts with executed consideration. (a) Unilateral (b) Completed (c) Bilateral (d) Executory
A offers B to supply books @ Rs 100 each but B accepts the same with condition of 10% discount. This is a case of (a) Counter Offer (b) Cross Offer (c) Specific Offer (d) General Offer
_____________ is a game of chance. (a) Conditional Contract (b) Contingent Contract (c) Wagering Contract (d) Quasi Contract
There is no binding contract in case of _______ as one's offer cannot be constructed as acceptance (a) Cross Offer (b) Standing Offer (c) Counter Offer (d) Special Offer
An offer is made with an intention to have negotiation from other party. This type of offer is: (a) Invitation to offer (b) Valid offer (c) Voidable (d) None of the above
When an offer is made to the world at large, it is ____________ offer. (a) Counter (b) Special (c) General (d) None of the above
Implied contract even if not in writing or express words is perfectly _______________ if all the conditions are satisfied:- (a) Void (b) Voidable (c) Valid (d) Illegal
A specific offer can be accepted by ___________. (a) Any person (b) Any friend to offeror (c) The person to whom it is made (d) Any friend of offeree
An agreement toput a fire on a person's car is a ______: (a) Legal (b) Voidable (c) Valid (d) Illegal