Question

Table: Artists ArtistID ArtName Elvis Ham Kool Kardash Make up a name heremake up popu Joe Nothingburger ArtPopu 62 200 0 Table: Recordings RecordingID RecPopu RecName You Hound Dog, You You Named Me Be my Valentine I am so Kool RecArtlD 30 82.3 39 13

4a) Create a new table that has one column called GoodID and 2 or 3 other columns with whatever names and data types you want. But set up a Primary Key Constraint on the

GoodID column. Use DESCRIBE to show the column definitions for your table, and paste that in here:

4b) INSERT one row into the table with GoodID equal to 13 and whatever other data (column values) you want.

4c) INSERT another row into the table with GoodID equal to something other than 13, and whatever other data you want. Do Select * and show the resulting output (two rows) here:

4d) Now INSERT one more row into the table with GoodID = 13. What happens? Show the resulting ORACLE error message here:

Answer 1

Answer:
4a) Table creation:

CREATE TABLE Testing
(
GoodID int NOT NULL,
Description varchar(30),
Quantity varchar(30),
PRIMARY KEY (GoodID)
); /*Used to create the table*/

Describe Table:

Name Null? Type NUMBER (38) VARCHAR2(30) VARCHAR2(30) GOODID NOT NULL DESCRIPTION QUANTITY

4b) Insert data into the table
Insert into Testing values(13,'Black box Testing',2);/*Inserts values into the table*/

4c)Insert into Testing values(14,'White box Testing',4);/*Inserts values to the table*/
Select * from Testing;/*Displays all the values in the table*/

GOODID DESCRIPTION QUANTITY 13 Black box Testing 14 white box Testing 4

4d)Insert into Testing values(13,'End to End Testing',5);
Below error received while trying to insert the above data.

Let me know in case if you have any doubts. Thanks and All the best.

Insert into Testing values (13, End to End Testing',5) ERROR at line 1: ORA-00001: unique constraint (SYSTEM.SYS_C0010214) violated