Skip to main content

RDBMS Data Definition Language | Test Your Understanding 2

Image
By Astrio Jather

Test Your Understanding 2

Modify the given query appropriately in order to create the department table using the schema given below, considering the product table that you have already created.

COLUMN NAME

DATATYPE

SIZE

CONSTRAINT

dept_id

number

4

Primary key

prod_id

number

4

Foreign key

dept_name

varchar2

25

Unique

dept_head

varchar2

25

Not null



Accentur Ple Learning module answers getasnwer.blogspot.com Test Your Understanding 2 Modify the given query appropriately in order to create the department table using the schema given below, considering the product table that you have already created. COLUMN NAME DATATYPE SIZE CONSTRAINT dept_id number 4 Primary key prod_id number 4 Foreign key dept_name varchar2 25 Unique dept_head varchar2 25 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

Labels:

Comments

Post a Comment

Subscribe to Get's Answer by Email