RDBMS Data Definition Language | Test Your Understanding 1

RDBMS Data Definition Language | Test Your Understanding 1

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  |
+------------------------------+

Comments