difference between candidate key and foreign key in sql ?

Question

I am not able

Answer 1

create table persons
(
personid int not null,
name varchar (30),
primary key (personid)
)

create table orders
(
orderid int not null,
name varchar (30),
personid int not null,
primary key (orderid),
foreign key (personid) references persons(personid)
)