All categories

3 years ago

Using SQL

Computers and Technology

1 answer:

lesantik [10]3 years ago

7 0

Answer:

Following are the code to this question:

/*using the select statement, that selects column name from the table blog.posts */

SELECT blog.posts.user_id, blog.posts.body, users.name/*column name user_id, body, name*/

FROM blog.posts/* use table name blog.posts*/

RIGHT OUTER JOIN users ON blog.posts.user_id = users.id;/*use right join that connect table through user_id*/

Explanation:

In the structured query language, RIGHT JOIN is used to recovers from both the right side of the table both numbers, although the left table has no sets. It also ensures that even if the 0 (null) documents are linked inside this left table, its entry will always return the outcome row, but still, the number of columns from its left table will be NULL.

In the above-given right join code, the select statements used that selects the column names "user_id, body, and the name" from the table "blog. posts" and use the right join syntax to connect the table through the id.

You might be interested in

We have an internal webserver, used only for testing purposes, at IP address 5.6.7.8 on our internal corporate network. The pack

lukranit [14]

Answer:

Check the explanation

Explanation:

A packet filter firewall is used as a check point between internal corporate network to the outside internet. It blocks all the inbound traffic from the outside hosts trying to initiate a direct TCP connection to the internal corporate webserver. The network design with firewall is shown in the attached image below:

The figures in the attached image below shows an internal corporate network is protected with a packet filter firewall to minimize the inbound traffic from the external network or an internet. Therefore, the packet filter is used as a check point between the network.

The packet filter blocks all attempts by the outside hosts in order to initiate a direct TCP connection to the internal webserver of the internal corporate network.

Going by the second part of the attached image below can can therefore conclude that:

• Rule 1 specifies that, deny any packet with the destination address 5.6.7.8 if the STN flag of TCP header is set.

• Rule 2 specifies that, allow the inbound email traffic from the external source.

• Rule 3 specifies, allows the Outbound TCP traffic from the internal corporate network.

• Rule 4 specifies, allows outbound Email traffic from the internal corporate network to the external network.

• Rule 5 specifies, block any traffic from any source to the any destination.

3 0

3 years ago

What is the Multiple Source Test

Goshia [24]

A source is where you can look to find info. Multiple means many or some.

Therefore, a multiple source test is a test that you can find the answers in multiple sources, such as a book, article, journal, etc.

7 0

3 years ago

Read 2 more answers

Which of the following is where you can save, select a template, change document properties, and close or exit excel?

Aneli [31]

It is the 'backstage' in which you can save, select a template, change document properties, and close or exit excel

5 0

3 years ago

Write a Python function called validateCreditCard that takes 8-digit credit card number as the input parameter (string value) an

babunello [35]

Answer:

def validateCreditCard(x):

if type(x)==str and len(x) == 8:

print("Valid credit card number")

else:

print("Invalid credit card number")

validateCreditCard("43589795")

Explanation:

Run the code on your text editor(vs code, sublime, pycharm ) you will get your desired response. If your input is not of type string and not up to 8 digit you will get the response "invalid credit card number" but if it is of type string and up to 8 digit you will get "Valid credit card number".

But remember python works with indentation so when you are transferring this code to your text editor it will run properly well.

I defined the code using the conventional pattern "def"

After defining the function you create a brackets (x) to accommodate your argument x and end it with a semi colon.

Then i use "if" statement to make sure only string argument and 8 digit value will be accepted to print a "valid credit card". if your argument does not pass the if statement condition it will print out the else statement condition which is "Invalid credit card number"

Finally, you have to call your function and test various values.

6 0

3 years ago

A penetration testing manager is contributing to an RFP for the purchase of a new platform. The manager has provided the followi

pochemuha

The manager has provided the following requirements Password cracker:

E. Password cracker

Explanation:

MITM is used to protect from hackers where they can hack the web site and misused the data. Basically man is in middle that monitors the network traffics between to tcpip and address and login as unauthorized person.

As RFP is a bidding process for purchase new product or new platform with complete document in details.

End user has to take care of hackers attack and make sure it is protected with all security holes.

Fuzzer is tool where send user data and check the security vulnerabilities and make sure it is protected.

It is not considered as high accuracy.

5 0

3 years ago