At least two children were killed and more than a dozen injured in a mass shooting at a Catholic school in the US.