Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You are to create a table named sruDENT PROFILE With the following structure: Column Name Type Precision Scale 10 Size STUD MATRIC (Primary Key) TUD

image text in transcribed
You are to create a table named sruDENT PROFILE With the following structure: Column Name Type Precision Scale 10 Size STUD MATRIC (Primary Key) TUD NAME STUDI PHONE STUD ADDRESS STUD GENDER DOB CGPA PHOTO number varchar2 varchar?2 varchar?2 char date number blob 15 12 20 What is the SQL command for such table creation? Please note that you need to specify the STUD MATRIO column as a primary key. The primary key notation must be as part of the CREATE TABLe sou statement Next, add a column named STUD EMAIL with data type of number (precision: 10) to the STUDENT PROPILE table using a SQL statement. Next, you find that the data type of the newly added column, STUD EMAIL, is not appropriate. It should be a column of varchar2 with length of 20. Write a sQl statement to perform such task. Lastly, drop the STUDENT PROFILE table using a SQL statement

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advances In Knowledge Discovery In Databases

Authors: Animesh Adhikari, Jhimli Adhikari

1st Edition

3319132121, 9783319132129

More Books

Students also viewed these Databases questions