IBM C2090-320 - DB2 11 Fundamentals for z/OS Exam
Page: 3 / 13
Total 63 questions
Question #11 (Topic: Topic 1)
Which of the following SQL constructs does NOT provide information about the success or failure of the SQL statement that was just executed?
A. SQLCA
B. SQLDA
C. SQLCODE
D. SQLSTATE
Answer: B
Question #12 (Topic: Topic 1)
Your current authorization ID is DBA. Only one of your secondary authorization IDs, DB2, has the privilege to create an index DB2.AAA on a table. The
appropriate SQL statement starts with “CREATE INDEX AAA ON…â€. Which of the following statements must precede the CREATE statement so that you can
create the index?
appropriate SQL statement starts with “CREATE INDEX AAA ON…â€. Which of the following statements must precede the CREATE statement so that you can
create the index?
A. SET CURRENT SQLID = ‘DB2’;
B. SET CURRENT RULES = ‘DB2’;
C. No preceding statement is needed
D. SET CURRENT SCHEMA = ‘DB2’;
Answer: A
Question #13 (Topic: Topic 1)
The metadata for which of the following objects is NOT stored in the DB2 catalog table SYSIBM.SYSTABLES?
A. A view
B. A temporal table
C. A created global temporary table
D. A declared global temporary table
Answer: B
Question #14 (Topic: Topic 1)
In a unique referential constraint, which type of key does a foreign key reference?
A. Child key
B. Collation key
C. Parent key
D. Secondary key
Answer: C
Question #15 (Topic: Topic 1)
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?
CREATE TABLE… (COL1 BINARY (05))
Which of the following statements will successfully insert data into the table?
A. INSERT INTO… (COL1) VALUES(HEX(‘12345’));
B. INSERT INTO… (COL1) VALUES(BLOB(‘12345’));
C. INSERT INTO… (COL1) VALUES(CHAR(‘12345’));
D. INSERT INTO… (COL1) VALUES(BINARY(‘123456’));
Answer: C
