1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Romashka [77]
3 years ago
13

1. Create an anonymous block that will count the number of students whose gr_t1 grade is higher than the average on gr_t1 and di

splay that number. Test the program
Computers and Technology
1 answer:
sweet [91]3 years ago
4 0

Answer:

The Anonymous Block will be:

 1 DECLARE

 2  

 3  lv_grade_row grade%rowtype;

 4  lv_gr_avg grade.gr_t1%type;

 5  lv_std_name varchar2(80);

 6  cursor cursor_grade is select * from grade;

 7

 8  BEGIN

 9

10  select avg(gr_t1) INTO lv_gr_avg from grade;

11  open cursor_grade;

12  fetch cursor_grade INTO lv_grade_row;

13

14  while cursor_grade%found loop

15

16  if

17  lv_grade_row.gr_t1>lv_gr_avg then lv_std_name :=  

lv_grade_row.std_fname|| ' ' ||lv_grade_row.std_lname|| ' ' ||

lv_grade_row.gr_t1;

18  dbms_output.put_line(lv_std_name);

19

20  end if;

21  fetch cursor_grade into lv_grade_row;

22

Explanation:

You might be interested in
State the difference between IBM PC and apple machintosh computers
azamat

Answer:

a Mac is a PC because PC stands for personal computer. However, in everyday use, the term PC typically refers to a computer running the Windows operating system, not the operating system made by Apple.

7 0
3 years ago
You have installed a wireless network at your house but all of a sudden, your computer and devices are unable to connect to the
vladimir1956 [14]

The steps that you need to take to troubleshoot the problem and correct it so that connectivity is restored is

  • First Unplug or power off one's  router.
  • Then stay for about two to five minutes before one can plug it back in.
  • The stay for five more minutes and do retry the connection.

<h3>What troubleshooting meaning?</h3>

Troubleshooting is known to be a kind of a systematic method that is often used to problem-solving and this is known to be one that is often used in order to see, find and correct problems that are known to be with complex machines, computers, software systems and others.

Troubleshooting is said to be a kind of problem solving, often used to repair what we call a failed products or processes.

Therefore, The steps that you need to take to troubleshoot the problem and correct it so that connectivity is restored is

  • First Unplug or power off one's  router.
  • Then stay for about two to five minutes before one can plug it back in.
  • The stay for five more minutes and do retry the connection.

Learn more about wireless network from

brainly.com/question/26956118

#SPJ1

7 0
1 year ago
What kind of loop should be used in a game where the user is guessing a secret code and the message"guess again" appears until t
GenaCL600 [577]

Answer:

While loop

Explanation:

It should be noted that the number of times which the computer will ask the user to take a guess is not known.

When we have a condition like this, the while loop (or in some programs; the do-while loop) is to be used.

To further back my point, see the following program in python.

<em>secret_code = 1234</em>

<em>user_guess = int(input("Take a guess: "))</em>

<em>while user_guess != secret_code:</em>

<em>     user_guess = int(input("guess again: "))</em>

<em>print("You guessed right")</em>

<em />

The above program will keep asking the user to take a guess until the user enters 1234.

<em>This may or may not be possible with a for loop.</em>

3 0
3 years ago
The device-aspect-ratio feature supported by Hypertext Markup Language (HTML) and Cascading Style Sheets (CSS) gives the ratio o
iogann1982 [59]

Answer:

True.

Explanation:

The aspect-ratio function is stated as a value < ratio > tag that representing the viewport aspect ratio of thickness to length. It is a range function, implying the lowercase minimum-aspect-ratio and maximum-aspect-ratio versions can also be used to request the lowest and highest amounts, accordingly.

so, the following scenario is true.

7 0
3 years ago
What is depth of field? How can you adjust the depth of field in a photograph?
jarptica [38.1K]
First, you want to reduce the light so you can use a wider aperture then, zoom the lens in to enlarge the subject and move a little closer to the subject finally, switch to aperture-priority mode and select a large aperture like f/4 
6 0
3 years ago
Other questions:
  • Obtain the 10’s complement of the following six-digit decimal numbers:<br><br> 123900<br><br> 980657
    10·1 answer
  • As computers become faster, memory access speeds are not keeping pace. Question 5 options: True False
    7·1 answer
  • You are writing a report using a template provided by your supervisor. If you increase the margins around your pages by 30 perce
    5·1 answer
  • The point at coordinates (2, -18) is in what direction from the origin?
    13·1 answer
  • When you select Insert and click on a shape the mouse pointer turns into a/an
    12·2 answers
  • I like potatoes do you like potatoes
    15·2 answers
  • A query can have many Highly Meets results. True or False
    5·2 answers
  • Zahra's softball team needs money for team T-shirts. The coach makes some fundraising suggestions, while team members brainstorm
    5·2 answers
  • PLEASE WRITE A ONE SENTANCE SUMMARY, WILL GIVE BRAINLIEST!! (history of computers) You have completed an extensive investigation
    10·1 answer
  • A _____ is relatively inexpensive to install and is well-suited to workgroups and users who are not anchored to a specific desk
    14·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!