Oracle 12c: SQL
3rd Edition
ISBN: 9781305251038
Author: Joan Casteel
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Transcribed Image Text
A summer camp offers a morning session and an afternoon session. The list morningList contains the names of all children attending the morning session, and the list afternoonList contains the names of all children attending the afternoon session. Only children who attend both sessions eat lunch at the camp. The camp director wants to create lunchList, which will contain the names of children attending both sessions. The following code segment is intended to create lunchList, which is initially empty. It uses the procedure IsFound (list, name), which returns true if name is found in list and returns false otherwise. FOR EACH child IN morningList { <MISSING CODE> Which of the following could replace <MISSING CODE> so that the code segment works as intended? IF (IsFound (afternoonList, child)) { A APPEND (lunchList, child)
Q29:A teacher stores the most recent quiz scores for her class in the list scores. The first element in the list holds the maximum possible number of points that can be awarded on the quiz, and each remaining element holds one student’s quiz score. Assume that scores contains at least two elements. Which of the following code segments will set the variable found to true if at least one student scored the maximum possible number of points on the quiz and will set found to false otherwise?
#Data is given in the order: Serial Number | Item Name | Quantity | Priceprice_list = [["01","Keyboard",4,200.0],["02","Mouse",4,150.0],["03","Printer",2,300.0]]
#Write Code to increase the price of all the items by 50 taka
#Code1
#Write code to add a new item to the list using user input
#Code2
print()#Print the list using nested loops
#Code3
#Sample output given below:
Enter Serial: 05Enter Item Name: MonitorEnter Quantity: 200Enter Price: 50
01Keyboard4250.0-----------------02Mouse4200.0-----------------03Printer2350.0-----------------05Monitor20050-----------------
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- 3. Create a sequence that generates integers starting with the value 5. Each value should bethree less than the previous value generated. The lowest possible value should be 0, andthe sequence shouldn’t be allowed to cycle. Name the sequence MY_FIRST_SEQ.arrow_forwardkeys = ['name', 'last', 'job_title', 'email']Faculty2 = Faculty = dict.fromkeys(keys)print(Faculty2) Use the dictionaries that you created for faculty members. Be sure that all the dictionaries have the same keys: name, last name, etc. If there are keys or values missing, add them. If you do not have the value, you can use 'n/a' or 'TBD'. Make a list of the dictionaries. Loop the list to print all the information available to each faculty member. In Python lang please.arrow_forwardCreate a sorted_grades application that can store up to 10 grades in order from highest to lowest in a list. The application should display a menu of options, which include “Enter a grade”, “Delete a grade”, “Display lowest grade”, “Display highest grade”, “Show grades”, and “Quit”. The list should initially contain all zeros (0). The algorithm for entering a grade is similar to: Find the appropriate position for the grade so that all grades are still in order from highest to lowest. Insert the grade Make certain that length of list remains the same The algorithm for deleting a grade is similar to: Find the element containing the grade to delete. If list empty tell user they can’ delete and if grade doesn’t exist, inform user no grade has been found. Use del function. Make certain the length doesn’t change and last element =0 Note: You can use the return to exit your function once you have found your element.arrow_forward
- A list named parking_tickets has been defined to be the number of parking tickets given out by the city police each day since the beginning of the current year. (Thus, the first element of the list contains the number of tickets given on January 1; the last element contains the number of tickets g iven today.) Write some code that assigns the largest value found in parking_tickets to the variable most_ tickets. You may, if you wish, use one additional variable, k. Submit History: x - (9 of 9) - 02/28/21 6:19pmarrow_forwardIf the intNums array contains six elements, which of the following statements assigns the number 6 to the intElements variable? intElements = Len(intNums) intElements = Length(intNums) intElements = intNums.Len intElements = intNums.Lengtharrow_forwardswitch_player(): we will allow the players to choose their own names, but for our purposes, it is easier to think of them as number (0 and 1, for indexing purposes). We will display their names to them on the screen, but in the background, we will keep track of them based on their number. This function should take 1 argument, an integer (either 0 or 1) representing the player and should return the opposite integer (1 if 0 is entered and 0 if 1 is entered). This is a simple function, but it will make our code cleaner later. Use your constants! Using Thonnyarrow_forward
- Instructions Each student will create two data points that correlate to their personal vehicle (or dream car!). Both points will follow the format (t, V) where t is the age of the vehicle in years, and V is the value of the vehicle in dollars at t years. The first point should relate to the initial value of the vehicle. For example, if the initial value of your car is $26,000, your first point would be (0, 26,000). Then, estimate the current value of your car (or dream car after 5 years) to create the second point. For example, if your car after 5 years was worth 19,000, your second point would be (5, 19,000). If you would like to have a more definite value of the car, use the Kelley Blue Book online! Then, use the methods we learned in class to write a linear depreciation model to represent the value of your car. Last, use your equation to determine the estimated value of your car after 9 years. Each student's post should include the following: Name of the vehicle being used in the…arrow_forwardIn PYTHON Print values from the Goal column only Print values only for columns: Team, Yellow Cards and Red Cards Find and print rows for teams that scored more than 6 goals Select the teams whose name start with a G Print values only for columns Team and Shooting Accuracy , and only for rows in which the team is either of the following: England, Italy and Spain Find and print rows for teams that scored more than 6 goals and at least 4000 passes Team Goals Shots on target Shots off target Shooting Accuracy Goals-to-shots (perc) Total shots (inc. Blocked) Hit Woodwork Penalty goals Penalties not scored Headed goals Passes Passes completed Passing Accuracy Touches Crosses Dribbles Corners Taken Tackles Clearances Interceptions Clearances off line Clean Sheets Blocks Goals conceded Saves made Saves-to-shots ratio Fouls Won Fouls Conceded Offsides Yellow Cards Red Cards Subs on Subs off Players Used Croatia 4 13 12 0.5 0.16 32 0 0 0 2 1076 828 0.769 1706 60…arrow_forwardPYTHON CODE Using Artists.csv (link below), write a query that returns all lines that are female artists only, with begin date greater than 1950 but no greater than 2000 Write a query that will return all lines of British Male artists, who's first names starts with the letter ‘A’ and has an end date earlier than 1990 Write a query that will write to a file all lines that have Japanese Artists who’s difference of end date and begin date exceeds 100 years. I.e. if artist begins in 1900 and ends in 2005, then they would be included in the output (2005-1900 = 105 years) Write a query that will write and find to a file the artist who’s been at the Museum the longest (the widest gap between Begin Date and End Date) Artists.csv: https://media.githubusercontent.com/media/MuseumofModernArt/collection/master/Artists.csvarrow_forward
- In PYTHON Print values from the Goal column only Print values only for columns: Team, Yellow Cards and Red Cards Find and print rows for teams that scored more than 6 goals Select the teams whose name start with a G Print values only for columns Team and Shooting Accuracy , and only for rows in which the team is either of the following: England, Italy and Spain Find and print rows for teams that scored more than 6 goals and at least 4000 passesarrow_forwardThe strCities array is declared using the Dim strCities(10) As String statement.The intSub variable keeps track of the array subscripts and is initialized to 0. Which of the following Do clauses tells the computer to process the loop instructions for each element in the array?a. Do While intSub < strCities.Lengthb. Do While intSub <= strCities.Length – 1c. Do Until intSub = strCities.Lengthd. all of the abovearrow_forwardLOGICAL EXPRESSIONS #15 SURGERY_DATE is a datetime column that stores the dates on which surgeries were performed. The time stored is midnight. Which of the following will return TRUE for surgeries performed in 2016 and FALSE for all other surgeries? SELECT ONE OF THE FOLLOWING A. SURGERY_DATE BETWEEN '31 DEC 2015' AND '31 DEC 2016' B. SURGERY_DATE BETWEEN '31 DEC 2015' AND '1 JAN 2017' C. SURGERY_DATE BETWEEN '1 JAN 2016' AND '31 DEC 2016' D. SURGERY_DATE BETWEEN '1 JAN 2016' AND '1 JAN 2017'arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Programming Logic & Design ComprehensiveComputer ScienceISBN:9781337669405Author:FARRELLPublisher:CengageNp Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
- Programming with Microsoft Visual Basic 2017Computer ScienceISBN:9781337102124Author:Diane ZakPublisher:Cengage Learning
Programming Logic & Design Comprehensive
Computer Science
ISBN:9781337669405
Author:FARRELL
Publisher:Cengage
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
Graphical User Interfaces: Crash Course Computer Science #26; Author: CrashCourse;https://www.youtube.com/watch?v=XIGSJshYb90;License: Standard YouTube License, CC-BY
Python GUI | How To Make A GUI In Python | Best GUI Framework In Python | Edureka; Author: edureka!;https://www.youtube.com/watch?v=_PHJvjQJa3w;License: Standard Youtube License