A sequence was created with the DDL statement shown below:
CREATE SEQUENCE my_seq START WITH 5 INCREMENT BY 5 CACHE 5
User1 successfully executes the following statements in Connection1: VALUES NEXT VALUE FOR my_seq INTO :con1hvar VALUES NEXT VALUE FOR my_seq INTO :con1hvar User2 successfully executes the following statement in Connection2: VALUES NEXT VALUE FOR my_seq INTO :con2hvar
After User1 & User2 are finished, User3 executes the following statement in Connection3:
SELECT NEXT VALUE FOR my_seq FROM sysibm.sysdummy1
Which value will be returned by the query?

• A. 55
• B. 20
• C. 25
• D. 50

Which of the following DB2 objects are publicly referenced names that require no special authority or privilege to use them?

• A. Alias
• B. View
• C. Table
• D. Package

On which two of the following database objects may the SELECT privilege be controlled?

• A. Schema
• B. Nickname
• C. View
• D. Sequence
• E. Index

Given the following query:
SELECT last_name, first_name, age, hire_date
FROM employee WHERE age > 40 Which of the following clauses must be added to return the rows sorted by AGE, oldest first, and by LAST_NAME, from A to Z?

• A. SORT BY age DESC,last_name
• B. ORDER BY age ASC,last_name
• C. ORDER BY age DESC,last_name
• D. SORT BY age ASC,last_name

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