Exam 70-464 topic 1 question 81 discussion

Actual exam question from Microsoft's 70-464

Question #: 81
Topic #: 1

DRAG DROP -
You have two existing tables, one named COUNTRY and the other named STATES.
The tables are defined as follows:

You need to set up a rule that every STATES.Country_Abbr must match an existing record in the COUNTRY table.
Develop the solution by selecting and arranging the required code blocks in the correct order.
You may not need all of the code blocks.
Select and Place:

Show Suggested Answer

Suggested Answer:

Note:
To allow naming of a FOREIGN KEY constraint, and for defining a FOREIGN KEY constraint on multiple columns, use the following SQL syntax:
MySQL / SQL Server / Oracle / MS Access:

ALTER TABLE Orders -

ADD CONSTRAINT fk_PerOrders -
FOREIGN KEY (P_Id)
REFERENCES Persons(P_Id)

by CodeMaestro at July 12, 2020, 7:31 a.m.

Comments

Submit Cancel

Luzix

4 years, 7 months ago

< table_constraint > ::= [ CONSTRAINT constraint_name ] { {PRIMARY KEY | UNIQUE } { NONCLUSTERED (column [ ASC | DESC ] [ ,... n ]) | NONCLUSTERED HASH (column [ ,... n ] ) WITH ( BUCKET_COUNT = bucket_count ) } | FOREIGN KEY ( column [ ,...n ] ) REFERENCES referenced_table_name [ ( ref_column [ ,...n ] ) ] | CHECK ( logical_expression ) }

upvoted 1 times

...