Flash Sale: Flat 70% + Addl. 25% Off on all Courses | Use Coupon DS25 in Checkout | Offer Expires In

  Enroll 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
depcity of type character string of variable-length of max length 150
depstreet of type character string of variable-length of max length 100
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...