Q:

Must it be a many-to-many relationship when two foreign keys occur?

This question maybe be silly, but I just want to confirm whether I get the basic understanding correctly, so:
Must it be a many to many relationship when two foreign keys occur in a table?
Or are there any other terms/reasons when two foreign keys are in a table?

A:

No.
Counter-example:
create table eg1 (
  id int primary key,
  id1 int,
  id2 int,
  foreign key (id1) references othertable.id,
  foreign key (id2) references sometable.id,
  UNIQUE INDEX `id1_UNIQUE` (`id1` ASC)
);

This is not a many-to-many relationship because id1 is unique.  It has two foreign keys, but is expressing a 1:n and a 1:1 relationship to the two other tables.

