Latest, Top, Free, Best IBM Certification Exams Interview Questions and Answers - IBM Certification Exams Job Interview FAQs, Queries, Tips, Sample Papers, Exam Papers

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

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. View All IBM Certification Exams Interview Questions & Answers - Exam Mode / Learning Mode
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) Exam Mode | Learning Mode

Previous 1 2 3 4 5 Next

Sort By : Latest First | Oldest First | By Rating

Question	Rating	View Answer
Given that the SQL statement SET LOCK MODE TO WAIT has not been executed, if a statement attempts to alter a row that another process has locked, what happens? A. The lock is released B. An error is returned C. The row is immediately updated. D. The row is updated after the lock is removed.		View Answer
An iSeries customer has a hosted Linux partition installed with a file system size of 6GB. At some later date, the drive is getting full. How can they correct the problem in the least disruptive manner? A Create a new partition and reinstall Linux, then restore the data to the new larger partition. B Create another storage space, link it to the NWSD, then use the Linux Disk Management interface to add it as a spanoed volume C Create a new, larger Network Server Storage Space, attach it to the Linux partition, and use Linux to copy the data from the original Network Server Storage Space. D Create a new Network Server Storage Space, link it to the NWSD, and use the Linux Disk Management interface to mount the new disk on the original directory.		View Answer
Question: 8 What help ensure that the XIV System's cache does not become a bottleneck? A. central cache locking mechanism B. use of industry standard chip technology C. each module is responsible for caching the data in that module D. having all modules understand what is held cache at all times Answer: C		View Answer
Which of the following can be kept in memory when the DB2 configuration parameter KEEPFENCED is enabled? A. SQLDAS after their cursor is closed. B. Referential integrity maps after a join. C. Stored procedure processes after they are run. D. Tables after they have been read into the buffer pool.		View Answer
A table is defined using DMS table spaces with its index, data, and long data separated into different table spaces. The table space containing the table data is restored from a backup image. Which of the table's other table spaces must also be restored in order to roll forward to a point in time prior to the end of the logs? A. Long table space B. Index table space C. Temporary table space D. Index and long table spaces		View Answer
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.		View Answer
What is database administration NOT concerned with? A. indexing B. creating tables C. accessing data D. application building		View Answer
To improve system redundancy using its grid architecture, where in the XIV System can a partition be mirrored? A. on disks in other modules B. on same disk in different modules C. on different disks in the same module D. on same disk, in same module, and in different modules		View Answer
Given these columns from the DEPARTMENT table: deptno CHAR(3) NOT NULL deptname CHAR(20) NOT NULL mgrno CHAR(6) admrdept CHAR(3) location CHAR(20) NOT NULL Which of the following will select the rows that do not have a value in the MGRNO column? A.SELECT * FROM department WHERE mgrno = � B.SELECT * FROM department WHERE mgrno = NULL C.SELECT * FROM department WHERE mgrno IS NULL D.SELECT * FROM department WHERE mgrno IS UNKNOWN		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) Where the job column contains job types: manager, clerk, and salesperson. Which of the following statements will return the data with all managers together, all clerks together, and all salespeople together in the output? A.SELECT * FROM staff ORDER BY job B.SELECT job, name FROM staff GROUP BY name, job C.SELECT * FROM staff GROUP BY name, job, id, dept, years, salary, comm D.SELECT * FROM staff ORDER BY name, job, id, dept, years, salary, comm		View Answer
An iSeries prospect is deciding between the proposed eServer i5 520 and a used i270 running V5R2. Which of the following considerations should impact the customer's decision? A. IBM will not transfer software to a used machine. B. The i270 uses SPD cards that will not be supported after V5R3. C. The customer must pay the Currency Access Fee with Software Maintenance. D. IBM requires an inspection fee for a Hardware Service contract for used equipment.		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		View Answer
Given the following table definition and SQL statement CREAT TABLE company (company_id INTEGER company_name VARCHAR (40) amount_due Decimal (15,2) SELECT company_id From company WHERE amount_due = SELECT MAX (amount_due) FROM company) Which index definition would provide the best performance for the SQL statement? A. CREATE INDEX i1 ON company (amount_due ASC) B. CREATE INDEX i1 ON company (amount_due DESC) C. CREATE INDEX i1 ON company (company_id,amount_due) D. CREATE INDEX i1 ON company (amount_due DESC) INCLUDE(company_id)		View Answer
Which of the following describes a benefit of running Microsoft Windows based applications on an Integrated xSeries Server? A. SupportLine includes support for Windows issues. B. iSeries provides support for hot-spare Windows servers. C. Software Maintenance includes release updates for Windows. D. Windows service packs are automatically installed with iSeries PTFs.		View Answer
Which of the following is required for the DB2 optimizer to consider a hash join strategy? A. Equijion predicates B. Optimization level 1 or above C. Registry variable DB_ANTIJOIN=YES D. SORTHEAP large enough to contain the tables being joined		View Answer
If there is a lock on an adjacent key, an insert will fail if the isolation level is set to what? A. committed read B. repeatable read C. share read D. indexed read		View Answer
Given the following SQL statement: GRANT REFERENCES ON TABLE tab1 TO USER usera Which of the following describes what USERA is allowed to do? A.Create a readonly view using TAB1. B.Alter TAB1 to add a check constraint. C.Define a primary key or unique constraint on TAB1. D.Define a dependent table where TAB1 is the parent.		View Answer
A customer has ordered a 10 module XIV System. How many interface modules are active in this configuration? A. 3 B. 4 C. 5 D. 6		View Answer
Which of the following extenders allows data to be presented in a threedimensional format? A.DB2 AVI Extender B.DB2 XML Extender C.DB2 Text Extender D.DB2 Spatial Extender		View Answer
On the XIV System, what is the approximate rebuild time for a 1 TB drive that is 50% utilized? A. 5 minutes B. 15 minutes C. 30 minutes D. 120 minutes		View Answer