You are to use Oracle database system to create the following database:

STUDENT table contains $4$ columns: ID$,$ NAME, GRADE and DEGREE

$*$ ID $9-$character student ID $($e$.$g$.$ CIT$081234).$

$*$ NAME $$ max. up to $30-$character student name.

$*$ GRADE $-$number$$

$*$ DEGREE $4-$character program name $($e$.$g$.$ CSBP$).$

Based on the above database, please answer the following questions in the space provided:

Q$\mathrm{.}1.$ write the SQL statement to create a new table named STUDENT with the $4$ columns described above in the description.

Q$\mathrm{.}2.$ What is the result$/$response from Oracle system if the STUDENT table created successfully?

Q$\mathrm{.}3.$ To check if a database table exists or not, one way is to display its structure.$$ What is the SQL statement to display the structure of STUDENT table?

Q$\mathrm{.}4.$ Now enter the following records into the STUDENT table:

ID$$NAME$$ GRADE$$DEGREE

CIT$080001$ TONY$$ NG$100$CSBP

CIT$059876$ ALI MOHAMED$80$ ITBP

CBA$061234$STEVE$$ ADAMS$90$ BABP

CSC$075555$ BILL$$ GATES$50$ECBP

CEE$042468$ STEVE JOBS$60$EEBP

UAE$000000$ GREY MORE$0$ BABP

Q$\mathrm{.}5.$ Write your name and ID as a comment to the table.

Q$\mathrm{.}6.$ It is a common practice to delete an old existing database table before you create a new one with the same name.$$ Please write the SQL statement to delete a table named STUDENT

Q$\mathrm{.}7.$ When you run the above SQL statement in Q$1,$ if STUDENT table does not exist, what is the result$/$response from Oracle system?