QUESTION: 13

The metadata for which of the following objects is NOT stored in the DB2 catalog table SYSIBM.SYSTABLES?

A view
A temporal table
A created global temporary table
A declared global temporary table

Answer(s): B

Reveal Solution Next Question

QUESTION: 14

In a unique referential constraint, which type of key does a foreign key reference?

Child key
Collation key
Parent key
Secondary key

Answer(s): C

Reference:

https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/ com.ibm.db2.luw.admin.dbobj.doc/doc/c0020166.html

Reveal Solution Next Question

QUESTION: 15

The following definition for COL1 is given by this statement: CREATE TABLE… (COL1 BINARY (05))
Which of the following statements will successfully insert data into the table?

INSERT INTO… (COL1) VALUES(HEX(‘12345’));
INSERT INTO… (COL1) VALUES(BLOB(‘12345’));
INSERT INTO… (COL1) VALUES(CHAR(‘12345’));
INSERT INTO… (COL1) VALUES(BINARY(‘123456’));

Answer(s): C

Reveal Solution Next Question

QUESTION: 16

If a scrollable cursor is INSENSITIVE, which of the following applies?

The cursor is read only
WITH ROWSET POSITIONING is not allowed
The select-statement must not contain an SQL data change statement
The cursor has sensitivity to changes that are made to the database after the result table is materialized

Answer(s): A

Reference:

https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/java/src/tpc/imjcc_tjvsjscr.html

Reveal Solution Next Question

Free C2090-320 Exam Braindumps (page: 5)

QUESTION: 13

QUESTION: 14

Reference:

QUESTION: 15

QUESTION: 16

Reference:

C2090-320 Exam Discussions & Posts