CREATE TABLE DBDesigner ID CHAR (7), Name VARCHAR2 (15), PRIMARY KEY (ID) ); CREATE TABLE DesignTask...

Transcribed Image Text:

CREATE TABLE DBDesigner ID CHAR (7), Name VARCHAR2 (15), PRIMARY KEY (ID) ); CREATE TABLE DesignTask ID CHAR(5), DesignerID CHAR (7), Priority VARCHAR (20), PRIMARY KEY (ID), FOREIGN KEY (DesignerID) REFERENCES DBDesigner (ID) ); Consider the following data in DBDesigner 1234567 Eric Schwabe 3456789 Janine Spears 5678901 Will Marrero 7890123 Cynthia Putnam and the following data in DesignTask 11111 1234567 Urgent 22222 1234567 Low 33333 5678901 Low 44444 7890123 High If you were to insert the following statement INSERT INTO DBDesigner VALUES ('3456789', 'Bruce Wayne'); What will happen? Error. Violates referential integrity constraints Error. Violates domain constraints No error. Does not violate nay constraint. Error. Violates uniqueness constraints. CREATE TABLE DBDesigner ID CHAR (7), Name VARCHAR2 (15), PRIMARY KEY (ID) ); CREATE TABLE DesignTask ID CHAR(5), DesignerID CHAR (7), Priority VARCHAR (20), PRIMARY KEY (ID), FOREIGN KEY (DesignerID) REFERENCES DBDesigner (ID) ); Consider the following data in DBDesigner 1234567 Eric Schwabe 3456789 Janine Spears 5678901 Will Marrero 7890123 Cynthia Putnam and the following data in DesignTask 11111 1234567 Urgent 22222 1234567 Low 33333 5678901 Low 44444 7890123 High If you were to insert the following statement INSERT INTO DBDesigner VALUES ('3456789', 'Bruce Wayne'); What will happen? Error. Violates referential integrity constraints Error. Violates domain constraints No error. Does not violate nay constraint. Error. Violates uniqueness constraints. CREATE TABLE DBDesigner ID CHAR (7), Name VARCHAR2 (15), PRIMARY KEY (ID) ); CREATE TABLE DesignTask ID CHAR(5), DesignerID CHAR (7), Priority VARCHAR (20), PRIMARY KEY (ID), FOREIGN KEY (DesignerID) REFERENCES DBDesigner (ID) ); Consider the following data in DBDesigner 1234567 Eric Schwabe 3456789 Janine Spears 5678901 Will Marrero 7890123 Cynthia Putnam and the following data in DesignTask 11111 1234567 Urgent 22222 1234567 Low 33333 5678901 Low 44444 7890123 High If you were to insert the following statement INSERT INTO DBDesigner VALUES ('3456789', 'Bruce Wayne'); What will happen? Error. Violates referential integrity constraints Error. Violates domain constraints No error. Does not violate nay constraint. Error. Violates uniqueness constraints. CREATE TABLE DBDesigner ID CHAR (7), Name VARCHAR2 (15), PRIMARY KEY (ID) ); CREATE TABLE DesignTask ID CHAR(5), DesignerID CHAR (7), Priority VARCHAR (20), PRIMARY KEY (ID), FOREIGN KEY (DesignerID) REFERENCES DBDesigner (ID) ); Consider the following data in DBDesigner 1234567 Eric Schwabe 3456789 Janine Spears 5678901 Will Marrero 7890123 Cynthia Putnam and the following data in DesignTask 11111 1234567 Urgent 22222 1234567 Low 33333 5678901 Low 44444 7890123 High If you were to insert the following statement INSERT INTO DBDesigner VALUES ('3456789', 'Bruce Wayne'); What will happen? Error. Violates referential integrity constraints Error. Violates domain constraints No error. Does not violate nay constraint. Error. Violates uniqueness constraints.

Answer rating: 100% (QA)

Ans d Error Violates uniqueness constraints b Error Violates domain constraints Here Db design... View the full answer