IBM DB2 10.1 Fundamentals - C2090-610무료 덤프문제 풀어보기

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

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

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

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

A. Workload manager

B. Data partitioning feature

C. pureScale

D. Self-tuning memory manager

A. Associate one or more products with a purchase order.

B. Monitor product availability.

C. Confirm product inventory.

D. Summarize sales by region.

E. Identify patterns for products sold in the last five years.

A. Control Center

B. DB2 Connection Pool Manager

C. IBM Data Studio

D. Universal Connection Expert

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

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

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

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

A. Lock conversion/promotion

B. Lock substitution

C. Lock switch/exchange

D. Lock escalation

A. Open cursors defined WITH HOLD are closed, but their data is retained.

B. The current transaction is terminated and a new transaction boundary is started.

C. All locks held on the database are automatically released.

D. Data stored in global temporary tables is automatically deleted.

A. Create and drop databases

B. Load operations

C. Monitor database performance

D. Backup/copy table spaces