Question: Country CREATE TABLE Statistics ( Code 2 CHAR ( 2 ) , Name VARCHAR ( 1 5 ) , Population INTEGER, Area DECIMAL ( 9

Country
CREATE TABLE Statistics (
Code2 CHAR (2),
Name VARCHAR(15),
Population INTEGER,
Area DECIMAL (9,2),
PRIMARY KEY (Name),
FOREIGN KEY (Code2)
REFERENCES CountrY(ISOCode2)
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 ISOCode2 of VUT from VU to XY.
Select
Deleting the foreign key VU from the Statistics table.
Select
 Country CREATE TABLE Statistics ( Code2 CHAR (2), Name VARCHAR(15), Population

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!