The SQL statement that would create the GET_CREDIT_LIMIT procedure to obtain the full name and credit limit of the customer is:
GET_CREDIT_LIMIT
SELECT CUST_ID 125
FROM FIRST_NAME, LAST_NAME, CREDIT_LIMIT
WHERE LAST_NAME ="Smith"
<h3>What is SQL?</h3>
This is an acronym that means Structured Query Language that is used in handling data in a database.
Hence, we can see that from the attached image, there is a table that contains the details of customers and their various data such as their first and last names, credit limits, address, etc, and the GET_CREDIT_LIMIT procedure is shown above.
Read more about SQL here:
brainly.com/question/25694408
#SPJ1
<u>The most important job duty of a software developer is to develop a product/program that is easy to use and melts a customer’s need.</u>
<u></u>
Explanation:
Some other duties of a Software developer are
- Researching,designing and implementing new software program's and then managing them
- Testing and evaluating the developed software program's
- Identifying errors in the existing program's and modifying the same
- Writing effective codes
- employing various software tools
- Training new users
- Working closely with the other developers
Answer:
All the ports in a hub are in the same collision domain and a hub sends frames from one host to all other hosts in the network. This makes it prone to collision and poor network throughput. Just like a network switch, it uses the CSMA/CD protocol to detect collision in its network.
A network switch reduces its collision domain to just a port and sends frames from one host to another using its mac table as a route. This makes the network very efficient with high throughput. It also uses the CSMA/CD protocol to detect collision
Explanation:
Switches and hubs are used in networking to connect computer devices in a network. A hub is an obsolete device networking that broadcast a frame to all other ports or host in the network except for the send host port. This increases the rate of collision as all the ports in a hub share the same collision domain. A switch is an efficient frame switching device in a network, which uses its MAC table to decide and find a destination host.
CSMA/CD is a collision detection protocol used in a network to detect and prevent a collision. With this protocol, a host is able to listen, wait, send and resend frames to prevent a collision.
Answer:
1. Scripts area is the main working area in Scratch.
2. Sensing blocks are color-coded light blue.
3. Adware is a malware which pops up a window, informing the user that the system is infected and asks for a fee to clean it.
4. Amaya is a WYSIWYG.