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: 1 – (Topic 1)

Which statement is true regarding constraints?

  1. A table can only have one unique key constraint.

  2. A table can have multiple primary key constraints.

  3. Informational constraints tell DB2 what rules the data conforms to,but the rules are not enforced.

  4. Foreign key constraints are enforced on the values within the rows of a table, or between the rows of two tables, by a unique index on a foreign key.

Answer: C

Question No: 2 – (Topic 1)

If a user has been granted SYSCTRL authority, which activities can they perform?

  1. Load operations

  2. Backup/copy table spaces

  3. Create and drop databases

  4. Monitordatabase performance

Answer: C

Question No: 3 – (Topic 1)

Which operation normally does NOT require an exclusivelock?

  1. BIND

  2. DROP

  3. GRANT

  4. SELECT

Answer: D

Question No: 4 – (Topic 1)

Which statement about BEFORE triggers is FALSE?

  1. A BEFORE trigger can be used to perform validation of input data.

  2. A BEFORE trigger can be used to automatically generate values for newly inserted rows.

  3. A BEFORE trigger is fired for each row in the set of affected rows before the trigger event executes.

  4. A BEFORE trigger is fired for each row in the set of affected rows instead of executing the trigger event.

Answer: D

Question No: 5 – (Topic 1)

Which statement regarding triggersis true?

  1. Only one INSERT, UPDATE, or DELETE trigger can be defined per table.

  2. Triggers cannot be modified, they must be dropped and recreated with new definitions.

  3. Adding a trigger to a table that already has rows in it will cause triggered actions to be fired.

  4. Triggers can only be fired one time per statement irrespective of the number of rows affected.

Answer: B

Question No: 6 – (Topic 1)

When is it appropriate to use a sequence?

  1. When you want to control the order in which triggersare fired.

  2. When you want to control the order in which stored procedures can be invoked.

  3. When you want to automatically generate a numeric value that is not tied to any specific column or table.

  4. When you want to automatically generate a numeric value for each row that is added to a specific table.

Answer: C

Question No: 7 – (Topic 1)

Which clause should be included in a ALTER TABLE statement to update a table definition with a new column?

  1. ADD COLUMN

  2. ALTER COLUMN

  3. APPEND COLUMN

  4. RENAME COLUMN

Answer: A

Question No: 8 – (Topic 1)

If the following command is executed: CREATE DATABASE test What is the page size (in kilobytes) of thedatabase?

  1. 4

  2. 8

  3. 16

  4. 32

Answer: A

Question No: 9 – (Topic 1)

Given the following DDL statement: CREATE TABLE sales (item CHAR(20)); If a DBA wishes to increase the size of the ITEM column, which SQL statement needs to be used?

  1. ALTER TABLE sales ADD COLUMN item CHAR(40);

  2. ALTER TABLE sales ALTER COLUMN item CHAR(40);

  3. ALTER TABLE sales MODIFY COLUMN item CHAR(40);

  4. ALTER TABLE sales ALTER COLUMN item SET DATA TYPE CHAR(40);

Answer: D

Question No: 10 – (Topic 1)

Which tool allows users to connect to a DB2 database using a wizard?

  1. Control Center

  2. IBM Data Studio

  3. Universal Connection Expert

  4. DB2 Connection Pool Manager

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.