Adiabatic and Isocurvature Perturbations from Inflation: Power Spectra and Consistency Relation