Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The SQL instruction CREATE TABLE T1 (A1 CHAR(5) NOT NULL, A2 INTEGER NOT NULL, A3 CHAR(5), PRIMARY KEY (A1), FOREIGN KEY (A2) REFERENCES T2, ON

The SQL instruction


CREATE TABLE T1

(A1 CHAR(5) NOT NULL, 

A2 INTEGER NOT NULL,

A3 CHAR(5),

PRIMARY KEY (A1),

FOREIGN KEY (A2) REFERENCES T2,

ON DELETE SET DEFAULT);


(a) It creates the table T1 in which any delete operation on either T1 or T2 violating the referential integrity constraint causes the insertion of default values in the corresponding attributes of the other table


(b) It creates the table T1 in which any delete operation on T2 violating the referential integrity constraint causes the insertion of default values in the corresponding T1 attributes


(c) none of the answers are correct


(d) It creates the table T1 in which any delete operation on T1 violating the referential integrity constraint causes the insertion of default values in the corresponding attributes of T2

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Concepts of Database Management

Authors: Philip J. Pratt, Mary Z. Last

8th edition

1285427106, 978-1285427102

More Books

Students also viewed these Databases questions

Question

licensure as a psychologist in the respective jurisdiction; and

Answered: 1 week ago

Question

Describe the purpose of the product process in relational algebra.

Answered: 1 week ago