Your success in IBM C2090-610 is our sole target and we develop all our C2090-610 braindumps in a way that facilitates the attainment of this target. Not only is our C2090-610 study material the best you can find, it is also the most detailed and the most updated. C2090-610 Practice Exams for IBM C2090-610 are written to the highest standards of technical accuracy.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for IBM C2090-610 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW C2090-610 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/C2090-610-exam-dumps.html
Q71. Which product replaced the Control Center used in versions prior to DB2 v10?
A. IBM Data Studio
B. IBM Administrator
C. IBM Data Manager
D. IBM Command Center
Answer: A
Explanation:
Q72. Which statement regarding triggers is true?
A. Only one INSERT, UPDATE, or DELETE trigger can be defined per table.
B. Triggers cannot be modified, they must be dropped and recreated with new definitions.
C. Adding a trigger to a table that already has rows in it will cause triggered actions to be fired.
D. Triggers can only be fired one time per statement irrespective of the number of rows affected.
Answer: B
Explanation:
Q73. Which object is used to cache table and index data as it is read from disk?
A. Database
B. Buffer pool
C. Table space
D. Package cache
Answer: B
Explanation:
Q74. Which statement is valid about the Row and Column Access Control (RCAC) feature?
A. A row mask's access control rule is defined by an SQL CASE expression; a column permission's access control rule is defined by an SQLsearch condition.
B. A row permission's access control rule is defined by an SQL CASE expression; a column mask's access control rule is defined by an SQLsearch condition.
C. A row mask's access control rule is defined by an SQL search condition; a column permission's access control rule is defined by an SQL CASEexpression.
D. A row permission's access control rule is defined by an SQL search condition; a column mask's access control rule is defined by an SQL CASEexpression.
Answer: D
Explanation:
Q75. The EXCLUSIVE MODE option of the LOCK TABLE statement is used to prevent which of the following?
A. Concurrent application processes from performing any operations on the table.
B. Concurrent application processes from performing any read-only operations on the table.
C. Concurrent applications processes that are running under the cursor stability (CS) isolation level from performing read-only operations on thetable.
D. Concurrent applications processes that are running under the uncommitted read (UR) isolation level from performing read-only operations onthe table.
Answer: A
Explanation:
Q76. An SQL function designed to convert temperatures from Fahrenheit to Celsius was created as follows:
How can this function be used to convert average temperature (AVG_TEMP) data stored in a table called CLIMATE_INFO?
A. CALL conv_temp(climate_info.avg_temp);
B. CALL convert_ftoc(climate_info.avg_temp);
C. SELECT conv_temp(avg_temp) FROM climate_info;
D. SELECT convert_ftoc(avg_temp) FROM climate_info;
Answer: C
Explanation:
Q77. User USER1 wants to retrieve records from a table named EMPLOYEE that satisfy at least one of the following criteria:
-The employee's hire date (HIREDATE) is before 1999 and the employee's salary (SALARY) is less than $40,000.00 a year. -The employee has attended university
Which SQL statement will accomplish this?
A. SELECT * FROM employee
WHERE (hiredate < '1999-01-01' AND salary < 40000)
OR (education = 'University')
B. SELECT * FROM employee
WHERE (hiredate < '1999-01-01') OR (salary < 40000)
OR (education = 'University')
C. SELECT * FROM employee
WHERE (hiredate < '1999-01-01' OR (salary < 40000
AND (education = 'University')
D. SELECT * FROM employee
WHERE (hiredate < '1999-01-01' AND salary < 40000
AND (education = 'University')
Answer: A
Explanation:
Q78. A column mask that is to be used for row and column access control (RCAC) was created with the DISABLE option specified. What must be done if this mask is to be used to restrict access to data stored in a table named EMPLOYEE?
A. The column mask must be enabled; the EMPLOYEE table must be altered to activate column access control.
B. The column mask must be enabled (column access control for the EMPLOYEE table will be activated automatically).
C. The EMPLOYEE table must be altered to activate column access control (the column mask will be enabled automatically).
D. The EMPLOYEE table must be altered to activate column access control; row permission must be granted to everyone who needs to use thecolumn mask.
Answer: A
Explanation:
Q79. What is the act of exchanging one lock an application holds on a resource for a more restrictive lock on the same resource known as?
A. Lock escalation
B. Lock substitution
C. Lock switch/exchange
D. Lock conversion/promotion
Answer: D
Explanation:
Q80. Application APP_A is performing updates to table TAB1 using the cursor stability (CS) isolation level. If application APP_B wants to retrieve all rows from table TAB1 without waiting for application APP_A to finish making updates, what isolation level must application APP_B use?
A. Read Stability (RS)
B. Repeatable Read (RR)
C. Uncommitted Read (UR)
D. Cursor Stability (CS)
Answer: C
Explanation: