P.S. Certified C2090-320 ebook are available on Google Drive, GET MORE: https://drive.google.com/open?id=1XIupSsBUtO-ijoq0DwWZR2atFXSuzaPm
New IBM C2090-320 Exam Dumps Collection (Question 3 - Question 12)
Question No: 3
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
Answer: A
Question No: 4
Which statement is TRUE regarding ROLLBACK processing?
A. It only reads active logs
B. It always needs archive logs
C. It can never be processed just from memory
D. It uses output buffers, active and archive logs
Answer: D
Question No: 5
Which types of user-defined data types are supported? (Choose two.)
A. CHAR
B. ARRAY
C. NUMERIC
D. DISTINCT
E. TIMESTAMP
Answer: BD
Question No: 6
Which DB2 address space manages DB2 locking?
A. IRLM
B. DIST
C. DBM1
D. MSTR
Answer: A
Question No: 7
You want to see all messages that were generated by one specific DB2 subsystem such as log switches and timeout messages. Which job log would show all of these?
A. MSTR
B. DBM1
C. DIST
D. IRLM
Answer: A
Question No: 8
Given the following CREATE TABLE statement, and a unique index on column EMPID, which set of SQL statements is valid?
A.
B.
C.
D.
Answer: D
Question No: 9
Which authorizations can change the value of the subsystem parameter SYSADM using the u2013SET SYSPARM command? (Choose two.)
A. SYSADM
B. SECADM
C. SYSCTRL
D. Installation SYSADM
E. Installation SYSOPR
Answer: DE
Question No: 10
Which of the following elements is affected by a ROLLBACK statement?
A. LOB table spaces
B. Changes in cursor positioning
C. Acquisition and release of locks
D. Caching of rolled back statements
Answer: A
Question No: 11
Which of the following are contained in the PLAN_TABLE? (Choose two.)
A. RUNSTATS recommendations
B. Access to LOB values, which are stored separately from the base table
C. Access to parent or dependent tables needed to enforce referential constraints
D. Whether an index access or table space scan is used for each access to a table
E. The join methods and types that are used, and the order in which DB2 joins the tables
Answer: DE
Question No: 12
You are designing a payroll table that will contain a salary column. Which of the following is the appropriate built-in data type for a salary column?
A. REAL
B. BIGINT
C. DECIMAL
D. INTEGER
Answer: C
100% Leading IBM C2090-320 Questions & Answers shared by 2passeasy, Get HERE: https://www.2passeasy.com/dumps/C2090-320/ (New Q&As)