Limited Time Discount Offer
30% Off - Ends in 02:00:00

X

IBM C2090-610 Dumps

verified by experts

  • Verified by experts

C2090-610 Premium File

  • 138 Questions & Answers

$21.41

$14.99
IBM
DB2 10.1 Fundamentals
IBM
DB2 10.1 Fundamentals

Files

File Name
Views
Size
Downloads

213

385.8 KB

160

Files

Views

213

Size

385.8 KB

Downloads

160

Questions & Answers for IBM C2090-610

Showing 1-15 of 136 Questions

Question #1 - Topic 1

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?

A. inline

B. binary

C. internal

D. partitioned

Question #2 - Topic 1

Which DB2 object is used to provide a logical grouping of other database objects?

A. Alias

B. Index

C. Schema

D. Collection

Question #3 - Topic 1

Which privilege is required to invoke a user defined function?

A. CALL

B. USAGE

C. EXECUTE

D. REFERENCES

Question #4 - Topic 1

A table named EMPLOYEE was created as follows:

Which action will prevent unauthorized users from accessing SSN data?

A. Assign the SSN column to a restricted role that only authorized users can access.

B. Only grant ACCESSCTRL authority for the SSN column to users who need to access SSN data.

C. Alter the table definition so that SSN data is stored in a separate schema that only authorized users can access.

D. Create a view for the EMPLOYEE table that does not contain the SSN column and require unauthorized users to use the view.

Question #5 - Topic 1

What functionality allows users to perform a UNION operation between a DB2 table and an
Oracle view?

A. Oracle connect

B. Trusted context

C. Oracle federation

D. Distributed request

Question #6 - Topic 1

Which statement is true regarding constraints?

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

B. A table can have multiple primary key constraints.

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

D. 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.

Question #7 - Topic 1

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

A. 4

B. 8

C. 16

D. 32

Question #8 - Topic 1

Which statement is true about an index that is used to support a UNIQUE constraint?

A. It must not contain more than one column.

B. It cannot be used in a referential constraint.

C. It must be defined with the UNIQUE attribute.

D. It must be defined as UNIQUE WHERE NOT NULL.

Question #9 - Topic 1

By default, where is the data stored for acolumn defined with an XML data type?

A. In an XML index.

B. In line with the rest of the data for the table.

C. In an XML storage object that is separate from the table.

D. In line with the rest of the data for the table, for XML columns less than 32KB.

Question #10 - 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?

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

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

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

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

Question #11 - Topic 1

Which statement about application-period temporal tables is true?

A. Consists of explicitly-supplied timestamps and a separate associated historytable.

B. Is based on explicitly-supplied timestamps that define the time periods during which data is valid.

C. Is useful when one wants to keep both user-based period information and system-based historical information.

D. Consists of a pair of columns with database-manager maintained values that indicate the period when a row is current.

Question #12 - Topic 1

A column mask that is to be used for row and column access control (RCAC) was created
with the DISABLEoption 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 toactivate column access control; row permission must be granted to everyone who needs to use the column mask.

Question #13 - Topic 1

What is the primary function of an Online Transaction Processing (OLTP) workload?

A. To combine data from multiple sources.

B. To discover hidden relationships in data.

C. To analyze large amounts of data to find patterns.

D. To make changes to a small number of records within a single transaction.

Question #14 - Topic 1

Which case will require a sequence to be dropped and recreated instead of being
modifiedby the ALTER SEQUENCE statement?

A. Change the data type of the sequence.

B. Reset the sequence to its starting value.

C. Establish new minimum or maximum values.

D. Change the increment between future values.

Question #15 - Topic 1

What factor influences lock escalation?

A. Table size

B. Buffer space

C. Number of locks

D. Available real storage

×