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, 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
Get step-by-step solutions from verified subject matter experts
