What the phrase should say in Kim's SQL Query is; WHERE Customer = Sales Rep
<h3>What is SQL Query?</h3>
Structured Query Language (SQL) is defined as a standardized programming language that is used to manage relational databases and perform various operations on the data in them.
Now in SQL Query, when one SQL query is embedded in another SQL query to simulate a join, the second SQL query is embedded in the "WHERE" of the first query.
Since the query will pull a list of customers with outstanding orders and the sales rep for each order. Then, the where phrase will be;
WHERE Customer = Sales Rep
Read more about SQL Query at; brainly.com/question/10097523
Answer:
Automatic and Explicit Buffering.
In the case of explicit buffering, the length of the queue is provided while in automatic buffering the queue size needs to be indefinite. In automatic buffering there is no need to block the sender while coping the message. While in explicit buffering the sender is blocked for the space in queue.
No memory is being wasted in explicit buffering.
Send by Copy and Send by Reference.
By using the send by copy method, the receiver is not able to change the state of parameter while send by reference allow. The advantage of using the send by reference method is that it allows to change a centralized application to its distributed version.
Fixed-sized and Variable-sized Messages.
In fixed size messaging refers, the buffer size is fixed. This means only a particular number of messages can only be supported by the fixed size buffer. The drawback of the fixed size messages is that they must be a part of fixed size buffer. These are not a part of variable size buffer. The advantage of variable size message is that the length of the message is variable means not fixed. The buffer length is unknown. The shared memory is being used by the variable size messages.
Explanation:
