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

Sort By : Latest First | Oldest First | By Rating

Question	Rating	View Answer
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 A.0 B.1 C.2 D.3		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
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 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.		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		View Answer
Which of the following actions describes when SQL indexes can be explicitly referenced by name within an SQL statement? A.When dropping the index B.When altering the index C.When selecting on the index D.When inserting using the index		View Answer
Which of the following tools can be used to identify inefficient SQL statements without executing them? A.QMF B.Task Center C.Visual Explain D.Development Center		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		View Answer
Given the following table definitions: CREATE TABLE employee (empid INT NOT NULL PRIMARY KEY, emp_fname CHAR(30), emp_lname CHAR(30) ) CREATE TABLE payroll (empid INTEGER, weeknumber INTEGER, paycheck DECIMAL(6,2), CONSTRAINT fkconst FOREIGN KEY (empid) REFERENCES employee (empid) ON DELETE SET NULL, CONSTRAINT chk1 CHECK (paycheck>0 AND weeknumber BETWEEN 1 and 52)) The appropriate indexes exist to support the tables created with the previous CREATE statements. Which two of the following operations can cause the enforcement of a constraint defined on PAYROLL? A.Update of a row in PAYROLL B.Deletion of a row in PAYROLL C.Deletion of a row in EMPLOYEE D.Addition of a new column to PAYROLL E.Rollback of a row deletion on PAYROLL		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		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
Assuming the proper privileges, which two of the following would allow access to data in a table T1 using the name A1? A.CREATE ALIAS a1 FOR t1 B.CREATE TABLE a1 LIKE t1 C.CREATE INDEX a1 ON t1 (col1) D.CREATE VIEW a1 AS SELECT * FROM t1 E.CREATE TRIGGER trig1 AFTER INSERT ON t1 FOR EACH ROW MODE DB2SQL INSERT INTO a1		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		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		View Answer
A stored procedure has been created with the following statement: CREATE PROCEDURE P1(INOUT VAR1 VARCHAR(10))� From the command line processor (CLP), which is the correct way to call this procedure? A.Call P1(?) B.Call P1(DB2) C.Call P1(�DB2′) D.Call P1(�DB2″)		View Answer
Which of the following DB2 UDB isolation levels will lock no rows during read processing? A.Read Stability B.Repeatable Read C.Uncommitted Read D.Cursor Stability		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
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
A database administrator has supplied the following information: Protocol: TCP/IP Port Number: 446 Host Name: ZEUS Database Name: SAMPLE Database Server Platform: OS/400 Which are the appropriate commands to set up the ability to connect to the database? A.CATALOG TCPIP NODE zeus REMOTE zeus SERVER 446 OSTYPE os400 DATABASE sample; B.CATALOG TCPIP DATABASE sample REMOTE zeus SERVER 446 OSTYPE os400; CATALOG DATABASE dcssam AS sample AT NODE zeus AUTHENTICATION dcs; C.CATALOG TCPIP NODE zeus REMOTE zeus SERVER 446 OSTYPE os400; CATALOG DCS DB dcssam AS sample; CATALOG DATABASE dcssam AS sample AT NODE zeus AUTHENTICATION dcs; D.CATALOG TCPIP NODE sample REMOTE sample SERVER 446 OSTYPE os400; CATALOG DCS DB sample AS dcssam; CATALOG DATABASE dcssam AS sample AT NODE zeus AUTHENTICATION dcs;		View Answer
Which of the following occurs if an application ends abnormally during an active unit of work? A.The unit of work remains active B.The unit of work is rolled back C.The unit of work moves to CHECK_PENDING D.The unit of work moves to pending state		View Answer