What is the format (internal layout) of ?TIMESTAMP??
Answer / s
yyyy mm dd hh mm ss nnnnnn
2 + 1 + 1 +1+ 1+ 1+ 3 = 10
Internal representation of TIMESTAMP is a string of 10
bytes. One byte for two packed decimal digits.
| Is This Answer Correct ? | 1 Yes | 2 No |
What's The Percentage Free Space ?
What is the difference between base table and view?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
why we create view.
What is lock escalation?
How would the varchar column remarks defined?
Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?
Mention the various locks that are available in db2.
How do you simulate the explain of an embedded sql statement in spufi/qmf?
Describe major components of db2?
How to find the maximum value in a column in the db2 database?
What is the use of commit in db2?