Usually, which is more important for DB2 system performance

Usually, which is more important for DB2 system
performance - CPU processing or I/O access?

Question Posted / guest

Usually, which is more important for DB2 system performance - CPU processing or I/O access?..

I/O is expensive as most the the CPU time is wasted doing
I/O's

Is This Answer Correct ?

2 Yes

1 No

More DB2 Interview Questions

what's the best lock size that you could use when you create a tablespace?

If I have a view which is a join of two or more tables, can this view be updatable?

What is lock escalation?

what is the process of precompiler?

Define db2 and its databases?

AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE

What is the usage of open cursor command?

how can u retrieve the data from null values using applicaion program.

Outputs of explain are with matchcols = 0. What does this signify?

How and when does the db2 enforces the unique key?

how to fetch first 100 rows in db2

What is EXPLAIN?

For more DB2 Interview Questions Click Here