Answer:
SELECT product_name, SUM(DISTINCT quantity) AS total_quantity
RANK() OVER (PARTITION BY total_quantity ORDER BY product_name) AS rank,
DENSE_RANK () OVER (ORDER BY quantity DESC) AS dense_rank
FROM Order_items
JOIN products ON Order_items.product_id = products.product_id
GROUP BY product_id
Explanation:
The SQL query returns four columns namely, product name, total quantity, rank and dense rank. The query uses the rank and the dense rank function to return the rows according to numeric ranks.
Answer:
The output of the given program is
Peach Pear Pineapple.
Explanation:
since the value of var is so control will move to the case 3 directly and executed the statement inside the case 3 so it will print "Peach" in window after that their is no break statement in the case 3 the control moves the case 4 and executed the statement inside the case 4 so it will print "Pear" in window again there is no break statement in the case 4 the control moves the case 5 and executed the statement inside the case 5 so it will print "Pineapple".Finally, the break statement is reached the execution of the program is stopped.
Answer:
The blocking ping is not effective in an organization because it may required ping echo message from some trusted system. the best method will be to do the filtering of incoming echo ICMP messages.
In systems we have ping utility, that is based on ICMP protocol. Its function is to check the end to end connectivity of the system.
In this case a fist all an echo ICMP message is send to the host then host reply with ICMP message. to defend yourself from this flood attack, we need to filter the incoming echo ICMP packet messages. a net filter can be used to achieve it.
The best method be to applied is the firewall having a net filter with limit setting or any intrusion system. In market we have various firewall and intrusion system available to do so.
Explanation:
Solution
Ping Flood Atack:
In this attack the main of the attacker is to saturate the system with ICMP for example (internet control message protocol) traffic. as you have saturated the system, it will have less CPU time to serve others.
Defence against this attack:
In our systems we have ping utility, that is based on ICMP protocol. Its used to check the end to end connectivity of the system. here fist all an echo ICMP message is send to the host then host reply with ICMP message. to defend yourself from this flood attack , we need to filter the incoming echo ICMP packet messages. a Net filter can be used to achieve this.
The best way will be to used the firewall having net filter with limit setting or any intrusion system. In market we have various firewall and intrusion system available to do so.
Blocking ping packets to avoid ping flood attack:
Its not a good approach to block ping packets. because you may required ping echo message from some trusted system. The best option will be to do the filtering of incoming echo ICMP message.
Answer:
A matrix can only be added to (or subtracted from) another matrix if the two matrices have the same dimensions.
Explanation:
Subtracting matrices Similarly, to subtract matrices, we subtract the corresponding entries. For example, let's consider C = [ 2 8 0 9 ] C=\left[\begin{array}{rr}{2} &8 \\ 0 & 9 \end{array}\right] C=[2089] and D = [ 5 6 11 3 ] D=\left[\begin{array}{rr}{5} &6 \\ 11 & 3 \end{array}\right] D=[51163].
Answer:
Exaggerated used of the technique can produce a comical effect, while more realistic animation must time the actions exactly to produce a convincing result. Slow in and slow out. Adds more frames near the beginning and near the end of a movement, and fewer in the middle, to make the animation appear more realistic.
