IBM C2090-320 DB2 11 Fundamentals for z/OS exam Online Training
IBM C2090-320 Online Training
The questions for C2090-320 were last updated at Dec 24,2024.
- Exam Code: C2090-320
- Exam Name: DB2 11 Fundamentals for z/OS exam
- Certification Provider: IBM
- Latest update: Dec 24,2024
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
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?
- A . SET CURRENT SQLID = ‘DB2’;
- B . SET CURRENT RULES = ‘DB2’;
- C . No preceding statement is needed
- D . SET CURRENT SCHEMA = ‘DB2’;
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
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
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?
- 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’));
If a scrollable cursor is INSENSITIVE, which of the following applies?
- A . The cursor is read only
- B . WITH ROWSET POSITIONING is not allowed
- C . The select-statement must not contain an SQL data change statement
- D . The cursor has sensitivity to changes that are made to the database after the result table is materialized
You want to reduce lock contention that results from uncommitted insert and delete operations by enabling transactions that read data to access only the currently committed data rather than waiting for the uncommitted changes to be resolved.
How can you accomplish this?
- A . Bind your application with ISOLATION(UR)
- B . Bind your application with ISOLATION(CS)
- C . Bind your application with CONCURRENTACCESSRESOLUTION (WAITFOROUTCOME)
- D . Bind your application with CONCURRENTACCESSRESOLUTION (USECURRENTLYCOMMITTED)
Given the following CREATE VIEW statement and sample data; your login id is “ROGER”.
What will be the result for this query?
- A . 6
- B . 5
- C . 4
- D . 2
Assume DELETE triggers exist on the employee table.
Which of the following statements will delete all the rows in the employee table and ignore any DELETE triggers?
- A . TRUNCATE employee;
- B . DELETE FROM employee;
- C . DELETE FROM employee WHERE…;
- D . TRUNCATE employee RESTRICT WHEN DELETE TRIGGERS;
Which of the following is a characteristic of a stand-alone utility?
- A . It can only be executed using JCL
- B . It can only be executed by a user with SYSADM
- C . It can only be executed if no other utilities are running
- D . It can only be executed in a non-data sharing environment
Latest C2090-320 Dumps Valid Version with 123 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
