Applications of perovskite oxide thin films: microcantilevers, superconducting devices and dielectric interconnections