Who is a data base administrator

The ____ aggregate function finds the largest value

NemiM [27]

The MAX aggregate function.

MAX aggregate function returns the maximum value of an expression over a group of rows. It can be used as an analytic or an aggregate function. Aggregate function MAX can operate with Boolean values or can be converted to a Boolean.

6 0

3 years ago

In what medium do web applications operate?

ki77a [65]

Answer

web browser

Explanation:

5 0

2 years ago

Write a program that determines a student's letter grade. Allow the user to enter three test scores. The maximum score on each t

Elina [12.6K]

Answer:

public class Grade {

public static void main (String [] args) {

int sum = 0, avg = 0;

char grade = 'x';

Scanner input = new Scanner(System.in);

System.out.print("Enter the test scores: ");

for(int i=1; i<=3; i++) {

int testScore = input.nextInt();

sum += testScore;

}

avg = sum/3;

if(avg >= 90) {

grade = 'A';

}

else if(avg>= 80 && avg < 90) {

grade = 'B';

}

else if(avg>= 70 && avg < 80) {

grade = 'C';

}

else if(avg>= 60 && avg < 70) {

System.out.print("Enter the number of homeworks turned in: ");

int homeworksTurnedIn = input.nextInt();

System.out.print("Enter the total number of homeworks: ");

int totalHomeworks = input.nextInt();

if((homeworksTurnedIn / (double)totalHomeworks) > 0.8) {

grade = 'D';

}

else

grade = 'F';

}

else if(avg < 60) {

grade = 'F';

}

System.out.println("Your grade is: " + grade);

}

Explanation:

- Initialize the variables

- Ask the user for the test scores

- Inside the for loop, calculate the sum of the test scores

- Then, find the average of the scores

- Depending on the average, print the grade

6 0

3 years ago

Create a dictionary that maps a fruit name to its color. Both the keys and the values should be stored as strings. Include only

UkoKoshka [18]

Answer:

Written in Python:

fruit_dictionary = {}

fruit_dictionary = {'apple': 'red', 'orange': 'orange', 'banana': 'yellow'}

Explanation:

First (although, not necessary), we create an empty dictionary named fruit_dictionary on line 1

Next, we populate the dictionary using the following syntax:

{key-1:value-1, key-2:value-2,......,key-n:value-n}

In this case, the entry would be:

{'apple': 'red',

'orange': 'orange',

'banana': 'yellow'}

The items on the first column (i.e. apple, orange and banana) are the keys while the items on the second (i.e. red, orange and yellow) are the values of the dictionary

To print the items in the dictionary, you can add the following line of code:

print(fruit_dictionary.items())

6 0

3 years ago

What is the service provided by a third party (such as an ISP) that enables you to connect another cloud directly to your Google

Olenka [21]

Answer:

A. Dedicated interconnect

Explanation:

With dedicated interconnect, there is a direct connection between your network and that of Google. It enables you to connect another cloud directly to your Google cloud resources to create hybrid cloud solutions. In other words, Dedicated Interconnect enables hybrid networking. Businesses can now extend their own private cloud into Google's cloud so they can switch control between the two with little latency. This gives them (businesses) control over the amount of data entering into the two clouds.

8 0

4 years ago