Skip to main content

RDBMS Data Definition Language | Test Your Understanding 1

Image
By Astrio Jather

Refer the below schema, and modify the given query appropriately in order to create the product table.

COLUMN NAME

DATATYPE

SIZE

CONSTRAINT

prod_id

number

4

Primary key

prod_name

varchar2

25

 

Prod_expiry_date

date

 

Not null




Refer the below schema, and modify the given query appropriately in order to create the product table. COLUMN NAME DATATYPE SIZE CONSTRAINT prod_id number 4 Primary key prod_name varchar2 25 Prod_expiry_date date Not null Evaluation Result: Result Description Summary of tests +------------------------------+ | 3 tests run / 3 test passed | +------------------------------+


Evaluation Result:


 
Result Description
 Summary of tests
+------------------------------+
| 3 tests run / 3 test passed  |
+------------------------------+


Labels:

Comments

Post a Comment

Must Read:

Data Formats ( XML & JSON ) XML AND JSON | Generate XSD For Breakfast Menu

By Astrio Jather
  Generate XSD For Breakfast Menu Generate XSD for the given XML document <?xml version="1.0" encoding="UTF-8"?> <breakfast_menu> <food> <name>Turfle waffles</name> <price>$5.95</price> <description>This two turfle which has 2 famous product  is with real choco and maple syrup</description> <calories>650</calories> </food> <food> <name>Strawberry Belgian Waffles</name> <price>$24.6</price> <description>Light Belgian waffles covered with strawberries and whipped cream</description> <calories>900</calories> </food> <food> <name>Berry-Berry Belgian Waffles</name> <price>$4.78</price> <description>Light Belgian waffles covered with an assortment of fresh berries and whipped cream</description> <calories>400</calories> </food> <food> <name>Fried Toast</name> <pr...
Post a Comment
Read more

Subscribe to Get's Answer by Email