Question: As you do the exercises, unless it is stated otherwise, you will be using the tables from our standard Student- Course database. Also, as you

 As you do the exercises, unless it is stated otherwise, you
will be using the tables from our standard Student- Course database. Also,

As you do the exercises, unless it is stated otherwise, you will be using the tables from our standard Student- Course database. Also, as you do the exercises, it will be a good idea to copy/paste your query as well as your query result into a word processor. Unless otherwise directed, name all CONSTRAINTS 10-1. To test choices of type, create a table with various types like this: CREATE TABLE Test4 (name ssn dept number INTEGER, acct balance NUMBER (,2)) VARCHAR2(20), CHAR9), Then, INSERT values into the table to see what will and will not be accepted. The following data may or xxyy',2,6 xx,,yyyy,a,123456789 10-2. To test the errors generated when NOT NULL is used, create a table called Test5, which looks may not be acceptable. You are welcome to try other choices: xx'yyy' 20o0000000,5 like this: CREATE TABLE Test5 (a CHAR() NOT NULL (a b CHAR(3) INPUT some data and try to enter a null value for A. Acceptable input data for a nul is "null

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!