Magento 2 Patch is a package of core files that are modified that aims at fixing certain security bugs that cause security vulnerabilities that were encountered in earlier Magento versions, that is why called Magento 2 Security Patch.
There are following below table store Magento 2 Module Patches
patch_list
By Default, Magento 2 having 157 Security Patches in Database Table patch_list
There are following below difference between Offline Shipping Method and Online Shipping Method
The Online Shipping methods are those which actively consume the API of a 3rd party system owned by a shipping services provider in order to fetch the shipping cost and the information regarding the parcel’s delivery tracking
While
The Offline Shipping methods implements the shipping methods which do not involve a direct interaction with shipping carriers, so called offline shipping methods.
[2] sales_order_item :: Store [Product Details, Order ID(order_id)]
[3] sales_order_grid :: Store [Billing/Shipping Address Grand Item Price,Customer ID(customer_id), Order ID as increment_id]
[4] sales_order_address :: Store [Shipping & Billing Address, , Customer ID(customer_id)], each time store two row one for Billing address and another For shipping address while ordering any product
[5] sales_order_payment :: Store [payment details on the bases of Order ID]
[6] sales_order_status :: Store [Sales Order Status like canceled, closed, complete, fraud, holded, payment_review, Paypal Canceled Reversal, Paypal Reversed, Pending, Pending Payment, Pending Paypal, Processing]
sales_order_grid :: Store [Billing/Shipping Address Grand Item Price,Customer ID(customer_id), Order ID as increment_id]
order_id of sales_order_item Become increment_id of sales_order_grid increment_id display in
Magento 2 virtual type allows user to change the arguments of a specific injectable dependency and change the behavior of a particular class. This allows user to use a customized class without affecting other classes that have a dependency on the original.