AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For IBM- C2090-612





Question ID 20496

Poorly tuned memory can affect application performance, such as having sequential
prefetch turned off. Which statistic should you monitor from the statistics report to be sure
this is not occurring?

Option A

PREF.DISABLED-NO BUFFER

Option B

PREF.DISABLED-NO READ ENG

Option C

BUFF.UPDATES/PAGESWRITTEN

Option D

PAGES WRITTEN PER WRITE I/O

Correct Answer A
Explanation


Question ID 20497

Given the following view definition: CREATE VIEW EMPD AS (SELECT D.DEPTNAME,
E.LASTNAME FROM DEPT D INNER JOIN EMP E ON D.DEPTNO = E.WORKDEPT);
Can an UPDATE statement be used to update the view EMPD on joined tables DEPT and
EMP?

Option A

No, an UPDATE statement against the EMPD view is not allowed at all.

Option B

 Yes, the view EMPD can be updateddirectly via an UPDATE statement.

Option C

 No, only a clone of the view EMPD can be updated via an UPDATE statement.

Option D

 Yes, an UPDATE statement against the EMPD view is allowed if an INSTEAD OF trigger is defined on the view.

Correct Answer D
Explanation

Send email to admin@getfreedumps for new dumps request!!!