C2090-730 Online Practice Questions and Answers

Which of the following DB2 objects can be referenced by an INSERT statement to generate values for a column?

A. Sequence

B. Identity column

C. Trigger

D. Table function

Given the following ALTER SEQUENCE statement:

ALTER SEQUENCE myseq RESTART WITH 0 INCREMENT BY 1 NO MAXVALUE CACHE 5 ORDER

Assuming that the sequence had reached a value of 100 prior to the RESTART, which of the following is true?

A. The next value will be 0 and the sequence will never use the values 101 to 105.

B. The next value will be 101 to ensure uniqueness between existing and newly generated sequence values.

C. Previously cached values are retained by DB2, and after the restart, will be used for values 101 to 105.

D. The next value will be 0 and DB2 will not ensure uniqueness between existing and newly generated values.

Given the following DDL and INSERT statements:

CREATE VIEW v1 AS SELECT col1 FROM t1 WHERE col1 > 10; CREATE VIEW v2 AS SELECT col1 FROM

v1 WITH CASCADED CHECK OPTION; CREATE VIEW v3 AS SELECT col1 FROM v2 WHERE col1 < 100;

INSERT INTO v1 VALUES(5);

INSERT INTO v2 VALUES(5);

INSERT INTO v3 VALUES(20);

INSERT INTO v3 VALUES(100);

How many of these INSERT statements will be successful?

A. 0

B. 1

C. 2

D. 3

Which of the following will DELETE all of the rows from table T03?

A. DELETE * FROM TABLE T03

B. DELETE ALL FROM T03

C. DELETE * FROM T03

D. DELETE FROM T03

Given the following two tables:

EMPLOYEE

ID NAME DEPTID

01 Mick Jagger 10 02 Keith Richards 20 03 Ronnie Wood 20 04 Charlie Watts 20 05 Bill Wyman 30 06 Brian Jones

DEPARTMENT

ID DEPTNAME

10 Executive Staff 20 Sales 30 Marketing 40 Engineering 50 Human Resources

Which two of the following queries will display the employee name and department name for all employees that are in Sales?

A. SELECT e.name,d.deptname FROM employee e, department d WHERE e.deptid = d.id AND d.id = '20'

B. SELECT e.name,d.deptname FROM employee e FULL OUTER JOIN department d ON e.deptid = d.id WHERE d.id = '20'

C. SELECT e.name,d.deptname FROM employee e RIGHT OUTER JOIN department d ON e.deptid = d.id WHERE d.id = '20'

D. SELECT e.name,d.deptname FROM employee e LEFT OUTER JOIN department d ON e.deptid = d.id WHERE d.id = '20'

E. SELECT e.name,d.deptname FROM employee e INNER JOIN department d ON e.deptid = d.id WHERE d.id = '20'

Given the following statements:

CREATE TABLE table1 (col1 INTEGER, col2 CHAR(3)); CREATE VIEW view1 AS SELECT col1, col2 FROM table1 WHERE col1 < 100 WITH LOCAL CHECK OPTION;

Which of the following INSERT statements will execute successfully?

A. INSERT INTO view1 VALUES (50,abc)

B. INSERT INTO view1VALUES(100, abc)

C. INSERT INTO view1VALUES(50, 'abc')

D. INSERT INTO view1VALUES(100, 'abc')

Which of the following causes a lock that is being held by an application using the Cursor Stability isolation level to be released?

A. The cursor is moved to another row

B. The row the cursor is on is deleted by the application

C. The row the cursor is on is deleted by another application

D. The row the cursor is on needs to be updated by another application

Which of the following best describes the lock protection provided by DB2 for the current row of a cursor?

A. The cursor is only protected from updates and deletes by concurrent applications.

B. The row is only protected from positioned updates and deletes that reference another cursor of the same application.

C. The cursor is protected from positioned updates and deletes that reference another cursor of a different application.

D. The row is protected from updates and deletes by the current application and from positioned updates and deletes that reference another cursor of the same application.