CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions
Our Services



Advertisements IBM Certification Exams Interview Questions
COOLINTERVIEW.COM CERTIFICATION EXAMS INTERVIEW QUESTIONS IBM CERTIFICATION EXAMS INTERVIEW QUESTIONS QUESTIONS LISTING

IBM Certification Exams Interview Questions & Answers

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.


IBM Certification Exams Interview Questions & Answers

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:-

IBM DB2 DBA Certification Exam Interview Questions & Answers (12)

1 2 3 4 5 Next

Sort By : Latest First | Oldest First | By Rating

Question
Rating
View Answer
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
4.9 Rating
View Answer
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
4.5 Rating
View Answer
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
drive.
B Save the data to disk, FTP it to the iSeries, and use the SAV command to save it to the LTO
drive.
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.
4.3 Rating
View Answer
A customer created a hosted Linux partition on a 4-way i820 with iStar processors. The partition was created to utilize one shared processor unit, 1024MB of memory, and no other hardware. It
railed immediately when IPLed. The SRC code indicated that the partition does not have the
proper resources to IPL. What must be done to IPL this partition?

A Assign a dedicated LAN resource to this partition.
B Assign a dedicated CD/DVD device to this partition.
C Assign a dedicated console resource to this partition.
D Assign a dedicated processor to this partition.
4.8 Rating
View Answer
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.
4.3 Rating
View Answer
Which two solutions, once installed and configured, can be used to move workloads without disruption? (Choose two)

A. XIV partitions
B. XIV Data Mover (XDM)
C. SAN Volume Controller
D. XIV Data Migration Function
E. Tivoli Storage Productivity Center for Replication V4
4.4 Rating
View Answer
In which two situations would you use a round robin fragmentation strategy?

A. When all fragments must be second
B. To create uneven data distributions
C. When queries perform sequential scans and you have little information about the data being stored.
D. When tables are accessed with a high degree of selectivity
3.8 Rating
View Answer
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
user6
D.GRANT ALL PRIVILEGES ON TABLE t.tab1 TO user6 GRANT EXECUTE ON FUNCTION u.udf1(INT) TO user6
4.2 Rating
View Answer
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

4.4 Rating
View Answer
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
OS/400.
D � Create a Linux group profile and individual user profiles for each of the programmers referencing the group profile.
3.8 Rating
View Answer
A redistribute command fails during processing of database partition group DPG1. Which
of the following commands will return the database partition group to its original partition map?

A. RESTART DATABASE
B. REDISTRIBUTE DATABASE PARTITION GROUP dpg1 RESET
C. REDISTRIBUTE DATABASE PARTITION GROUP dpg1 ROLLBACK
D. REDISTRIBUTE DATABASE PARTITION GROUP dpg1 USING ORIGINAL TARGETMAP.

4.4 Rating
View Answer
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?

A. VSE
B. z/VM
C. z/OS
D. Linux

4.5 Rating
View Answer
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
4.5 Rating
View Answer
Given the following table definition: STAFF id INTEGER name CHAR(20) dept INTEGER job CHAR(20) years INTEGER salary DECIMAL(10,2) comm DECIMAL(10,2) Which of the following SQL statements will return a result set that satisfies these conditions: ?Displays the department ID and total number of employees in each department. ?Includes only departments with at least one employee receiving a commission (comm) greater than 5000. ?Sorted by the department employee count from greatest to least.
A.SELECT dept, COUNT(*) FROM staff GROUP BY dept HAVING comm > 5000 ORDER BY 2 DESC B.SELECT dept, COUNT(*) FROM staff WHERE comm > 5000 GROUP BY dept, comm ORDER BY 2
DESC
C.SELECT dept, COUNT(*) FROM staff GROUP BY dept HAVING MAX(comm) > 5000 ORDER BY 2
DESC
D.SELECT dept, comm, COUNT(id) FROM staff WHERE comm > 5000 GROUP BY dept, comm ORDER BY 3 DESC
4.5 Rating
View Answer
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.
4.5 Rating
View Answer
A client application on OS/390 or OS/400 must access a DB2 server on AIX. At a minimum, which
of the following products is required to provide DRDA Application Server functionality on the DB2
server for AIX?
A.DB2 Connect Enterprise Edition
B.DB2 UDB Workgroup Server Edition
C.DB2 Connect Enterprise Edition and DB2 UDB Workgroup Server Edition
D.DB2 Connect Enterprise Edition and DB2 UDB Enterprise Server Edition
4.5 Rating
View Answer
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
A.0
B.2
C.3
D.5D.5

