This is a very good attempt of you trying to give an answer to all the questions. We have to know that blockchain oracles are being created to serve as link or bridge that connects the outside world, that’s the physical world with the chain it self. This basically known as the off-chain and on-chain. Also, there happens to be so many types of these oracles as blockchain technology is concerned. There is the software and hardware oracle and the centralized and decentralized oracle. Which each of the above retrieves or collects data from the physical world to the blockchain network for processing and forming a smart contract at the end. There is also the inbound and outbound type of oracle which takes or collects data into and out of the blockchain as the names states. Good luck buddy