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
Which two happen when the ALTER FRAGMENT statement is run? A. Transaction logging, if present is suspended. B. The table is locked until the statement is completed. C. The database is locked until the statement is complete. D. For databases with logging the statement executes as a single transaction		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		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		View Answer
What are three advantages of fragmentation? A. higher availability B. reduced disk space requirements C. parallel scans are possible with PDQ D. finer granularity of archives and resources		View Answer
What does the ATTACH clause in the ALTER FRAGMENT statement do? A. It adds extents to a table. B. It attaches a raw data file to a table C. It combines two unregimented tables D. It combines two fragmented tables		View Answer
Which statement fragments a table as round robin? A. FRAGMENT AS ROUND ROBIN IN dbspace 1, dbspace 2 B. FRAGMENT TABLE BY ROUND ROBIN IN dbspace1, dbspace 2 C. FRAGMENT BY ROUND ROBIN IN dbspace1, dbspace 2 D. FRAGMENT BY ROUND ROBIN		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
Which isolation level does a database without logging default to? A. committed read B. dirty read C. mode ANSI D. repeatable read		View Answer
Which three can be locked? A. a row B. a page C. a column D. a key E. shared memory		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
.A table called EMPLOYEE has the following columns: NAME DEPARTMENT PHONE_NUMBER Which of the following will allow USER1 to modify the PHONE_NUMBER column? A.GRANT INDEX (phone_number) ON TABLE employee TO user1 B.GRANT ALTER (phone_number) ON TABLE employee TO user1 C.GRANT UPDATE (phone_number) ON TABLE employee TO user1 D.GRANT REFERENCES (phone_number) ON TABLE employee TO user1		View Answer
Which of the following tools is used to create subscription sets and add subscriptionset members to subscription sets? A.Journal B.License Center C.Replication Center D.Development Center		View Answer
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		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		View Answer
Which two of the following SQL data types should be used to store a small binary image? A.CLOB B.BLOB C.VARCHAR D.GRAPHIC E.VARCHAR FOR BIT DATA		View Answer
A unit of work is using an isolation level of Read Stability. An entire table is scanned twice within the unit of work. Which of the following can be seen on the second scan of the table? A.Rows removed by other processes B.Rows added to a result set by other processes C.Rows changed in a result set by other processes D.Rows with uncommitted changes made by other processes		View Answer
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		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.		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: COUNTRY c1 INTEGER name CHAR(20) Which of the following SQL statements will remove all rows from the table named COUNTRY? A.DELETE FROM country B.DELETE * FROM country C.DELETE FROM TABLE country D.DELETE FROM country WHERE c1 IS NOT NULL		View Answer