Answer:
CREATE VIEW [product_summary] AS
SELECT product_id , order_count , order_total FROM Product;
SELECT * FROM [product_summary] ;
Explanation:
- First of all, use the CREATE VIEW syntax to create a view named product_summary that includes the product_id, order_count, order_total columns and returns the summary information about each product.
- Use SELECT statement to return all the columns from the product_summary view.
Answer:
C
Explanation:
Joe should backup all his data from his old mobile device to his PC and then import all the data to his new device via PC. This is the fastest way for transferring data than all the other options mentioned. Most of the time the devices with different OS cannot connect via Bluetooth so option B is not suitable here. If we talk about logging in to same email provider on the new device, it might work but it'll take a lot of time to transfer data to a new device since the data is been copied through internet. If Joe has a strong internet connection than it might be a suitable option for him but what if the connections breaks down in middle of transfer? Similarly NFC also uses internet connection, but that's not only the problem with NFC, like Bluetooth, NFC also works with similar OS devices. Apart from that NFC only transfers small payloads of data.
Microsoft Excel or another spreadsheet program.
