Differential equations with indefinite weight: boundary value problems and qualitative properties of the solutions