I

DB2 9.7 Application Development

99 Questions

You can start the exam to practice all questions related to this exam.

Question No. 1

Given the table COURSES shown below:

COURSES
----------------------------------------

ID CODE NAME

1 ECE100 Operating Systems

2 ECE101 Programming Languages

3 ECE102 Intro to Databases

User USER1 executes the following statements:

DECLARE GLOBAL TEMPORARY TABLE tempcourses

LIKE db2user.courses

ON COMMIT PRESERVE ROWS;

INSERT INTO session.tempcourses SELECT * FROM db2user.courses;

SELECT max(ID) FROM session.tempcourses;

Assuming autocommit is on, which result will user USER1 obtain?

Choose the correct option from the given list.
01 / 99

0 Discussions

Trending Exams