...

/

Quiz Yourself: Querying Multiple Tables

Quiz Yourself: Querying Multiple Tables

Test your knowledge of relationships and the types of joins.

We'll cover the following...

Querying Multiple Tables Quiz

1.

Consider the following query:

CREATE TABLE Customers
(
    Id INT PRIMARY KEY IDENTITY(1, 1),
    Name NVARCHAR(100) NOT NULL,
    Email NVARCHAR(100) NOT NULL
);

CREATE TABLE Items
(
    Id INT PRIMARY KEY IDENTITY(1, 1),
    Title NVARCHAR(100) NOT NULL,
    Description NVARCHAR(100) NULL,
    Price NUMERIC(18, 2)
);

CREATE TABLE Orders
(
    ItemId INT REFERENCES Items (Id),
    CustomerId INT REFERENCES Customers (Id),
    OrderDate DATETIME NOT NULL,
    PRIMARY KEY (ItemId, CustomerId, OrderDate)
);

(Select all that apply.) Which option(s) are foreign keys?

A.

Items.Id

B.

Orders.ItemsId

C.

Orders.CustomerId

D.

Customers.Id


1 / 5
...