SQL Week 1 Questions

Oracle Data Types 1 of 4

Nice! I officially had a Problem Exists Between Keyboard and Chair (PEBCAC) moment.  I erased the first question section :).
 

In an effort to interact with my blog readers and encourage a healthy learning atmosphere, I will post a few SQL questions every two weeks. At the end of each period, I will answer the questions posted.

 

The first four quiz entries will attempt to cover Oracle data types.  Understanding them is vital if you want to design and develop good databases and code.

 

Questions:

 

1. Describe the number data type. What are its arguments? How and when should it be used?
2. Describe the varchar2 data type with its arguments.
3. Describe the date and timestamp data types.  Give examples of how they should be used.