Ensurepass.com : Ensure you pass the IT Exams
2018 Jan IBM Official New Released C2090-610
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/C2090-610.html

DB2 10.1 Fundamentals

Question No: 91 – (Topic 2)

Which object is used to cache table and index data asit is read from disk?

  1. Database

  2. Buffer pool

  3. Table space

  4. Package cache

Answer: B

Question No: 92 – (Topic 2)

Given the following statement:

GRANT DELETE ON TABLE sales TO User1 WITH GRANT OPTION;

Which statement is correct?

  1. USER1 can only remove the SALES table.

  2. USER1 can only remove records from the SALES table.

  3. USER1 can remove the SALES table and grant the privilege to remove the SALES table to other users.

  4. USER1 can remove records from the SALES table and grant the privilege to remove records from the SALES table to other users.

Answer: D

Question No: 93 – (Topic 2)

Which object can a buffer pool beassigned to?

  1. Schema

  2. Table space

  3. Storage group

  4. Stored procedure

Answer: B

Question No: 94 – (Topic 2)

After creating several new indexes and executing RUNSTATS, user USER1 wants to re- create a package that is stored in the database so it will take advantage of the new indexes. Which authority/privilege must user USER1 be granted in order to re-create the package?

  1. BIND

  2. REBIND

  3. BINDADD

  4. BIND_REBIND

Answer: A

Question No: 95 – (Topic 2)

Which SQL statement will create a DB2 object that can be used to store numerical data as Canadian currency?

  1. CREATE DISTINCT ALIAS canadian_dollar AS DECIMAL (9,3) WITH COMPARISONS

  2. CREATE DISTINCT TYPE canadian_dollar AS DECIMAL (9,3) WITH COMPARISONS

  3. CREATE DISTINCT PROCEDURE canadian_dollar AS DECIMAL (9,3) WITH COMPARISONS

  4. CREATE DISTINCT FUNCTION canadian_dollar AS DECIMAL (9,3) WITH COMPARISONS

Answer: B

Question No: 96 – (Topic 2)

What type of large object (LOB) is used to store LOB data together with the formatted rows on data pages, instead of in a separate LOB storage object?

  1. inline

  2. binary

  3. internal

  4. partitioned

Answer: A

Question No: 97 – (Topic 2)

Application APP_A is performing updates totable TAB1 using the read stability (RS) isolation level. Which isolation level will allow application APP_B to retrieve all rows from table TAB1 immediately, rather than have to wait until application APP_A has finished making updates?

  1. Read Stability(RS)

  2. Cursor Stability (CS)

  3. Repeatable Read (RR)

  4. Uncommitted Read (UR)

Answer: D

Question No: 98 – (Topic 2)

Which method for restricting data access relies on aSQL search condition that describes what set of rows a user has access to?

  1. Authentication

  2. Authorities and privileges

  3. Label-based access control

  4. Row and column access control

Answer: D

Question No: 99 – (Topic 2)

Which object can be enabled for compression?

  1. View

  2. Buffer pool

  3. Storage group

  4. Temporary table

Answer: D

Question No: 100 – (Topic 2)

Given the following statements:

Ensurepass 2018 PDF and VCE

What will be the result?

  1. Joe Smith

  2. lt;namegt;Joe Smithlt;/namegt;

  3. lt;namegt;Joe Smithgt;lt;/namegt;lt;namegt;DB2lt;/namegt;

  4. lt;employeeinfogt;lt;namegt;Joe Smithlt;/namegt;lt;/employeeinfogt;

Answer: B

100% Ensurepass Free Download!
Download Free Demo:C2090-610 Demo PDF
100% Ensurepass Free Guaranteed!
C2090-610 Dumps

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.