Answer / s

Each column value is interpreted based on the data typed
defined for the column

Answer / sikander

In programming, classification of a particular type of
information. It is easy for humans to distinguish between
different types of data. We can usually tell at a glance
whether a number is a percentage, a time, or an amount of
money. We do this through special symbols -- %, :, and $ --
that indicate the data's type. Similarly, a computer uses
special internal codes to keep track of the different types
of data it processes.
Most programming languages require the programmer to
declare the data type of every data object, and most
database systems require the user to specify the type of
each data field. The available data types vary from one
programming language to another, and from one database
application to another, but the following usually exist in
one form or another:

What are the various locking levels available?

3 Answers  

---

What is the difference between nvl and coalesce?

0 Answers  

---

OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.

1 Answers   Syntel,

---

Can you access the DB2 Directory table using SQL?

3 Answers  

---

how do you resolve -818 error in db2. where we have to see time stamp token. i said by seeing in load module and plan .is it correct or not. give clear explination for how to see time stamp token

2 Answers   IBM, TRD,

---

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

2 Answers   IBM,

---

What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;

4 Answers   Accenture,

---

how will i display the duplicate record's from a table... i don't want to eliminate ...i want to display the duplicate record...for example in my table i have 10 record's like record no(1,2,3,4,2,9,6,1) in this ...so i want to receive duplicates...

1 Answers   UST,

---

What is Skeleton cursor table (SKCT)?

2 Answers  

---

can any one give the list of some important sql abend codes which r frequently asked in interviews?

2 Answers  

---

Name some fields from SQLCA.

2 Answers  

---

How to connect to db2 database from windows command line?

0 Answers  

---