Usually, which is more important for DB2 system
performance - CPU processing or I/O access?
Answer / s
I/O is expensive as most the the CPU time is wasted doing
I/O's
| Is This Answer Correct ? | 2 Yes | 1 No |
What is the physical storage length of timestamp data type?
What is the physical storage length of date data type?
What happens to the PLAN if index used by it is dropped?
How can you get the number of rows impacted by the last executed query?
How to get Top 10 Salaries from a Table
How do I import a csv file into db2?
What is precompiler in db2?
SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .
In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)
What is a cursor?
Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?
Can you use max on a char column?