Chapter 3 Solutions
Review Questions
1. Which command is used to create a table based upon data already contained in an existing table? CREATE TABLE command with a subquery
2. List four datatypes supported by Oracle10g, and provide an example of data that could be stored by each datatype. DATE – 20-JAN-99, VARCHAR2 – HELLO, NUMBER – 5.23, CHAR - HELLO
3. What are the guidelines you should follow when naming tables and columns in Oracle10g? A maximum of 30 characters are allowed, the first character…
Words 887 - Pages 4