Answer:
Use the syntax SELECT _LIMIT_ (expression) [Column Name] to limit the result set to the number of rows defined by the expression.
Explanation:
The LIMIT keyword is often used to limit the number of rows returned in a result. Usually, the Limit expression is combined with the "SELECT column_name(s) FROM table_name...WHERE condition" can be used to limit the result set to the number of rows defined by the expression, LIMIT. The WHERE condition is optional, meaning it can be omitted.
Answer:
Soft Reset
Explanation:
A Soft Reset is a type of reset in which a gadget such as smartphones, PC, or other related gadgets undergo to refresh or reset the device or makes certain applications work or function well without user data, settings and applications.
Hence, a SOFT RESET occurs when you reset a mobile device but retain your installed applications and personal settings
Answer:
MAC Addresses (Destination and Source MAC address)
Explanation:
A switch has 3 primary functions:
- Forward frames
- Learn addresses
- Avoid loops
An Ethernet frame has the header, data and trailer and there are two specific fields in the header that helps the switch to know where to send data in future transmissions.
- destination MAC address
- source MAC address
every Ethernet frame has this and when the frame hits a switch or any device, any device can look at it ( an Ethernet frame ) and know where it is suppose to go and where it came from.
Every switch has a MAC address table where it stores MAC addresses of different computers on the network.
Example:
When a PC1 sends a frame to PC2 through a switch, the switch looks at the header of the Ethernet frame for the source mac address and adds the source MAC address to its MAC address table and also the port that it came through.
simply put:
A switch looks at the source MAC address to see if it knows it already, if it does. Great! no need to add it again to it's address table.
If it doesn't, it adds it's source address and the port that the frame came from.
This basically how the switch populates its MAC address table.