4.5 Rating
View Answer
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
4.5 Rating
View Answer
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
4.5 Rating
View Answer
Which of the following is defined on the dependent table to implement a referential constraint?
A.Primary key
B.Foreign key
C.Check constraint
D.Update trigger
4.5 Rating
View Answer

1 2 3 4 5 Next




User Options
India News Network

Latest 20 Questions
What are the objectives of CST Act?
What is inter-state sale in case of Sales Tax?
What are the types of Sales Tax?
Where is Central Sales Tax (CST) paid and who collects them?
What is Central Sales Tax (CST)
What is Profession Tax in Andhra Pradesh?
What is Profession Tax in West Bengal?
What is Profession Tax in Karnataka?
What is Profession Tax in Delhi?
What is Profession Tax in Maharashtra?
Who is appellate authority in Maharastra, under Profession Tax Act?
Can parents/Guardians of physically handicapped children get exemption from Profession Tax?
Whether it is necessary to submit medical certificate for exemption from Profession Tax?
Who can get exemption from Profession Tax?
If there is no previous year in the profession then what will be the rate of Profession Tax?
On what basis Profession Tax shall be calculated?
What are the rates of tax under Profession Tax Act?
Who is assessed under Profession Tax Act?
What type of incentives will be available after making such lump sum payment fpr Enrollment Certificate for Professional Tax (PT)?
What are the advantages of making lump sum payment of Professional Tax (PT)?



Fresher Jobs | Experienced Jobs | Government Jobs | Walkin Jobs | Company Profiles | Interview Questions | Placement Papers | Companies In India | Consultants In India | Colleges In India | Exams In India | Latest Results | Notifications In India | Call Centers In India | Training Institutes In India | Job Communities In India | Courses In India | Jobs by Keyskills | Jobs by Functional Areas

Testing Articles | Testing Books | Testing Certifications | Testing FAQs | Testing Downloads | Testing Interview Questions | Testing Jobs | Testing Training Institutes

Gate Articles | Gate Books | Gate Colleges | Gate Downloads | Gate Faqs | Gate Jobs | Gate News | Gate Sample Papers | Gate Training Institutes

MBA Articles | MBA Books | MBA Case Studies | MBA Business Schools | MBA Current Affairs | MBA Downloads | MBA Events | MBA Notifications | MBA FAQs | MBA Jobs
MBA Job Consultants | MBA News | MBA Results | MBA Courses | MBA Sample Papers | MBA Interview Questions | MBA Training Institutes

GRE Articles | GRE Books | GRE Colleges | GRE Downloads | GRE Events | GRE FAQs | GRE News | GRE Training Institutes | GRE Sample Papers

IAS Articles | IAS Books | IAS Current Affairs | IAS Downloads | IAS Events | IAS FAQs | IAS News | IAS Notifications | IAS UPSC Jobs | IAS Previous Question Papers
IAS Results | IAS Sample Papers | IAS Interview Questions | IAS Training Institutes | IAS Toppers Interview

SAP Articles | SAP Books | SAP Certifications | SAP Companies | SAP Study Materials | SAP Events | SAP FAQs | SAP Jobs | SAP Job Consultants
SAP Links | SAP News | SAP Sample Papers | SAP Interview Questions | SAP Training Institutes |




Copyright ©2003-2016 CoolInterview.com, All Rights Reserved.
Privacy Policy | Terms and Conditions



Cache = 0.007812 Seconds