What is the SQL command to list the total sales by customer and by product, with subtotals by customer and a grand total for all product sales
Answer:
Please find the complete query and question in the attached file.
Explanation:
In this query, we use the select command in which we select the column that is "CUS_CODE, P_CODE" with the sum method that multiples the "SALE_UNITS * SALE_PRICE" values and use them as and group by the clause that stores all the values in the column that are "CUS_CODE, P_CODE WITH ROLLUP".
Write a program named guess_number.py. Use NumPy to generate a random number between 1 and 100. Accept int input and ask user to guess number. Inform if high or low. Exit when entered number correct. Tell user how many tries it took to guess number.
Answer:
download the .txt file and change the file name to guess_number.py then run it in a python interpreter. I used Python 3.9.6 for this project and I used Visual Studio Code as my IDE.
Explanation:
The code has comments that tell you what is happening.
I hope this helped :) If it didn't please let me know what went wrong so I can fix it.
In a program named guess_number.py. Use NumPy to generate a random number between 1 and 100. Accept int input and ask the user to guess the number.
What are programming used for?The motive of programming is to discover a series of commands with the intention to automate the overall performance of a task (which may be as complicated as a running system) on a computer, regularly for fixing a given problem.
Import NumPy as np def main(): # Random variety Random Number = np.random.randint(1, 100) # A begin variable Start = Try.# This value is the handiest used to decide if the person has been known that the fee is excessive or low High Or Low Message Displayed Already = False # Amount of guesses that the person were given incorrectly. Guess Gotten Wrong 0 # The general quantity of guess AmountOfGuesses = 0 # Beginning of some time loop in order to maintain the software jogging till the person guesses the random variety print("The fee is excessive") High Or Low Message DisplayedAlready = True Elif RandomNumber <= forty nine and High OrLow MessageDisplayedAlready == False:print("The fee is low")
High Or Low Message Displayed Already = True.
AmountOfGuesses += print("Wrong! You have gotten " + str(GuessGottenWrong) + " guesses incorrect. main()Read more about the program :
https://brainly.com/question/1538272
#SPJ2
What are the advantages of using a database management system (DBMS) over using file-based data storage?
Answer:
Advantage of DBMS over file system
No redundant data: Redundancy removed by data normalization. No data duplication saves storage and improves access time.
Data Consistency and Integrity: As we discussed earlier the root cause of data inconsistency is data redundancy, since data normalization takes care of the data redundancy, data inconsistency also been taken care of as part of it
Data Security: It is easier to apply access constraints in database systems so that only authorized user is able to access the data. Each user has a different set of access thus data is secured from the issues such as identity theft, data leaks and misuse of data.
Privacy: Limited access means privacy of data.
Easy access to data – Database systems manages data in such a way so that the data is easily accessible with fast response times.
Easy recovery: Since database systems keeps the backup of data, it is easier to do a full recovery of data in case of a failure.
Flexible: Database systems are more flexible than file processing systems
Suppose that a disk unit has the following parameters: seek time s = 20 msec; rotational delay rd = 10 msec; block transfer time btt = 1 msec; block size B = 2400 bytes; interblock gap size G = 600 bytes. An EMPLOYEE file has the following fields: Ssn, 9 bytes; Last_name, 20 bytes; First_name, 20 bytes; Middle_init, 1 byte; Birth_date, 10 bytes; Address, 35 bytes; Phone, 12 bytes; Supervisor_ssn, 9 bytes; Department, 4 bytes; Job_code, 4 bytes; deletion marker, 1 byte. The EMPLOYEE file has r = 30,000 records, fixed-length format, and unspanned blocking.
Answer:
20
Explanation:
I hope it helps choose me the brainst
Write the correct statements for the above logic and syntax errors in program below.
#include
using namespace std;
void main()
{
int count = 0, count1 = 0, count2 = 0, count3 = 0;
mark = -9;
while (mark != -9)
{
cout << "insert marks of students in your class, enter -9 to stop entering";
cin >> mark;
count++;
if (mark >= 0 && mark <= 60);
count1 = count1 + 1;
else if (mark >= 61 && mark <= 70);
count2 = count2 + 1;
else if (mark >= 71 && mark <= 100);
count3 = count3 + 1;
}
cout <<"Report of MTS3013 course" << endl;
cout <<"Mark" << count << endl << endl;
cout << "0-60" << "\t\t\t\t" << count1 << endl;
cout << "61-70" << "\t\t\t\t" << count2 << endl;
cout << "71-100" << "\t\t\t\t" << count3 << endl<< endl << endl;
cout << "End of program";
}
GENERATIONS OF
ACTIVITY 12
In tabular form differentiate the first four generations of computers.
Write a function gcdRecur(a, b) that implements this idea recursively. This function takes in two positive integers and returns one integer.
''def gcdRecur(a, b):
'''
a, b: positive integers
returns: a positive integer, the greatest common divisor of a & b.
'''
# Your code here
if b == 0:
return a
else:
return gcdRecur(b, a%b)
#Test Code
gcdRecur(88, 96)
gcdRecur(143, 78)
© 2021 GitHub, Inc.
Answer & Explanation:
The program you added to the question is correct, and it works fine; It only needs to be properly formatted.
So, the only thing I did to this solution is to re-write the program in your question properly.
def gcdRecur(a, b):
if b == 0:
return a
else:
return gcdRecur(b, a%b)
gcdRecur(88, 96)
gcdRecur(143, 78)
How has Linux affected the market for proprietary software?
Answer:
Linux is an operating system made up of free software, which can be installed and run on a wide variety of computer systems, from small devices such as mobile phones to large computer systems and supercomputers.
Linux is often offered to the user in various Linux distributions. A characteristic of the distributions is the great possibility of customization and selection that they offer since each one is aimed at a different type of user. Depending on the philosophy, each distribution can provide a greater foundation for ease of use, multimedia applications, ease of configuration, system simplicity, only free software, low resource requirements, and more.
Because of its low cost, high configurability and availability on various platforms, Linux is becoming increasingly popular not only among specialized users, but also among domestic users.
Which of the following is the BEST solution to allow access to private resources from the internet?
a. VPN
b. Subnet
c. Packet filters
d. FTP
Identify some advantages of using Excel over lists, paper files, or simple word documents? Describe some disadvantages of using Excel over lists, paper files, or simple word documents? Summarize one thing in you home life that could be improved or more easily managed using Excel?
Excel
Excel is a software program that contains spreadsheet. Spreadsheet is an electric document that works numbers and display results in graphs. There are vertical columns and horizontal rows.
they are several advantages of excel which is;
Excel is very efficient to use, especially when you have to calculate your data, it's not hard to calculate the computer itself calculates it for you.they are also disadvantages of excel which is;
some users might get a little bit problem when you send Microsoft Excel, here is one sometimes the spreadsheet are difficult to share internally.Your new trainee is interested in ACLs (access control lists). He asks you want they can be used for. What should you tell him? A. Protect hosts from viruses.B. Classify network traffic.C. Provide high network availability.D. IP route filtering.
Answer:
B. Classify network traffic.
D. IP route filtering.
Explanation:
An access control can be defined as a security technique use for determining whether an individual has the minimum requirements or credentials to access or view resources on a computer by ensuring that they are who they claim to be.
Simply stated, access control is the process of verifying the identity of an individual or electronic device. Authentication work based on the principle (framework) of matching an incoming request from a user or electronic device to a set of uniquely defined credentials.
Basically, authentication and authorization is used in access control, to ensure a user is truly who he or she claims to be, as well as confirm that an electronic device is valid through the process of verification
Hence, an access control list primarily is composed of a set of permissions and operations associated with a network or file.
In Computer networking, access control lists (ACLs) can be used to perform the following tasks;
I. Classify network traffic: it can be used to classify the different networks on a router and define whether packets are rejected or accepted.
II. Internet protocol (IP) route filtering: any internet protocol (IP) address that's is not on the accept list would be refused permission into accessing a network. Thus, ACLs can either deny or accept IP addresses depending on the routing table configured on the router.
What are some of the advantages and disadvantages of connection-oriented WAN/Man as opposed to connection-less?
Answer and Explanation:
Connection oriented WAN/MAN as opposed to connection less network is a type of wide area network that requires communicating entities in the network to establish a dedicated connection for their communication before they start communicating. This type of network will use these established network layers only till they release it, typical of telephone networks.
Advantages include:
Connection is reliable and long.
Eliminates duplicate data issues.
Disadvantages include:
Resource allocation while establishing dedicated connection slows down speed and may not fully utilize network resources.
There are no plan B's for network congestion issues, albeit occurring rarely with this type of network.
Fictional Corp has a DNS server running within its VPC. It has decided to move one of the application servers to a different VPC. Which of the following is a step that the cloud administrator needs to perform as part of the move?
a. Migrate to an external DNS solution
b. Create a new VPC that will serve DNS needs for multiple other VPCs
c. Discontinue using DNS
d. Remove the DNS entries within the VPC that are no longer relevant
Answer:
Here the correct option is option b Create a new VPC that will serve DNS needs for multiple other VPCs.
Explanation:
Fictional Corp has a DNS server running within its VPC. It has decided to move one of the application servers to a different VPC. It's not possible to maneuver an existing instance to a different subnet or VPC. Instead, you'll manually migrate the instance by creating a new VPC Image from the source instance.
b. Create a new VPC that will serve DNS needs for multiple other VPCs
convert 198 / 61 to ratio
I think the answer is
198:61
I'm not sure
Kareem is working on a project for his manager. He has a few questions for a co-worker who he knows is knowledgeable on the subject. As they're discussing some of the topics, he gives the co-worker permissions to the resources so they can look at the information on their own. Which of the following access control methods does Kareem's company use?
a. DAC
b. RBAC
c. MAC
d. TSAC
Answer: RBAC
Explanation:
The access control methods that Kareem's company uses us the role based access control.
The Role-based access control (RBAC) simply means assigning permissions to users based on the role that such individual plays within an organization.
RBAC is a simple approach to access management and is typically less prone to error than in a scenario whereby permissions are assigned to users individually. Access rights are given to the workers based on what their job entails and what is needed and other information which isn't needed won't be accessible to them.
Scenario You are a network engineer and it is your first day working with ASU and you have been given the job of creating a network for the IT program. You are given the following three tasks to complete. 1. Configure IP addressing settings on network devices. 2. Perform basic device configuration tasks on a router. 3. Verify Layer 3 connectivity via a routing protocol. 4. Setup some access control lists.
Select the correct answer.
What testing approach does a development team use when testing the developed code rather than just the functionality of the code?
A.
white box testing
B.
black box testing
C.
acceptance testing
D.
usability testing
Answer:
D. usability testing
Explanation:
A software can be defined as a set of executable instructions (codes) or collection of data that is used typically to instruct a computer how to perform a specific task and to solve a particular problem.
A software development life cycle (SDLC) can be defined as a strategic process or methodology that defines the key steps or stages for creating and implementing high quality software applications. There are seven (7) main stages in the creation of a software and these are;
1. Planning.
2. Analysis and requirements.
3. Software design and prototyping.
4. Development (coding).
5. Integration and testing
6. Deployment.
7. Operations and maintenance.
Usability testing is a testing technique used by a software development team to test a developed code rather than just the functionality of the code.
The main purpose of usability (user experience) testing is to determine how easy, user-friendly or difficult it is for end users (real people) to use a software application or program.
User-Defined Functions: Miles to track lapsOne lap around a standard high-school running track is exactly 0.25 miles. Define a function named MilesToLaps that takes a float as a parameter, representing the number of miles, and returns a float that represents the number of laps.Then, write a main program that takes a number of miles as an input, calls function MilesToLaps() to calculate the number of laps, and outputs the number of laps. Ex: If the inout is 1.5the output is 6.0 Ex: If the input is 2.2the output is 8.8 Your program should define and call a function Function Miles ToLaps(float userMiles) returns float userLaps 12 // Deine Milestola hert. 34 // Deine Minhert. Your code ust call llestola 5
Answer:
Explanation:
The following is written in Java. The MilesToLaps method creates a variable called laps and gives it the value of the input parameter miles divided by 0.25. Then it returns the variable laps to the user. In the main method a Scanner object was created and asks the user for the number of miles which are passed to the MilesToLaps method which returns the number of laps. This can be seen in the attached image below.
import java.util.Scanner;
class Brainly {
public static void main(String[] args) {
Scanner in = new Scanner(System.in);
System.out.println("How many miles?");
float miles = in.nextFloat();
System.out.println("This is " + MilesToLaps(miles) + " laps");
}
public static float MilesToLaps(float miles) {
float laps = (float) (miles / 0.25);
return laps;
}
}
Use the Internet to research external storage devices. Find at least three devices, with a minimum storage size of 1 terabyte (TB), from three different manufacturers. Write a paragraph, IN YOUR WORDS, for each device explaining the features and benefits. Provide the retail cost and include a reference link to each device. Next, write
Hi, you've asked an incomplete question. However, I provided suggestions on getting the desired information.
Explanation:
Considering the fact that you are required to find information about not just the cost, but also the features and benefits of three storage devices having a minimum storage size of 1 terabyte, it is recommended that you check this on a reputable e-commerce site (eg Amazon).
There you could find information about their features and benefits, as well as customer feedback about their experience using these devices.
There is an interface I that has abstract class AC as its subclass. Class C inherits AC. We know that C delegates to an object of D to perform some computations. Besides, C consists of two C1s and one C2 as subcomponents. Object of C2 is still reusable when its major component C is depleted. C1 has a method that takes in an object of E as argument. Which one is invalid
Answer:
are u in HS or college work
I am trying to understand
Select the correct statement(s) regarding PONS. a. only MMF cables can be used, since MMF enables greater data capacities compared to SMF b. PONS systems require active amplifiers, since high frequency signals attenuate quickly over distance c. PONS systems use passive devices between OLT and ONT d. all are correct statements
Answer:
The correct statement regarding PONS is:
c. PONS systems use passive devices between OLT and ONT
Explanation:
PON means Passive Optical Network. Based on fiber-optic telecommunications technology, PON is used to deliver broadband network access to individual end-customers. It enables a single fiber from a service provider to maintain an efficient broadband connection for multiple end-users (homes and small businesses). OLT means Optical Line Terminal, while ONT means Optical Network Terminal. They provide access to the PON.
In which generation of computers are we in?
This criterion is linked to a Learning OutcomeCreate checkDuplicates method that receives an array of ints, and an int as parameters. It will return true if the int is found in the array, and false if the int is NOT found in the array. Call the checkDuplicates method from both the MegaMillionsLottery constructor, and the getUserPicks() method.
Answer:
Explanation:
The MegaMillions Lottery class was not provided and neither was the getUserPicks() method. Since they were not found online either, I have created the checkDuplicates method so that it works standalone. Therefore, you can simply call the method from wherever you need by pasting the call line where it needs to be called. A test case has been created in the main method so that you can see the method in action. The output is seen in the attached image below.
public static boolean checkDuplicate(int[] myArr, int element) {
for (int x : myArr) {
if (x == element) {
return true;
}
}
return false;
}
which animal is the computer to store data information and instruction
Answer:
human is the answwr of the quest
It's currently 1:00 in the afternoon. You want to schedule the myapp program to run automatically tomorrow at noon (12:00). What two at commands could you use
Answer:
at 12 pm tomorrow
at now +23 hours
Explanation:
The at command could be used in the command line to perform a scheduled command in Unix related systems. The at command coule be ua d to program a complex script or used to perform simple scheduled reminders.
The at command is initiated by first writing the at string followed by the condition or statement to be performed.
Currently (1:00 pm) ; To make a schedule for 12pm then that will be at noon the following day:
at 12:00 pm tomorrow
Or :
Using the number of hours between the current tone and the schedule time : 12 pm tomorrow - 1:00 pm today is a difference of 23 hours ;
Hence, it can be written as :
at +23 hours
Consider a system with seven processes: E, F, G, H, I, J, K and six resources: U, V, W, X, Y, Z. Process E holds U and wants V. Process F holds nothing but wants W. Process G holds nothing but wants V. Process H holds X and wants V and W. Process I holds W and wants Y. Process J holds Z and wants V. Process K holds Y and wants X. Is this system deadlocked?
a. Yes
b. No
Answer:
a. Yes
Explanation:
System is deadlock due to process HIK. Process H holds X and wants V and W. Process I holds W and wants Y. Process K holds Y and wants X. The system will become deadlock due to these three different processes.
what is example of application of machine learning that can be imposed in eduction. (except brainly.)
Answer:
Machine Learning Examples
Recommendation Engines (Netflix)
Sorting, tagging and categorizing photos (Yelp)
Self-Driving Cars (Waymo)
Education (Duolingo)
Customer Lifetime Value (Asos)
Patient Sickness Predictions (KenSci)
Determining Credit Worthiness (Deserve)
Targeted Emails (Optimail)
What is the full form of USB ?
Answer:
universal serial bus: an external serial bus interface standard for connecting peripheral devices to a computer, as in a USB port or USB cable.
Explanation:
The process by which the kernel temporarily moves data from memory to a storage device is known as what?
Answer: Swapping
Explanation:
Swapping is referred to as the process by which the kernel temporarily moves data from memory to a storage device.
Swapping is simply a memory management scheme whereby the process can be swapped temporarily from the main memory to the secondary memory in order for the main memory to be available for other processes. Swapping is used for memory utilization.
If x=50.7,y=25.3 and z is defined as integer z,calculate z=x+y
Answer:
Ans: 76
Explanation:
z=x+y
=50•7 + 25•3
=76#
