The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.
1- does a checkpoint on the datafiles
ALTER TABLESPACE ... OFFLINE
does not perform a checkpoint, so that if the database is open, you may need to perform media recovery when bringing it online.
ALTER DATABASE DATAFILE ... OFFLINE