Only Few Seats Left for Advanced Certification Courses on Data Science, ML & AI by E&ICT Academy IIT Roorkee

  Apply Now

Quiz Question - SQL Create table

Create a table with below details.

Table name depart with below columns in same order.
depid of type integer with max value of 255 as auto incrementing primary key.
depname of type character string of variable-length of max length 150. It should be not null
depcity of type character string of variable-length of max length 150. It should be not null
depstreet of type character string of variable-length of max length 100. It should be not null
depopendate of type datetime

INSTRUCTIONS

Login to MySQL prompt and switch to correct database. Prepare the table creation SQL and run the SQL on the prompt.


No hints are availble for this assesment

Answer is not availble for this assesment


Note - Having trouble with the assessment engine? Follow the steps listed here

Loading comments...