The goal is to write SQL that will CREATE the test_table1 table seen in Creating a simple table (Links to an external site.) . BUT THE TABLE WILL ALSO HAVE:

col3 to hold the exact number of characters for a social security number (which is 11 characters long)

col4 to hold a price (which should always be less than 1000, and have 2 decimal points precision)

This has to do with how the NUMBER type can specify size and precision

Given the stipulation for col4, Oracle should not let you store a value of 1000 or higher.

For those two columns, you need to choose the correct data type

Ensure your SQL keywords are capitalized and semicolon is used!

The instructor doesn't do that, but we will

If you mess up, and you create test_table1 incorrectly, you can delete the table and try the CREATE again later.

SQL Workshop > Object Browser

Click on TEST_TABLE1

Click on Drop

Question

The goal is to write SQL that will CREATE the test_table1 table seen in Creating a simple table (Links to an external site.) . BUT THE TABLE WILL ALSO HAVE:

col3 to hold the exact number of characters for a social security number (which is 11 characters long)
col4 to hold a price (which should always be less than 1000, and have 2 decimal points precision)
- This has to do with how the NUMBER type can specify size and precision
- Given the stipulation for col4, Oracle should not let you store a value of 1000 or higher.

For those two columns, you need to choose the correct data type
Ensure your SQL keywords are capitalized and semicolon is used!
- The instructor doesn't do that, but we will

If you mess up, and you create test_table1 incorrectly, you can delete the table and try the CREATE again later.
- SQL Workshop > Object Browser
- Click on TEST_TABLE1
- Click on Drop

Accepted Answer

The Answer is in the image, click to view ...

Question

The goal is to write SQL that will CREATE the test_table1 table seen in Creating a simple table (Links to an external site.) . BUT

Step by Step Solution

Step: 1

Get Instant Access to Expert-Tailored Solutions

Step: 2

Step: 3

Ace Your Homework with AI

Recommended Textbook for

Next Generation Databases NoSQLand Big Data

Students also viewed these Databases questions

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question