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
valentinak56 [21]
4 years ago
13

Create the SQL statements for displaying the results for each of the following scenarios in the Academic Database. Save these st

atements in a script called M07_LastNameFirstName_Functions (where LastName is your last name and FirstName is your first name). Run/execute these commands in Oracle Application Express. Based on data in the Academic Database, complete the following:
1. Display the number of students that are eligible for exams.
2. Display the number of students that had a grade of 70 or above.
3. Display the highest exam score that Nina received.
4. Display the least number of days off.
5. Display the average exam grade received by each student.
6. Display the average exam grade for the OOAD course.
Computers and Technology
1 answer:
Whitepunk [10]4 years ago
4 0

Answer:

CREATE FUNCTION exam_eligible_students

   RETURN NUMBER AS

   num_students NUMBER(15);

BEGIN

   SELECT COUNT(STUDENT_ID)

   INTO num_students

   FROM STUDENT_ATTENDANCE

   WHERE ELIGIBILITY_FOR_EXAMS = 'Y';

   

   RETURN (num_students);

END;

Explanation:

exam_eligible_students is a made of name for the FUNCTION to be called.

num_students is a made up name for the RETURN to be called. The RETURN name is referenced in the INTO statement and as the name of the the return in the RETURN line in ().

You might be interested in
If you are to enhance the ICT used by your teachers, how will ypu do it? Will you use the same ICT or will you modify how it was
tekilochka [14]

To enhance the ICT (Information Communication Technology) used by teachers, I will modify how the ICT was integrated.

The modification of how ICT is integrated will change the culture that places teaching over technology.  Then, teachers will be taught how to use ICT to:

  • improve learning so that teachers become learning facilitators
  • motivate learners by fostering learning autonomy, making students less dependent on the teacher
  • engage the learners by creating collaborative learning
  • diminish content learning so that students learn to think, create, and communicate effectively
  • make learning a lifetime culture
  • enhance the learning environment so that teachers become collaborators and co-learners with students.

Thus, I will enhance the ICT used by teachers by modifying its integration to achieve better results for both teachers and learners.

Learn more about the importance of ICT here: brainly.com/question/13724249

7 0
3 years ago
User 2.0 is most likely to Multiple Choice passively read and search for content. depend on content creators and avoid expressin
Ahat [919]

User 2.0 is most likely to: use the Internet for social connection.

<h3>What is User 2.0?</h3>

User 2.0 which is an aspect of Web 2.0 defines the latest form of the internet that allows users to interact with each other. This form of the internet is easy to use and requires participation by users.

So, a possible feature of User 2.0 will be the ability to use the internet for socialization.

Learn more about User 2.0 here:

brainly.com/question/3913924

5 0
3 years ago
Who do politicians listen to?
horrorfan [7]

Answer:

they dont realy listen to anybody

Explanation:

6 0
4 years ago
Which magazie can help the public determine the best technology to use
wariber [46]
Well you can read about technology in maybe tec company magazines like apple magazines or samsung magazines on which are best to buy Hope this helps:)
3 0
4 years ago
A small company is requesting a quote to refresh its wireless network. The company currently runs 60 autonomous APs and has plan
Annette [7]

Answer:

A small company is requesting a quote to refresh its wireless network. The company currently runs 60 autonomous APs and has plans to increase wireless density by 50% in the near future. The requirements state that the chosen solution should significantly decrease the management overhead of the current wireless network. The following should be recommended by the vendor in response to the quote request:

B. The use of autonomous APs with a wireless controller.

Explanation:

  • The option A  and D are not correct as the use of lightweight APs are not required here because they are already using autonomous APs which are fulfilling their needs.
  • The option B is correct as the use of autonomous APs with a wireless controller will allow them to decrease the management overhead as the wireless controller is used to manage the Access points in larger quantities.
  • The option C is incorrect as the load balancers are used to increase the capacity and reliability of applications as they distribute the traffic over number of servers so it is unable to decrease the management overhead.  
6 0
4 years ago
Other questions:
  • propose,two new ,proudly South African ways,which you can visualize that the IoT,can be used at work to make life better.
    12·1 answer
  • Ruby is creating a presentation. She wants each slide displayed at intervals of five seconds. Which feature in the presentation
    6·2 answers
  • Design and implement a java program (name it CheckPoint) that prompts the user to enter the x-coordinate and y-coordinate of a p
    6·1 answer
  • How does a content management system differ from a basic wysiwyg web authoring tool??
    11·1 answer
  • Computer is created by aliens?!
    14·1 answer
  • The CPU converts into information. The CPU is the mastermind of the computer, controlling everything that goes on through a seri
    12·2 answers
  • Out of all the social media tools available today, the best tool to start when beginning your social marketing efforts is which
    14·1 answer
  • Can anyone provide a good java program that shows how to implement a button?
    11·2 answers
  • Which addresses represent valid local loopback addresses? check all that apply.
    7·1 answer
  • What is the accurate description
    12·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!