Question

SQL Question 2

Using your table from question 1:

Create a minimum of 4 INSERTS.

On one of your INSERTs, do not specify all of your columns. In other words, if you have 5 columns in your table, only mention 4 or less columns in one of your INSERTs.

Be sure to write a comment above the INSERT with less columns and explain what is missing in a full English sentence.

You should write a simple SELECT after your INSERTs to see the new data.

Question 1) (1 mark) Create your own table with a minimum of 3 columns. You must use at least 3 different kinds of data types. Example: VARCHAR2(50), NUMBER(5,2), etc.. You must declare a Primary key using an out-of-line constraint. Be sure to add a Drop Table at the top as well. Note: You cannot use any of the tables/columns used in the class slides or the demos. Your table/columns should be relatively unique (we understand some common column names will be re-used). If you have the same table/column names as another student, that will be considered to be plagiarism. Question 2) (1 Mark) Using your table from question 1: Create a minimum of 4 INSERTS. On one of your INSERTS, do not specify all of your columns. In other words, if you have 5 columns in your table, only mention 4 or less columns in one of your INSERTS. Be sure to write a comment above the INSERT with less columns and explain what is missing in a full English sentence. You should write a simple SELECT after your INSERTs to see the new data. Question 3) (1 Mark) Using your table from question 1:

Answer 1

First i will give the complete code :

drop table TableOfStudent;
create table TableOfStudent(idOfStudent integer, nameOfStudent varchar(20), gender char(1), CONSTRAINT std_id PRIMARY KEY (idOfStudent));
insert into TableOfStudent(idOfStudent, nameOfStudent, gender) values(100, "Vyshu",'M');
insert into TableOfStudent(idOfStudent, nameOfStudent, gender) values(200, "Puthus",'M');
insert into TableOfStudent(idOfStudent, nameOfStudent, gender) values(300, "Jesee",'F');
--The next insert query contains only 2 parameters . the colum named gender is missing in this insert query
--For that specify the column names only for the first two columns
insert into TableOfStudent(idOfStudent, nameOfStudent) values(400, "Hasu");

select * from TableOfStudent;

Explenation :

Q1) As in the question, I had created a table named "TableOfStudent" with 3 columns, Also the orimary key was given as out-of line constriant

Q2). It is ok to insert the data as below, if all the coumns values are present in the insert statement

insert into TableOfStudent values(300, "Jesee",'F');