Answer:
def lesser_adjacent_num ( N ):
N = int( N )
while N == True:
next = N - 1
print if next >= 0 ? next : break
Explanation:
The python function above called "lesser_adjacent_num" accepts an argument called "N" which is an integer. The function print the number "next" which is a number less than the N integer for every loop for the condition where N is not zero.
Do each of the following in the main function:
a) Write the function prototype for function zero, which takes a double array big_nums and does not return a value.
b) Write the function call for the function in part a.
c) Write the function prototype for function add1AndSum, which takes an integer array one_small and returns an integer.
d) Write the function call for the function described in part c.
Answer:
a)
void zero(double big_nums[]);
b)
zero(big_nums)
c)
int add1AndSum (int one_small[]);
d)
add1AndSum(one_small);
Explanation:
a)
void zero(double big_nums[]);
in this statement:
zero is the name of the function
void is used as the function does not return a value.
The function zero takes an array parameter i.e. big_nums[]
big_nums is the name of the array
big_nums[] array has a data type double
b)
zero is the name of the function
In part a) function zero has a parameter which is the array big_nums. So in order to call this function an array has to be passed as a parameter to this function.
So in this statmenent zero(big_nums) the array big_nums is passed to the zero function. You can also declare a new double type array with a different name in main() function and can pass this to the zero function as:
double array[ ] = { 20.6, 30.8, 5.1};
zero(array);
Look at the following program for the better understanding of part a) and b)
#include <iostream> //for using input output functions
using namespace std; //to access objects like cin cout
void zero (double big_nums[]); // function prototype
int main() { //start of main() function
double a[ ] = { 20.6, 30.8, 5.1}; // double type array a with elements
zero(a); } //calls zero function passing array a to the function
void zero(double big_nums[]){ // function zero with double type array big_nums as parameter and the function returns no value
int i;
for(i=0;i<3;++i) {
cout<<big_nums[i]; } } //prints the elements of array
c)
add1AndSum is the name of the function
int is used as the function does not return an integer.
The function add1AndSum takes an integer array parameter i.e. one_small[]
one_small is the name of the array
one_small[] array has a data type int
d)
add1AndSum is the name of the function
In part c) function add1AndSum has a parameter which is the array one_small. So in order to call this function an array has to be passed as a parameter to this function.
So in this statement add1AndSum(one_small); the array one_small is passed to the add1AndSum function. You can also declare a new int type array with a different name in main() function and can pass this to the add1AndSum function.
Which option should you choose to review detailed markups within a document
Answer:
Tracking and Review features.
Explanation:
Tracking and Review are used to show detailed Markup when reviewing a document to make some changes to it.
To reveal detailed Markup, select REVIEW, then select VIEW OPTION from the Review list.
A Simple Markup shows a red line to where changes have already been made.
All Markup shows different person's edits in different colors of texts.
Gwen is starting a blog about vegetable gardening. What information should she include on the blog's home page
Answer:
The correct answer is "List of posts with the most recent ones at the top".
Explanation:
A website that includes someone else's thoughts, insights, views, etc. about a writer or community of authors and that also has photographs as well as searching the web.It indicates that perhaps the blog should distinguish between different articles about the site because then customers who frequent the site will observe and experience the articles on everyone's blogs.So that the above would be the appropriate one.
An employer plans to pay bonus to each of his employees. Those earning Rs. 2000 or above are to be paid 10 percent of their salary and those earning less than 2000 are to be paid Rs. 200. The input record contains employee number, name and salary of an employee. The output should be employee name and their bonus. Write pseudo code algorithm to process the requirement.
Answer:
vfg
Explanation:
Agile Software Development is based on Select one: a. Iterative Development b. Both Incremental and Iterative Development c. Incremental Development d. Linear Development
Answer:
b. Both incremental and iterative development.
Explanation:
Agile software development is based on both incremental and iterative development. It is an iterative method to software delivery in which at the start of a project, software are built incrementally rather than completing and delivering them at once as they near completion.
Incremental development means that various components of the system are developed at different rates and are joined together upon confirmation of completion, while Iterative development means that the team intends to check again components that makes the system with a view to revising and improving on them for optimal performance.
Agile as an approach to software development lay emphasis on incremental delivery(developing system parts at different time), team work, continuous planning and learning, hence encourages rapid and flexible response to change.
#Recall that input from a user is always in the form of a string. #Write a function called "input_type" that gets user input and #determines what kind of string the user entered. The user input #will be supplied as an argument to the function like normal. # # - Your function should return "integer" if the string only # contains characters 0-9. # - Your function should return "float" if the string only # contains the numbers 0-9 and at most one period. # - You should return "boolean" if the user enters "True" or # "False". # - Otherwise, you should return "string". #Write your function here!
Answer:
Here is the Python program:
def input_type(input_string): #function that takes a string as input and returns the type of that string
try: #used to test a block of code for input string type
if type(eval(input_string)) == float: #if the type of the string is float
return "float" #function returns float
elif type(eval(input_string)) == int: #else if the type of the string is int
return "integer"#function return integers
elif type(eval(input_string)) == bool:#else if the type of the string is bool
return "boolean" #function return boolean
except: #if the type of the string is neither int, bool nor float
return "string" #function return boolean
#following statements are used to test the working of the above function
print(input_type(" ")) #prints string
print (input_type ("False")) #prints boolean
print (input_type ("7.432621")) #prints float
print (input_type("2788"))#prints int
Explanation:
The function input_type() takes a user input and returns the type of that string input the user entered. The user input can be one of the following types:
int which is the data type of an integer for example 1, 2, 3 etc
float which is the data type of a floating point number for example 1.2, 3.4 etc
bool which is the data type of a boolean for example True or False
string that can be characters for example an empty space character " "
try block here is used to generate an exception and it is used to test a block in the code that checks for the type of the user input. The except block here is used to handle that error. This is executed when the try part raises an error.
Inside the try block, the if and elif statements check the type of the string.
if type(eval(input_string)) == float: statement checks if the type of the string is float. Here the eval() method is used to convert the input string because the user input is basically a string value. So this method evaluates the input_string.
type() method is used to return the type of that evaluated user input string. If condition checks if type(eval(input_string)) which is the type of the evaluated input string is equal to float. If this condition evaluates to true then the function returns "float" otherwise it moves to the next elif statement. Similarly the type of the user input is checked for int in elif part and if both these if and elif conditions evaluate to false then the next elif statement is executed that checks the user input to be bool. If all these three if elif statements evaluate to false then the except part executes which returns "string". The program along with its output is attached in a screenshot.
The first electric, general-purpose computer, ENIAC, was programmed by calculating algorithms on paper entering code directly into the computer flipping switches by hand using MS-DOS as the operating system
Complete Question:
The first electric, general-purpose computer, ENIAC, was programmed by?
Group of answer choices.
A. Calculating algorithms on paper.
B. Entering code directly into the computer.
C. Flipping switches by hand.
D. Using MS-DOS as the operating system.
Answer:
C. Flipping switches by hand.
Explanation:
The first electric, general-purpose computer, ENIAC, was programmed by flipping switches by hand.
ENIAC is an acronym for Electronic Numerical Integrator and Computer, it was developed in 1945 by John Mauchly and J. Presber Eckert. ENIAC was used for solving numerical problems or calculation-related tasks by the process of reprogramming.
In order to give the ENIAC a series of machine instructions to follow in the execution of a task, the programmers had to undergo the cumbersome procedure of connecting, removing, reconnecting cables and flipping switches by hand because data couldn't be stored in memory.
the property of doing work automatically by the computer
Answer:
Automation
Explanation:
Input a list of positive numbers, find the mean (average) of the numbers, and output the result. Use a subprogram to input the numbers, a function to find the mean, and a subprogram to output the result. Use a subprogram to Input the numbers, a Function to find the mean and a subprogram to output the Result.
Answer:
def inputNumber():
l = []
num = int(input("Enter the number of integers you want to enter\n"))
for i in range(0,num):
print("Enter the ", i+1, " integers ")
a = float(input())
l.append(a)
return l
def averageCalculator(l):
total = 0
for i in l:
total += i
avg = total/len(l)
return avg
def printoutput(avg):
print("The average of numbers is ", avg)
l = inputNumber()
avg = averageCalculator(l)
printoutput(avg)
Explanation:
A subprogram may be considered as a method where we pass some values in the arguments and return some value.
The answer is written in python language, where we have used
inputNumber() subprogram to get the input from the user.
function averageCalculator() to calculate the average.
printoutput() subprogram to print the output or the average of the numbers.
Please refer to the attached image for better understanding of the indentation of code.
Now, let us learn about them one by one:
inputNumber(): We get the number of values to be entered as an integer value and then get the numbers as float.
Store the values in a list and return the list to the caller main program.
averageCalculator(l): Contains a list as argument as we got from inputNumber(). It sums all the numbers and divides with total number to find the average. Returns the average value to the caller main program.
printoutput(avg): Contains an argument which is the average calculated in the averageCalculator(). It prints the argument passed to it.
А.
is the highest education degree available at a community college.
Answer:
The answer is "associate".
Explanation:
The two-year post-school degree is also known as the associate degree, in which the students pursuing any of this degree, which may take as little as 2 years to complete the course, although many prefer to do it at the same rate. Its first two years of a Bachelor (fresh and sophomore years) were covered by an Associate degree.
Discuss the different methods of authentication supported between Microsoft’s Web server (Internet Information Services) and the browsers in common use at your organization. Cover both basic authentication and Microsoft’s challenge-response scheme.
Answer:
Answered below
Explanation:
The Microsoft web server (Internet Information Services) supports the following authentication methods;
1) Basic authentication: This method uses basic authentication to restrict access to files on NTFS-formatted web servers. Access is based on user ID and password.
2) Digest authentication, which uses a challenge-response mechanism where passwords are sent in encrypted formats.
3) Anonymous authentication: In this method, the IIS creates IUSR-computerName account, to authenticate anonymous users.
4) Windows integration uses windows domain accounts for access.
5) .Net passport authentication provides users with security-enhanced access to .Net websites and services.
6) Client certificate mapping where a mapping is created between a certificate and a user account.
What are the basic characteristics of object-oriented analysis and design (OOAD)? How does OOAD compare to structured analysis and design (SAD)?
Answer:
Basic characteristics of OOAD and compression with SAD can be defined as follows:
Explanation:
The Object-oriented analysis is described as a design and analysis system like an application, that uses Oops programming. It is the measurement model, that is the presentation, which became a part of the object-based review.
The features of OOAD can be defined as follows.
The complex issues are simply solved. The operation of very fast recovery. The stability in condition changes. Its conceptual method for resolving its extremely complex problems.The difference in OOAD and SAD can be defined as follows:
The OOAD mainly focuses upon the design of objects, it can be used in highly complex logical systems, whereas the SAD focuses on data analysis systems and processes. The OOAD uses the framework to target data, but the SAD is process-oriented. It uses class and UML diagrams, but SSAD uses DFDs to extract the element, it has many limited steps to prepare and execute, but OOAD relies mostly on initial growth. This method is being developed in the course of the process.Write Album's PrintSongsShorterThan() to print all the songs from the album shorter than the value of the parameter songDuration. Use Song's PrintSong() to print the songs.
Answer:
Here is the function PrintSongsShorterThan() which prints all the songs from the album shorter than the value of the parameter songDuration.
void Album::PrintSongsShorterThan(int songDuration) const { //function that takes the songDuration as parameter
unsigned int i;
Song currSong; //object of Song
cout << "Songs shorter than " << songDuration << " seconds:" << endl;
for(int i=0; i<albumSongs.size(); i++){
currSong = albumSongs.at(i);
if(currSong.GetDuration()<songDuration){ //checks if the song duration of the song from album is less than the value of songDuration
currSong.PrintSong(); } } } //calls PrintSong method to print all the songs with less than the songDuration
Explanation:
I will explain the working of the for loop in the above function.
The loop has a variable i that is initialized to 0. The loop continues to execute until the value of i exceeds the albumSongs vector size. The albumSongs is a Song type vector and vector works just like a dynamic array to store sequences.
At each iteration the for loop checks if the value of i is less than the size of albumSongs. If it is true then the statement inside the loop body execute. The at() is a vector function that is used to return a reference to the element at i-th position in the albumSongs.
So the album song at the i-th index of albumSongs is assigned to the currSong. This currSong works as an instance. Next the if condition checks if that album song's duration is less than the specified value of songDuration. Here the method GetDuration() is used to return the value of duration of the song. If this condition evaluates to true then the printSong method is called using currSong object. The printSong() method has a statement cout << name << " - " << duration << endl; which prints/displays the name of the song with its duration.
If you see the main() function statement:
musicAlbum.PrintSongsShorterThan(210);
The musicAlbum is the Album object to access the PrintSongsShorterThan(210) The value passed to this method is 210 which means this is the value of the songDuration.
As we know that the parameter of PrintSongsShorterThan method is songDuration. So the duration of each song in albumSongs vector is checked by this function and if the song duration is less than 210 then the name of the song along with its duration is displayed on the output screen.
For example if the album name is Anonymous and the songs name along with their duration are:
ABC 400
XYZ 123
CDE 300
GHI 200
KLM 100
Then the above program displays the following output when the user types "quit" after entering the above information.
Anonymous
Songs shorter than 210 seconds: XYZ - 123
GHI - 200
KLM - 100
Notice that the song name ABC and CDE are not displayed because they exceed the songDuration i.e. 210.
Write an interactive program to calculate the volume and surface area of a three-dimensional object.
Answer:
I am writing a Python program:
pi=3.14 #the value of pi is set to 3.14
radius = float(input("Enter the radius of sphere: ")) #prompts user to enter the radius of sphere
surface_area = 4 * pi * radius **2 #computes surface area of sphere
volume = (4.0/3.0) * (pi * radius ** 3) #computes volume of sphere
print("Surface Area of sphere is: ", surface_area) #prints the surface area
print("Volume of sphere is: {:.2f}".format(volume)) #prints the volume
Explanation:
Please see the attachment for the complete interactive code.
The first three lines of print statement in the attached image give a brief description of the program.
Next the program assigns 3.14 as the value of π (pi). Then the program prompts the user to enter the radius. Then it computes the surface area and volume of sphere using the formulas. Then it prints the resultant values of surface area and volume on output screen.
The psuedocode for this program is given below:
PROGRAM SphereVolume
pi=3.14
NUMBER radius, surface_area, volume
INPUT radius
COMPUTE volume = (4/3) * pi* radius ^3
COMPUTE surface_area = 4 * pi * radius ^ 2
OUTPUT volume , surface_area
END
Software that is used to obtain private user information such as a user's keystrokes or copies of e-mail is referred to as: Question 6 options: A) botnet B) adware. C) a backdoor. D) spyware.
Answer:
The correct answer is D) Spyware.
Explanation:
Also known as a Malicious Software (or Malware for short), a Spyware is designed to gain unsolicited entrance into ones computer and when executed, performs the function of illegally stealing one's private information and sending them to the hacker or originator of the software.
The following have been identified as spyware threats:
Transponder (vx2) Hot as HellBlazeFindInternet OptimizerCheers!
What protocol communicates data between routers representing the edges of autonomous systems?Distance-vectorLink stateInterior gatewayExterior gateway
Explanation:
Exterior gateway protocol are the routing protocols that are used on the internet for exchanging routing information among the autonomous system. These autonomous systems can be gateway protocol, vector routing protocol.
The protocol that communicates data between routers representing the edges of autonomous systems is called Exterior Gateway Protocol (EGP).
Here,
An autonomous system (AS) is a collection of routers that are under a single administrative domain and have a common routing policy. These autonomous systems can be Internet Service Providers (ISPs), large organizations, or even smaller networks.
EGP is specifically designed to exchange routing information between routers that are at the edges of these autonomous systems. It allows routers in different autonomous systems to communicate with each other and share information about the best paths to reach various network destinations.
Know more about Autonomous system,
https://brainly.com/question/30240559
#SPJ6
Ann, a user, reports that she is no longer able to access any network resources. Upon further investigation, a technician notices that her PC is receiving an IP address that is not part of the DHCP scope. Which of the following explains the type of address being assigned?
A. Unicast address
B. IPV6
C. DHCP6
D. APIPA
Answer: APIPA
Explanation:
Automatic Private IP Addressing (APIPA) is a Windows based operating systems feature that allows a computer to assign itself automatically to an IP address even though there is DHCP server to perform the function.
From the information that has been provided in the question, we can see that the type of address that is used is APIPA.
what is programming code
Answer:
Such languages are used to create computer code or program code, the set of instructions forming a computer program which is executed by the computer. This source code is translated into machine code by a compiler or interpreter, so that the computer can execute it to perform its tasks.
Answer:
Writing code,” “coding,” and “programming” are basically interchangeable terms. Broadly speaking, knowing how to write code is the process of creating instructions that tell a computer what to do, and how to do it. Codes are written in various languages, such as javascript, C#, Python, and much more.
hlo samradhiki can we chat in comment section
what are the morals and ethics of computer
Answer:
Computer ethics is a part of practical philosophy concerned with how computing professionals should make decisions regarding professional and social conduct. Margaret Anne Pierce, a professor in the Department of Mathematics and Computers at Georgia Southern University has categorized the ethical decisions related to computer technology and usage into three primary influences:
The individual's own personal code.
Any informal code of ethical conduct that exists in the work place.
Exposure to formal codes of ethics.
Explanation:
why is operating system pivotal in teaching and learning
Answer:
Kindly see explanation
Explanation: The operating system is a huge part of a computer system which plays a an invaluable role in the working of computer programs, hardwares and influences the overall experience of the user. It operating system serves as the interface between the computer hardware itself and the user who may wish to perform different tasks using a computer. In other to teach and learn, it is necessary to input and also obtain output, store our files and process and most essentially one may need to install application programs or softwares, all these functions are made possible with the help of an operating system. In essence, a system without an operating system can perform very little to no function at all. So basically teaching and learning becomes difficult. Teaching and Learning tools such as video, writing and other application softwares cannot be installed without an operating system and thus teaching or learning becomes impossible in it's absence.
"The principle of ______________ states that programs tend to access data and instructions nearby recently used data and instructions."
Answer:
Locality of reference.
Explanation:
In computing, The principle of locality of reference is the probability of a processor to repeatedly access the same set of memory locations within a small time interval. This reference of locality can be spatially based (repetitive usage of data within the same location on the computer memory), or temporally based (repetitive usage of a particular data or resources within a shot time interval). The ability of some computing system to perform this action increases their predictability, and efficiency of memory hierarchy use, among other abilities.
A proper divisor of a positive integer $n$ is a positive integer $d < n$ such that $d$ divides $n$ evenly, or alternatively if $n$ is a multiple of $d$. For example, the proper divisors of 12 are 1, 2, 3, 4, and 6, but not 12. A positive integer $n$ is called double-perfect if the sum of its proper divisors equals $2n$. For example, 120 is double-perfect (and in fact is the smallest double-perfect number) because its proper divisors are 1, 2, 3, 4, 5, 6, 8, 10, 12, 15, 20, 24, 30, 40, and 60, and their sum is 240, which is twice 120. There is only one other 3-digit double-perfect number. Write a Python program to find it, and enter the number as your answer below.
Answer:
The program written in Python is as follows:
See Explanation section for line by line explanation
for n in range(100,1000):
isum = 0
for d in range(1,n):
if n%d == 0:
isum += d
if isum == n * 2:
print(n)
Explanation:
The program only considers 3 digit numbers. hence the range of n is from 100 to 999
for n in range(100,1000):
This line initializes sum to 0
isum = 0
This line is an iteration that stands as the divisor
for d in range(1,n):
This line checks if a number, d can evenly divide n
if n%d == 0:
If yes, the sum is updated
isum += d
This line checks if the current number n is a double-perfect number
if isum == n * 2:
If yes, n is printed
print(n)
When the program is run, the displayed output is 120 and 672
Write a CashRegister class that can be used with the RetailItem class that you wrote in Chapter 6's Programming Challenge 4. The CashRegister class should simulate the sale of a retail item. It should have a constructor that accepts a RetailItem object as an argument. The constructor should also accept an integer that represents the quantity of items being purchased. In addition, the class should have the following methods:
• The getSubtotal method should return the subtotal of the sale, which is the quantity multiplied by the price. This method must get the price from the RetailItem object that was passed as an argument to the constructor.
• The getTax method should return the amount of sales tax on the purchase. The sales tax rate is 6 percent of a retail sale.
• The getTotal method should return the total of the sale, which is the subtotal plus the sales tax.
Demonstrate the class in a program that asks the user for the quantity of items being purchased and then displays the sale’s subtotal, amount of sales tax and total.
Answer:
Following are the code to this question:
import java.util.*; //import package for user input
class RetailItem//defining class RetailItem
{
private String desc;//defining String variable
private int unit;//defining integer variable
private double prices;//defining double variable
RetailItem()//defining default Constructor
{
//Constructor body
}
Output:
The Sub Total value: 199.75
The Sales Tax value: 11.985
The Total value: $211.735
Explanation:
In the above code three class "RetailItem, CashRegister, and Main" is defined, in the class "RetailItem", it defines three variable that is "desc, unit, and prices", inside the class "get and set" method and the constructor is defined, that calculates its value.
In the next step, class "CashRegister" is defined, and inside the class parameterized constructor is defined, which uses the get and set method to return its value.
In the next step, the main class is declared, in the main method two-class object is created and calls its method that are "getSubtotal, getTax, and getTotal".
There is some technical error that's why full code can't be added so, please find the attached file of code.
Where in the Formula tab on the ribbon would you find the Use in Formula function?
Function library
Formula Auditing
Calculation
Defined Names
Answer:
Defined Names
Explanation:
Just did it on Edg 2020
The Formula tab on the ribbon can be found in Defined Names in formula function. The correct option is D.
What is formula tab?The formula tab is where you can insert functions, outline the name, generate the name, review the formula, and so on.
The Formulas tab on the ribbon contains critical and useful functions for creating dynamic reports. Function Library, Defined Names, Formula Auditing, and Calculation are all included.
The Formula tab is where we insert functions, define names, create name ranges, and review formulas. The Formulas tab in the ribbon contains very important and useful functions for creating dynamic reports.
The Formula command is located in the Data group on the Table Tools, Layout tab. When you open a document that contains a formula in Word, the formula automatically updates.
The Formula tab on the ribbon can be found in the formula function's Defined Names.
Thus, the correct option is D.
For more details regarding formula tab, visit:
https://brainly.com/question/20452866
#SPJ5
You are in the process of building a computer for a user in your organization. You have installed the following components into the computer in Support:AMD Phenom II X4 quad core processor8 GB DDR3 memoryOne SATA hard drive with Windows 7 installedYou need to make sure the new components are installed correctly and functioning properly. You also need to install a new SATA CD/DVD drive and make sure the computer boots successfully.Perform tasks in the following order:Identify and connect any components that are not properly connected.Use the PC tools on the shelf to test for components that are not functioning. Replace any bad components with the known good parts on the shelf.Install the required CD/DVD drive in one of the drive bays and connect the power cable from the power supply.
Answer:
i would check all connections from the hard drive and power supply and check your motherboard for any missing sauters and or loose no contact connections
Explanation:
1. Describe your Microsoft word skills that need to be improved upon the most. 2. Explain the Microsoft word skills you are most confident in performing. 3. How can your Microsoft word processing skills affect your overall writing skills on the job?
Answer:
The answer varies from person to person.
Explanation:
All kinds of people are using Word, so people would recognize if the answer if plagiarized. So, simply answer truthfully; no matter h1ow embarrasing.
The Microsoft word skills that I will need to improve upon the most is how to be faster when typing.
It should be noted that the Microsoft word skill that I am mostly confident in performing is the creation of word documents and text formatting.
Lastly, Microsoft word processing skills have affected my overall writing skills on the job as it has helped in improving my writing and grammar.
Learn more about Microsoft on:
https://brainly.com/question/20659068
If an organization’s DNS server can resolve a DNS request from its own cache, the DNS server is said to be ____.
Answer:
Answered below
Explanation:
The DNS server is said to be a caching-only DNS server.
A caching-only Domain Name System server, works by recieving queries from the client, proceeds to perform queries against other named servers, then caches the results and returns the results to the client.
Subsequent queries are resolved and returned for the specified host straight from the the cache, by the server, instead of submitting to the external server.
The advantage of this process is that it reduces traffic from outgoing DNS and speeds up the name resolution. Also, there is a reduction in the amount of query traffic.
Which type of user profile is stored in the C:\Users folder and is automatically created when a user logs on to the computer for the first time?
Answer:
a. Local user profile.
Explanation:
Local user profile is a type of user profile which is stored in the C:\Users folder and is automatically created when a user logs on to the computer for the first time and it is being stored on the local hard disk of the computer.
Generally, in Microsoft windows any change made to the local user profile is peculiar to the user and the host computer on which the change is made.
Hence, local user profiles avails several users the opportunity of sharing a single computer with their respective user settings and data.
During the name resolution process, which technique is used to avoid congestion when querying a server
Answer:
"NOT lookup " is the correct approach.
Explanation:
This methodology significantly reduces the quantity of congestion of DNS messages on a certain file. The application establishes that whenever a question reaches if it is processed. Unless the file is loaded, then perhaps the response is returned with the cached cache.Typically the name resolution occurs in something like a DNS File. The conversion usually occurs throughout this cycle from Username to IP, including IP via Username.Write a CREATE VIEW statement that defines a view named InvoiceBasic that returns three columns: VendorName, InvoiceNumber, and InvoiceTotal. Then, write a SELECT statement that returns all of the columns in the view, sorted by VendorName, where the first letter of the vendor name is N, O, or P.
Answer:
CREATE VIEW InvoiceBasic AS
SELECT VendorName, InvoiceNumber, InvoiceTotal
FROM Invoices JOIN Vendors ON Invoices.InvoiceID = Vendors.VendorID
WHERE left(VendorName,1) IN ('N' , 'O ' , 'P' )
Explanation:
CREATE VIEW creates a view named InvoiceBasic
SELECT statements selects columns VendorName, InvoiceNumber and InvoiceTotal from Invoices table
JOIN is used to combine rows from Invoices and Vendors table, based on a InvoiceID and VendorsID columns.
WHERE clause specified a condition that the first letter of the vendor name is N, O, or P. Here left function is used to extract first character of text from a VendorName column.
