DB2 10.1 exam C2090-610 practice questions

This Database Associate certification is an entry level exam for a user of any of the DB2 family of products. This individual is knowledgeable about the fundamental concepts of DB2 10.1 through either hands on experience or formal and informal education. The database associate should have an in-depth knowledge of the basic to intermediate tasks required in day-to-day administration, basic SQL (Structured Query Language), understand which additional products are available with DB2 10.1, understand how to create databases and database objects, and have a basic knowledge of database security and transaction isolation.

Passcert DB2 10.1 exam C2090-610 practice questions cover all the topics for a candidate to prepare for this IBM examination. Most of the people have found these DB2 10.1 exam C2090-610 practice questions are very helpful and have cleared their C2090-610 tests with flying colors. You could go through each and every question and answer given in this format thoroughly, and be confident about appearing in your final IBM C2090-610 exam.

Share some IBM Certified Database Administrator C2090-610 exam questions and answers below.
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); 
Answer: D

Which object is a stored procedure defined into? 
A. Table 
B. Schema 
C. Package 
D. Database 
Answer: B

Which two activities indicate the need for a data warehouse? (Choose two.) 
A. Confirm product inventory. 
B. Monitor product availability. 
C. Summarize sales by region. 
D. Identify patterns for products sold in the last five years. 
E. Associate one or more products with a purchase order. 
Answer: C,D

What factor influences lock escalation? 
A. Table size 
B. Buffer space 
C. Number of locks 
D. Available real storage 
Answer: C

When is it appropriate to use a sequence? 
A. When you want to control the order in which triggers are fired. 
B. When you want to control the order in which stored procedures can be invoked. 
C. When you want to automatically generate a numeric value that is not tied to any specific column or table. 
D. When you want to automatically generate a numeric value for each row that is added to a specific table. 
Answer: C

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 
Answer: A

Which isolation level offers the greatest protection of data but provides the least amount of concurrency? 
A. Read Stability (RS) 
B. Cursor Stability (CS) 
C. Repeatable Read (RR) 
D. Uncommitted Read (UR) 
Answer: C

Which DB2 object is used to provide a logical grouping of other database objects? 
A. Alias 
B. Index 
C. Schema 
D. Collection 
Answer: C

You have a business need to query DB2 10 and DB2 9 databases and you want to write an application that can run on most platforms unchanged. Which interface would you use to achieve your goal? 
A. CLI 
B. XML 
C. JDBC 
D. RUBY 
Answer: C

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

When an index is created for a table, where is the metadata for that index stored? 
A. In the table definition. 
B. In the system catalog. 
C. In the schema that the index resides in. 
D. In the metadata of the table the index was created for. 
Answer: B

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

Which type of lock allows the lock owner and all concurrent applications to read, but not update, the locked data? 
A. Share (S) 
B. Update (U) 
C. Exclusive (X) 
D. Intent Exclusive (IX) 
Answer: A

Which product is used to customize execution environments for the purpose of controlling system resources so that one department or service class does not overwhelm the system? 
A. pureScale 
B. Workload manager 
C. Data partitioning feature 
D. Self-tuning memory manager 
Answer: B

What are two valid objects that can be created in DB2? (Choose two.) 
A. Tree 
B. Node 
C. Trigger 
D. Contexts 
E. Sequence 
Answer: C,E

Everyone has a utopian dream in own heart. Dreams of imaginary make people feel disheartened. In fact, as long as you take the right approach, everything is possible. You can pass the IBM C2090-610 exam easily. Why? Because you have Passcert DB2 10.1 exam C2090-610 practice questions. Passcert DB2 10.1 exam C2090-610 practice questions are the best training materials for IT certification. It is famous for the most comprehensive and updated by the highest rate. It also can save time and effort. With it, you will pass the exam easily. If you pass the exam, you will have the self-confidence, with the confidence you will succeed.