does the database sql file include drop tables?

i wonder what the sql file produce
when i do a manually backup, i usually check ‘add drop table’

what exactly happens when i backup the database with backwpup?
what options includes when backing the database up?

https://wordpress.org/plugins/backwpup/