Task 5: Create the GET_CREDIT_LIMIT procedure to obtain the full name and credit limit of the customer whose ID currently is stored in I_CUST_ID. Place these values in the variables I_CUSTOMER_NAME and I_CREDIT_LIMIT, respectively. When the procedure is called it should output the contents of I_CUSTOMER_NAME and I_CREDIT_LIMIT.
Answers
The SQL statement that would create the GET_CREDIT_LIMIT procedure to obtain the full name and credit limit of the customer is:
GET_CREDIT_LIMIT
SELECT CUST_ID 125
FROM FIRST_NAME, LAST_NAME, CREDIT_LIMIT
WHERE LAST_NAME ="Smith"
What is SQL?This is an acronym that means Structured Query Language that is used in handling data in a database.
Hence, we can see that from the attached image, there is a table that contains the details of customers and their various data such as their first and last names, credit limits, address, etc, and the GET_CREDIT_LIMIT procedure is shown above.
Read more about SQL here:
https://brainly.com/question/25694408
#SPJ1
Related Questions
Which two settings must you configure when fortigate is being deployed as a root fortigate in a security fabric topology?
Answers
The two settings that one must configure when fortigate is being deployed as a root fortigate in a security fabric topology are:
Option A. Enables you to view the logical and physical topology of Security Fabric devices.Option C. Enables you to view the security ratings of FortiGate Security Fabric groups.What is security fabric settings?The term Security Fabric is known to be a tool that aids one or allows one's network to be able to automatically see and also dynamically isolate any kinds of affected devices.
Note that is one that can also partition network segments, update rules, and they can bring out new policies, and delete malware.
Hence, The two settings that one must configure when fortigate is being deployed as a root fortigate in a security fabric topology are:
Option A. Enables you to view the logical and physical topology of Security Fabric devicesOption C. Enables you to view the security ratings of FortiGate Security Fabric groups.See full question below
Which two Security Fabric features are on FortiManager? (Choose two.)
Select one or more:
A. Enables you to view the logical and physical topology of Security Fabric devices
B. Enables you to run security rating on FortiGate devices
C. Enables you to view the security ratings of FortiGate Security Fabric groups
D. Enables you to view and renew Security Fabric licenses for FortiGate devices
Learn more about security from
https://brainly.com/question/25720881
#SPJ1
For a direct mapped cache design with a 32-bit address, the following bits of the address are used to access the cache. assume a write through cache policy.
tag index offset
31-10 9-5 4-0
1. what is the cache block size (in words)?
2. 151 how many entries does the cache have?
3. 151 cod $5.3> what is the ratio between total bits required for such a cache implementation over the data storage bits?
address
starting from power on, the following byte-addressed cache references are recorded.
0 4 1 132 232 160 3024 30 140 3100 180 2180
4. [10 how many blocks are replaced?
5. what is the hit ratio?
6. list the final state of the cache, with each valid entry represented as a record of sindex, tag, data>
Answers
From the information given, the cache block size is 32. See explanation below.
How do we arrive at the cache block size?Where the offset is 5 bits, the block size is given as:
2⁵ = 32.
Hence, the total number of blocks in the cache is 32.
How many entries does the cache have?Note that
Total cache size = No. of entries (No. of tag bits + data bits + valid bit)
Hence,
= 32 x (22+ 256 +1)
= 8, 928 bits
Learn more about cache block at;
https://brainly.com/question/3522040
#SPJ1
define the term spread sheet
Answers
Answer:
A spreadsheet is a computer application for computation, organization, analysis and storage of data in tabular form. Spreadsheets were developed as computerized analogs of paper accounting worksheets. The program operates on data entered in cells of a table.
Explanation:
A data analyst uses the SMART methodology to create a question that encourages change. This type of question can be described how
Answers
A data analyst uses the SMART methodology to create a question that encourages change, which can be described as an action-oriented question.
What is a data analyst?A data analyst is a professional that studies information in order to obtain any type of outcome.
In computers, data analysts can use the SMART methodology which includes diverse criteria to increase the chances of success.
In conclusion, a data analyst uses the SMART methodology to create a question that encourages change, which can be described as an action-oriented question.
Learn more about data analysts here:
https://brainly.com/question/27960551
#SPJ1
scheduling is approximated by predicting the next CPU burst with an exponential average of the measured lengths of previous CPU bursts.
Answers
SJF scheduling is approximated by predicting the next CPU burst with an exponential average of the measured lengths of previous CPU bursts.
What is SJF in operating system?SJF is a term that connote Shortest Job First. It is said to be a type of CPU scheduling whose algorithm is linked with each as it is said to process the length of the next CPU burst.
Note that for one to be able to know the time for the next CPU burst to take place, one need to take the SJF into consideration as that is its function.
Hence, SJF scheduling is approximated by predicting the next CPU burst with an exponential average of the measured lengths of previous CPU bursts.
See options below
A) Multilevel queue
B) RR
C) FCFS
D) SJF
Learn more about scheduling from
https://brainly.com/question/19309520
#SPJ1
A photograph is created by what
A) Silver
B) Shutters
C) Light
4) Mirror
Answers
A photograph is created by Light.
What are photographs made of?Any photograph created is one that is made up of Support and binders.
The steps that are needed in the creation of a photograph are:
First one need to expose or bring the film to light.Then develop or work on the imageLastly print the photograph.Hence, for a person to create a photograph, light is needed and as such, A photograph is created by Light.
Learn more about photograph from
https://brainly.com/question/25821700
#SPJ1
Which window shows instructions for a lab activity?
Answers
The window that shows instructions for a lab activity is known as the Cisco Packet Tracer Activity window.
What is Packet Tracer activity?Cisco Packet Tracer is known to be a form of a comprehensive networking technology that is made for lecture and it is also a learning tool that gives a kind of a special combination that are made up of realistic simulation and visualization experiences as well as assessment, activity authoring capabilities, and others.
Hence, The window that shows instructions for a lab activity is known as the Cisco Packet Tracer Activity window.
Learn more about computer windows from
https://brainly.com/question/25243683
#SPJ1
In linux, an ____ stores everything about a file, except for the filename and the file data.
Answers
In Linux, an inode or index node stores everything about a file, except for the filename and the file data.
What is in an inode?An inode is known to be often called index node. This is known to be a data structure that pertains to UNIX operating systems that has all the vital information that is regards to files that are found within a file system.
Not that if a file system is made in UNIX, a set amount of inodes is formed and Linux often uses an index node (or inode) to save all the key or relevant information about a file.
Hence according to the above,In Linux, an inode or index node stores everything about a file, except for the filename and the file data.
Learn more about Linux from
https://brainly.com/question/25480553
#SPJ1
Have the javascript function CountingMinutes(str) take the str parameter being passed which will be two times (each properly formatted with a colon and am or pm) separated by a hyphen and return the total number of minutes between the two times. The time will be in a 12 hour clock format. For example: if str is 9:00am-10:00am then the output should be 60. If str is 1:00pm-11:00am the output should be 1320.
function CountingMinutes(str) {
// code goes here
return str;
}
// keep this function call here
console.log(CountingMinutes(readline()));
Answers
Using the knowledge in computational language in Java it is possible to write a code that function as CountingMinutes:
Writing the code in Java:function CountingMinutes(str) {
// code goes here
// Declare variables for calculating difference in minutes
// variables in JavaScript are declared with "let" keyword
/* Build regelar expression which will match the pattern of "12houttime-12hourtime"
and extract time or hours in numbers from it */
let extractedTimeStringArray = str.match(/(\d+)\:(\d+)(\w+)-(\d+)\:(\d+)(\w+)/);
// extractedTimeStringArray array will be like- ["1:00pm-11:00am", "1", "00", "pm", "11", "00", "am", index: 0, input: "1:00pm-11:00am", groups: undefined] for str = "1:00pm-11:00am"
// console.log('object', time)
// Extract array value at 1st index for getting first time's hours (ie time before hyphen like 1:00pm in 1:00pm-11:00am ) (like 11 from 11:32am) and convert them to minutes by multiplying by 60
let mintsOfFirstTimeFromHours = extractedTimeStringArray[1] * 60;
// Extract array value at 2nd index for getting first time's minutes like 32 from 11:32am
let mintsOfFirstTimeFromMints = extractedTimeStringArray[2];
// Extract array value at 4th index for getting second time's hours (ie time after hyphen like 11:00am in 1:00pm-11:00am ) and convert them to minutes by multiplying by 60
let mintsOfSecondTimeFromHours = extractedTimeStringArray[4] * 60;
// Extract array value at 5th index for getting second time's minutes like 32 from 11:32am
let mintsOfSecondTimeFromMints = extractedTimeStringArray[5];
// if second time's 12 hour time is in pm
if (extractedTimeStringArray[6] === "pm") {
// Add 12 * 60 = 720 minutes for 12 hrs
mintsOfSecondTimeFromHours += 720;
}
// if first time's 12 hour time is in pm
if (extractedTimeStringArray[3] === "pm") {
// Add 12 * 60 = 720 minutes for 12 hrs to first time
mintsOfFirstTimeFromHours += 720;
// Add 12 * 60 *2 = 1440 minutes for 24 hrs to second time
mintsOfSecondTimeFromHours += 1440;
}
// Calculate output minutes difference between two times separated by hyphen
str = (mintsOfSecondTimeFromHours - mintsOfFirstTimeFromHours) + (mintsOfSecondTimeFromMints - mintsOfFirstTimeFromMints);
// return calculated minutes difference
return str;
}
// keep this function call here
// call the function and console log the result
console.log(CountingMinutes("1:00pm-11:00am"));
// output in console will be- 1320
See more about Java at: brainly.com/question/12975450
#SPJ1
Your computer's sound stops working after updating the driver. What should you do to recover from this problem with the least amount of administrative effort
Answers
The thing to do in order to recover from this problem with the least amount of administrative effort is to Reboot the computer into Safe Mode and use Device Manager to roll back the driver.
What is a Device Driver?This refers to the computer program that is in charge of a particular type of device that controls a computer part.
Hence, we can see that based on the fact that the audio in the computer beings to malfunction after updating the device drivers, the best step to take is to Reboot the computer into Safe Mode and use Device Manager to roll back the driver.
Read more about device drivers here:
https://brainly.com/question/17151563
#SPJ1
Which selection tool should be used to fill a vacancy that requires managing multiple priorities and working under pressure
Answers
The selection tool that should be used to fill a vacancy that requires managing multiple priorities and working under pressure is Behavioral Assessment.
Why is behavioral assessment vital?Behavioral assessment is known to be that which helps us as humans to be able to look at how a person does their work and gains or get their objectives.
Therefore, The selection tool that should be used to fill a vacancy that requires managing multiple priorities and working under pressure is Behavioral Assessment because this is what it is.
See full question below
Which selection tool should be used to fill a vacancy that requires managing multiple priorities and working under pressure?
A. Cognitive Ability Test
B. Background Check
C. Behavioral Assessment
D. Academic Transcript
Learn more about Behavioral Assessment from
https://brainly.com/question/25816641
#SPJ1
Consider the following code segment: if(!somethingIsTrue()) return false; else return true; } Which one of the following statements would be an accurate replacement for this code
Answers
Based on the code segment given, the accurate replacement for the code would be C) return somethingIsTrue()
What would replace the code accurately?The code is a logical comparison code which means that it compares two or more values and returns a result based on if the comparison yields a true or false result.
The code segment, if(!somethingIsTrue()) return false; else return true; } can be replaced by return somethingIsTrue() where the result would either be true or the value for false which is much like the first code.
Options for this question include:
A) return true;B) return false;C) return somethingIsTrue();D) return !somethingIsTrue();Find out more on problems regarding code segments at https://brainly.com/question/13506144
#SPJ1
In the u. S. , what are the privacy rights that workers have with respect to emails sent or received in the workplace?
Answers
In the U. S. , what are the privacy rights that workers have with respect to emails sent or received in the workplace is that:
Workers have a little privacy protections in regards to workplace emails.What is the above case about?Email are known to be often used to send or transmit a one-way messages or be involved in two-way communication and as such;
In the U. S. , what are the privacy rights that workers have with respect to emails sent or received in the workplace is that:
Workers have a little privacy protections in regards to workplace emails.Learn more about privacy rights from
https://brainly.com/question/2857392
#SPJ1
Output values below an amount Write a program that first gets a list of integers from input. The input begins with an integer indicating the number of integers that follow. Then, get the last value from the input, which indicates a threshold. Output all integers less than or equal to that last threshold value. Assume that the list will always contain fewer than 20 integers. java
Answers
The program that first gets a list of integers from input, gets the last value from the input, which indicates a threshold, and outputs all integers less than or equal to that last threshold value is:
import java.util.Scanner;
public class LabProgram {
/* Define your methods here */
public static void main(String[] args) {
Scanner scnr = new Scanner(System.in);
int[] userValues = new int[20];
int upperThreshold;
int numVals;
numVals = scnr.nextInt();
GetUserValues(userValues, numVals, scnr);
upperThreshold = scnr.nextInt();
OutputIntsLessThanOrEqualToThreshold(userValues, numVals, upperThreshold);
}
}
Read more about java programming here:
https://brainly.com/question/26952414
#SPJ1
What type of email communication reaches out to former clients and older prospects and encourages a reply? Strategic email Onboarding email Reengagement email Promotional email
Answers
A type of email communication that reaches out to former clients and older prospects and encourages a reply is: C. reengagement email.
What is an e-mail?An e-mail is an acronym for electronic mail and it can be defined as a software application (program) that is designed and developed to enable users send and receive both texts and multimedia messages over the Internet.
In Computer Networking, a reengagement email is a type of email communication that is designed and developed to reach out to former clients and older prospects, and it encourages a reply.
Read more on e-mail here: brainly.com/question/15291965
#SPJ1
When charlie attaches a file to an email message, the computer's __________ is responsible for managing his access to the location where the file is stored.
Answers
Answer:Operating system
Explanation:
When charlie attaches a file to an email message, the computer's File Management System is responsible for managing his access to the location where the file is stored. Data files are managed using file management software systems, sometimes known as file managers or file tracking software. Even though it is made to manage individual or group files, including records, office documents, and similar data, its capabilities are somewhat limited.
How files are stored on the computer?Folders and drives both contain storage for files and folders. A storage device is a piece of equipment that can keep data safe long after the computer has been turned off. Here are a few illustrations of storage units. A device that reads and writes data to the hard disk is a hard disk drive.
For file maintenance (or management) tasks, a file management system is utilized. It is a kind of software that controls how computer systems' data files are organized. A file management system, which is meant to manage individual or group files, such as unique office papers and records, has limited capabilities.
Learn more about File Management systems here:
https://brainly.com/question/13013721
#SPJ2
When you group together related variables, the group is referred to as a(n) ____ of variables
Answers
Answer:
Array of variables
Explanation:
This occurs when you group together related variables
________ sites let users evaluate hotels, movies, games, books, and other products and services.
Answers
Social review websites avail end users an opportunity to evaluate hotels, movies, games, books, and other products and services.
What is a website?A website can be defined as a collective name which connotes a series of webpages that are interconnected or linked together with the same domain name, so as to provide certain information to end users.
What is social review?Social review can be defined as a process through which end users are availed an opportunity to evaluate various products and services that are provided by an e-commerce business firm, especially through the use of websites and over the Internet (active network connection).
In conclusion, we can infer and logically deduce that social review websites avail end users an opportunity to evaluate products and services such as hotels, movies, games, books.
Read more on website here: https://brainly.com/question/26324021
#SPJ1
The sticky notes often have strings of characters written on them that appear to be passwords. What can you do to prevent the security risk that this practice presents
Answers
Javascript and java are really just two slightly different names for the same language.
a) True
b) False
Answers
Answer:
False
Explanation:
JavaScript is language used along with html documents.
Java is a full-fledged programming language that handles applications.
Every time you call a method, the address to which the program should return at the completion of the method is stored in a memory location called the ____.
Answers
Answer:
Stack
Explanation:
Every time you call a method, the address to which the program should return at the completion of the method is stored in a memory location called the stack.
Write code to define a function named mymath. The function has three arguments in the following order: Boolean, Integer, and Integer. It returns an Integer. The function will return a value as follows: 1. If the Boolean variable is True, the function returns the sum of the two integers. 2. If the Boolean is False, then the function returns the value of the first integer - the value of the second Integer.
Answers
Answer:
public class Main
{
public static void main(String[] args) {
Main m=new Main();
System.out.println(m.mymath(true,5,2)); // calling the function mymath
}
public int mymath(boolean a,int b,int c) // mymath function definition
{
if(a==true)
{
int d=b+c;
return d;
}
else{int e=b-c;
return e;
}
}
}
What special enterprise VPN supported by Cisco devices creates VPN tunnels between branch locations as needed rather than requiring constant, static tunnels
Answers
Answer:
Dynamic Multipoint VPN
Explanation:
The telephone system is an example of a ________ network
Answers
The telephone system is an example of a circuit-switched network.
Is telephone a circuit switched network?Yes. The Traditional telephone systems such as landlines are known to be a common example of a technology that are said to often make use of the circuit switching.
Hence, The telephone system is an example of a circuit-switched network is a true statement.
Learn more about telephone from
https://brainly.com/question/917245
#SPJ1
Illuminate all lamps and leds, remove fuses, and verify that trouble signals occur when testing
Answers
Illuminate all lamps and leds, remove fuses, and verify that trouble signals occur when testing for voltage.
What tool can Technicians use to check the lighting and accessory circuits?The technician can use a Voltmeter, ohmmeter, or continuity test and this is one that can best be used to test the above circuits.
Hence, Illuminate all lamps and leds, remove fuses, and verify that trouble signals occur when testing for voltage.
Learn more about circuits from
https://brainly.com/question/2969220
#SPJ1
Why are digital computers more popular these days?
Answers
Answer:
The small size of the transistor, its greater reliability, and its relatively low power consumption made it vastly superior to the tube.
What tool allows you to search external competitive intelligence research?
Answers
Answer:
SocialPeta
Explanation:
A client discovers the address of a domain controller by making a dns query for which record?
Answers
In order for a client to discover the address of a domain controller, they can make a DNS query for the SRV record.
What is the SRV record?This refers to a record of the location of data files in a certain service being offered in a system. It is considered a Domain Name System (DNS) record which means it can be access via a DNS query.
If a client wants to discover the location of a domain controller, they can use this Domain Name System to make a query that will help them to locate the address of the domain controller from the records in the Active Directory.
Find out more on the Domain Name System (DNS) at https://brainly.com/question/12465146
#SPJ1
Write the first line of a function named Days. The function should return an integer value. It should have three integer parameters: intYears, intMonths, and intWeeks. All arguments should be passed by value.
Answers
Answer:
Program:
Module Module1
Function Days(intYears As Integer, intMonths As Integer, intWeeks As Integer) As Integer
' 1 year = 365days
' 1 month=30.417 days
' 1 week = 7 days
Days = 365 * intYears + 30.417 * intMonths + 7 * intWeeks
End Function
Sub Main()
Dim years, months, weeks As Integer
Console.Write("Enter the number of years: ")
years = Convert.ToInt32(Console.ReadLine())
Console.Write("Enter the number of months: ")
months = Convert.ToInt32(Console.ReadLine())
Console.Write("Enter the number of weeks: ")
weeks = Convert.ToInt32(Console.ReadLine())
Console.WriteLine("Days: " & Days(years, months, weeks))
Console.ReadKey()
End Sub
End Module
________ tells users how to use software and what to do if software problems occur.
Answers
Answer:
Documentation tells users how to use software and what to do if software problems occur.
Explanation:
Documents and Standard Operating Procedures (SOPs) help users use the software that they want to use. This is an advantage to whoever is selling the software so that they don't receive customer complaints and people continue to buy their product.