I am having trouble understanding the Tor functor as presented in Dummit and Foote.
Given $\dotsb\to P_n\to P_{n-1}\to\dotsb\to P_0\to B\to 0$ as a projective resolution with homomorphisms $d_i:P_n\to P_{n-1}$.
The book defines projective resolution as an exact sequence as above with each $P_i$ being a projective module.
An exact sequence is defined as a sequence such that for each $P_i$ in our sequence, $\ker(d_n)={\rm im}(d_{n+1})$.
We then tensor each module with the module $A$, giving $\dotsb\to A\otimes P_n\to\dotsb\to A\otimes P_0\to A\otimes B\to 0$ and related homomorphisms, $1\otimes d_n:A\otimes P_n\to A\otimes P_{n-1}$.
The definition in Dummit and Foote says $\operatorname{Tor}_n^R(A,B)=\ker(1\otimes d_n)/{\rm im}(1\otimes d_{n+1})$.
Is $\dotsb\to A\otimes P_n\to\dotsb\to A\otimes P_0\to A\otimes B\to 0$ always exact? It feels like it is not, since if it was exact, it would be fairly uninteresting.
Assuming it is not exact, what does $\operatorname{Tor}_n^R(A,B)$ look like? In other words, how are $\ker(1\otimes d_n)$ and ${\rm im}(1\otimes d_{n+1})$ different?
Specifically I am trying to figure out this problem (Given a torsion $R$-module $A$ where $R$ is an integral domain, $\mathrm{Tor}_n^R(A,B)$ is also torsion.), but I clearly am having trouble understanding the definitions, so recalling them is not really helping me.
Edit: Let's also assume that I will want to solve other problems involving the $\operatorname{Tor}$ functor, so I want to understand it in general and not just well enough to answer the linked question.
"Fairly uninteresting" is an understatement: if the tensored complex were always exact, then every $\text{Tor}$ would be identically zero! The question "what does $\text{Tor}$ look like?" is rather vague, but let me give a proposition which may shed some light, and also gives a different approach to your linked question: $\newcommand{\Tor}{\text{Tor}}$
Proposition: Let $R$ be a Noetherian reduced ring. Then every $\Tor^R_i(\_, \_)$ for $i \ge 1$ is a torsion $R$-module.
Proof: Let $A, B$ be any $R$-modules. To show that $\Tor^R_i(A,B)$ is torsion, it suffices to show that $\Tor^R_i(A,B) \otimes_R Q(R) = 0$, where $Q(R)$ is the total ring of quotients of $R$ (i.e. $Q(R) = S^{-1}R$, where $S$ is the set of nonzerodivisors in $R$). But $Q(R)$ is flat over $R$ (being a localization), so $\Tor^R_i(A,B) \otimes_R Q(R) \cong \Tor_i^{Q(R)}(A \otimes_R Q(R), B \otimes_R Q(R))$, which vanishes for every $i \ge 1$, since $R$ reduced $\implies Q(R)$ is a finite direct product of fields $\implies Q(R)$ has global dimension zero.
In particular, one can deduce that over Noetherian reduced rings, the torsion modules are precisely the modules of the form $\Tor_i(\_, \_)$ for $i \ge 1$ (one can even take $i = 1$).