Question

Q11. Write SQL query to create a table 'student' with the following structure:​

Answer 1

Answer:

create table student(Admno Char(4),SName Varchar(20),Date_Of_Birth Date, Address Varchar(30));

Answer 2

Below are the query to create a table for the above data :-

Explanation:

CREATE TABLE Student ( Admno $char$(4), SName $varchar$(20), DateofBrith date, Address $varchar$(30));

• When a user executes the above query then he gets a result of a database that includes the above structure.
• It is because the above is a syntax to create a table in any database.
• But the user needs to select any database before using this query for the MYSQL database.

Learn More:

• Create a table : brainly.in/question/8476254