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 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.
|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.
|What is the minimum privilege required to allow USER1 to access table data?
A.READ privilege on the table
B.SELECT privilege on the table
C.REFERENCES privilege on the table
D.SELECT privilege WITH GRANT OPTION on the table
|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
|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.
|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
|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
|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
|An iSeries administrator sets: ? *PUBLIC authority *USE on all program libraries. ? *PUBLIC Object Operational authority and *EXECUTE data authority on programs. Which of the following authorities would implement comparable restrictions in a Linux on iSeries implementation?
A Public directory access authority to r-x and public authority x on the program files
B Public directory access authority to r-x and public authority r-x on the program files
C Public directory access authority to x and public authority x on the program files
D Public directory access authority to r-x and public authority r on the program files
|Given a user defined function, U.UDF1, that takes an input parameter of type INTEGER, and
USER6 running the following SQL statement: SELECT w.udf1(col6) FROM t.tab1 WHERE col4 =
�ABC� Which of the following statement(s) would allow USER6 to execute the statement?
A.GRANT ALL PRIVILEGES ON TABLE t.tab1 TO user6
B.GRANT SELECT ON TABLE t.tab1 TO user6 GRANT USE ON FUNCTION u.udf1(INT) TO user6
C.GRANT SELECT ON TABLE t.tab1 TO user6 GRANT REFERENCES ON FUNCTION u.udf1(INT) TO
D.GRANT ALL PRIVILEGES ON TABLE t.tab1 TO user6 GRANT EXECUTE ON FUNCTION u.udf1(INT) TO user6
|Certkiller .com with an i810 is running multiple partitions with V5R3. Which of the following products is used to manage the partitions?
A. IBM Director
B. iSeries Navigator
C. Management Central
D. Hardware Management Console
|A Linux on iSeries administrator is setting up the OS/400 programmers with user IDs in the Linux partition. Which of the following describes how to set up these profiles in Linux?
A � Change the QRETSVRSEC system value to 2 to enable user security mirroring.
B � Set up the Linux NES autoloader with the OS/400 partition as the central server.
C � Use the CHGNWSUSRA on the Linux NWSD to enable Linux user profile management from
D � Create a Linux group profile and individual user profiles for each of the programmers referencing the group profile.
|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
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