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: d. the time quantum should be as small as possible.
Explanation: Round robin is a CPU scheduling algorithm. If the time quantum is extremely small, number of context switches is very high, round robin scheduling will be same as processor sharing algorithm. Then the algorithm is good. Very large time quantum will make response time of processes too much which may not be tolerated in interactive environment.
Answer:
The correct answer is d) All of these are correct.
Explanation:
ETL stands for Extract, Transform and Load. An ETL system extracts data from the sources, enforces data quality and consistency standards, conforms data so that separated and maybe unrelated sources can be used together, and as a final step delivers data in presentation-ready formats so that developers can build applications and end users can take decisions.
The len ( ) function will run with each iteration, printing the element number each time.
All options in the Advanced tab in the Share Workbook dialog box.
- Don’t keep change history
- Show comments made by all users
- Update changes when file is saved
- Track changes for certain amount of days
- Allow changes by more than one user at a time
- Automatically update changes in certain time periods
<u>Explanation:</u>
In shared workbook in advanced tab it has following options. Based on end user selection changes are applied on shares workbook.
1. Either keep the history for certain period or don’t keep the history on shared workbook.
2. On share work Save changes on period schedule (automatically update) or just see other user changes.
3. Before changes are made for share workbook either prompt for save option or last modified saved.
4. Printer review and filter setting for personal view.
