Question: Country CREATE TABLE Statistics ( Code 2 CHAR ( 2 ) , Name VARCHAR ( 1 5 ) , Population INTEGER, Area DECIMAL ( 9
Country
CREATE TABLE Statistics
Code CHAR
Name VARCHAR
Population INTEGER,
Area DECIMAL
PRIMARY KEY Name
FOREIGN KEY Code
REFERENCES CountrYISOCode
ON DELETE RESTRICT
ON UPDATE CASCADE
The CREATE TABLE statement above creates the Statistics table. What is the result of each operation?
Deleting the row containing VUT from the Country table.
Select
Updating the ISOCode of VUT from VU to XY
Select
Deleting the foreign key VU from the Statistics table.
Select
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
