Fraudsters who are successful in their phishing scam may be able to

Create a stored procedure sp_Q1 that takes two country names like 'Japan' or 'USA'as two inputs and returns two independent sets

Zigmanuir [339]

Answer:

Check the explanation

Explanation:

CREATE PROCEDURE sp_Q1

"at"country1 NVARCHAR(15),

"at"country2 NVARCHAR(15)

AS

BEGIN

SELECT SupplierID, CompanyName, Phone, Country FROM suppliers

where Country in ("at"country1,"at"country2)

SELECT ProductID, ProductName, UnitPrice, SupplierID FROM Products

where SupplierID in(

SELECT SupplierID FROM suppliers

where Country in ("at"country1,"at"country2)) ORDER BY SupplierID

END

GO

-- Testing script.

DECLARE "at"RC int

DECLARE "at"country1 nvarchar(15)

DECLARE "at"country2 nvarchar(15)

-- Set parameter values here.

set "at"country1='UK'

set "at"country2='Canada'

EXECUTE "at"RC = [dbo].[sp_Q1]

"at"country1

,"at"country2

GO

Kindly check the attached images below to see how it looks like on a code editor.

7 0

3 years ago

5.17 (Calculating Sales) An online retailer sells five products whose retail prices are as follows: Product 1, $2.98; product 2,

Dima020 [189]

Answer:

import java.util.Scanner;

public class Main

{

public static void main(String[] args) {

//Initialize the prices as constants

final double PRODUCT_1_PRICE = 2.98;

final double PRODUCT_2_PRICE = 4.50;

final double PRODUCT_3_PRICE = 9.98;

final double PRODUCT_4_PRICE = 4.49;

final double PRODUCT_5_PRICE = 6.87;

//Declare the other variables

int productNumber, quantitySold;

double total = 0.0;

//Create a Scanner object to get input

Scanner input = new Scanner(System.in);

//Create a while loop

while(true){

//Ask the user to enter the productNumber

System.out.print("Enter the product number or 999 to quit: ");

productNumber = input.nextInt();

// Stop the loop, if productNumber is 999(sentinel value, you may choose any value you want)

if(productNumber == 999)

break;

//Ask the user to enter the quantitySold

System.out.print("Enter the quantity sold: ");

quantitySold = input.nextInt();

//Create a switch statement that works depending on the productNumber entered.

//For example, if the productNumber is 1, it multiplies the quantitySold by PRODUCT_1_PRICE

// and adds the result to the total. If productNumber is 2, it does the same for product 2 ...

switch(productNumber){

case 1:

total += quantitySold * PRODUCT_1_PRICE;

break;

case 2:

total += quantitySold * PRODUCT_2_PRICE;

break;

case 3:

total += quantitySold * PRODUCT_3_PRICE;

break;

case 4:

total += quantitySold * PRODUCT_4_PRICE;

break;

case 5:

total += quantitySold * PRODUCT_5_PRICE;

break;

}

//Print the total (when the loop is done)

System.out.println("The total is $" + total);

}

Explanation:

*The code is in Java.

You may see the explanation as comments in the code.

4 0

3 years ago

I NEED HELP!!! BRAINLIEST!!!

Trava [24]

Answer:

DHCP Dynamic Host Configuration Protocol:

Is a network service that automatically assigns IP addresses and other TCP/IP configuration information on network nodes configured as DHCP clients. Server allocates IP addresses to DHCP clients dynamically. Should be configured with at least one DHCP scope. Scope contains a range of IP addresses and a subnet mask, and can contain other options, such as a default gateway and Domain Name System. Scope also needs to specify the duration of the lease and usage of an IP affects after which the node needs to renew the lease with the SHCP server. Determines the duration, which can be set for a defined time period or for an unlimited length of time.

DNS Domain Name Service: Is a TCP/IP name resolution service that translates FQDNs into IP addresses. System of hierarchical databases that are stored on separate DNS servers on all networks that connect to the Internet. DNS servers store, maintains and update databases, they respond to DNS client name resolution requests to translate host names into IP addresses.

DNS Components

DNS database is divided logically into a heieratchical grouping of domains. Physically into files called zones. Zone files contain the actual IP-to-host name mapping for one or more domains. Zone files is stored on the DNS server that is responsible for resolving hot names for the domains contained in the zone. Each network node in that domain will have a host record within the domain's zone files. Includes the node's host name, FQDN, and assigned IP address.

DNS Servers

*If you are configuring static IP addresses, including the IP address of the default DNS servers as you configure each client.

*If you are using DHCP, use the DHCP scope options to specify the IP Explanation:

3 0

3 years ago

Read 2 more answers

Which of the following is an external hard drive

fredd [130]

Answer:

Question 1 = D

Explanation:

7 0

3 years ago

For the best night photographs, you’ll need to have a camera with a shutter speed of about 3 to 30 seconds

Alex_Xolod [135]

What are you trying to ask?

8 0

3 years ago