You want to set a constraint so that the "item_id" in the "sales" table will always have a value that already exists as "id" in the "item_master" table. Select the correct SQL statement to fill in the underlined blank of the "sales" table. Definitions:

CREATE TABLE item_master ( id INTEGER PRIMARY KEY, name TEXT ); CREATE TABLE sales ( sales_id INTEGER, item_id INTEGER, num INTEGER, ); PostgreSQL CE PGCES-02 Exam

Question

You want to set a constraint so that the "item_id" in the "sales" table will always have a value that already exists as "id" in the "item_master" table. Select the correct SQL statement to fill in the underlined blank of the "sales" table. Definitions:

CREATE TABLE item_master ( id INTEGER PRIMARY KEY, name TEXT ); CREATE TABLE sales ( sales_id INTEGER, item_id INTEGER, num INTEGER, ); PostgreSQL CE PGCES-02 Exam

Accepted Answer

B. FOREIGN KEY (item_id) REFERENCES item_master (id)

Answer

A. FOREIGN KEY (id) REFERENCESitem_master (item_id)

Answer

C. REFERENCESitem_master (item_id)

Answer

D. REFERENCESitem_master (id)

Answer

E. REFERENCESitem_master (id) TO item_id

You want to set a constraint so that the "item_id" in the "sales" table will always have a value that already exists as "id" in the "item_master" table. Select the correct SQL statement to fill in…

Question

Options

How the community answered

Community Discussion