Examcollection C2090-730 Questions are updated and all C2090-730 answers are verified by experts. Once you have completely prepared with our C2090-730 exam prep kits you will be ready for the real C2090-730 exam without a problem. We have Abreast of the times IBM C2090-730 dumps study guide. PASSED C2090-730 First attempt! Here What I Did.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for IBM C2090-730 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW C2090-730 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/C2090-730-exam-dumps.html
Q91. Which of the following DB2 objects is NOT considered executable using SQL?
A. Routine
B. Function
C. Procedure
D. Trigger
Answer: D
Explanation:
Q92. Which of the following best describes the lock protection provided by DB2 for the current row of a cursor?
A. The cursor is only protected from updates and deletes by concurrent applications.
B. The row is only protected from positioned updates and deletes that reference another cursor of the same application.
C. The cursor is protected from positioned updates and deletes that reference another cursor of a different application.
D. The row is protected from updates and deletes by the current application and from positioned updates and deletes that reference another cursor of the same application.
Answer: A
Explanation:
Q93. Which of the following describes how DB2 9 stores an XML document if the
XML Extender is not used?
A. CLOB
B. BLOB
C. Hierarchically
D. Rows and columns
Answer: C
Explanation:
Q94. Which tool must be used to analyze all of the database operations performed by an application against a DB2 for i5/OS database?
A. Visual Explain
B. Activity Monitor
C. SQL Performance Monitor
D. DB2 Performance Monitor
Answer: C
Explanation:
Q95. Which two of the following authorities allow a user to create a new database?
A. SYSADMN
B. SYSCTRL
C. SYSMAINT
D. DBADM
E. CREATEDB
Answer: A,B
Explanation:
Q96. Application A currently holds an exclusive lock on a single row and application B tries to access that row. If lock timeout is set to -1 and both applications are using isolation level RS, which of the following will occur?
A. Applications A and B will cause a deadlock situation.
B. Application B will read the previous version of the row.
C. Application B will read the row and see uncommitted changes made by application A.
D. Application B will be placed in a lock-wait state until application A releases its lock.
Answer: D
Explanation:
Q97. Given the following scenario:
Table TABLE1 needs to hold specific numeric values up to 9999999.999 in column COL1. Once TABLE1 is populated, arithmetic operations will be performed on data stored in column COL1.
Which of the following would be the most appropriate DB2 data type to use for column COL1?
A. INTEGER
B. REAL
C. NUMERIC(7, 3)
D. DECIMAL(10, 3)
Answer: D
Explanation:
Q98. Which of the following is TRUE for the DB2 isolation level Cursor Stability (CS)?
A. An application process acquires at least a share lock on the current row of every cursor.
B. Any row that is read during a unit of work cannot be changed by other application processes until the unit of work is complete.
C. Any row changed by another application process can be read, even if the change has not been committed by that application process.
D. An application process that issues the same query more than once in a unit of work will not see additional rows caused by other application processes appending new information to the database.
Answer: A
Explanation:
Q99. On which of the following database objects may the SELECT privilege be controlled?
A. Sequence
B. Schema
C. Group
D. View
Answer: D
Explanation:
Q100. Given the following two tables: TAB1
COL_1 COL_2
A 10 B 12 C 14
TAB2
COL_A COL_B
A 21 C 23 D 25
Assuming the following results are desired: COL_1 COL_2 COL_A COL_B A 10 A 21 B 12 --C 14 C 23 --D 25
Which of the following joins will produce the desired results?
A. SELECT * FROM tab1 INNER JOIN tab2 ON col_1 = col_a
B. SELECT * FROM tab1 LEFT OUTER JOIN tab2 ON col_1 = col_a
C. SELECT * FROM tab1 RIGHT OUTER JOIN tab2 ON col_1 = col_a
D. SELECT * FROM tab1 FULL OUTER JOIN tab2 ON col_1 = col_a
Answer: D
Explanation: