4. Write a PL/SQL function where a department number is passed as parameter to it. If the department number does exist, the function returns True, otherwise, it returns a FALSE value. Print the appropriate message in the calling block based on the result.
Q: In the above, we had the three concurrent processes p1, p2 and p3, each with the number s1 = 2, s2 =…
A: According to the information given:- We have to follow the instruction to perform above task.
Q: Assume a 32-bit processor, with memory pages of 4 KiB. We use a two-level page table, where the…
A: Introduction , The size of processor:- 32-bit The size of memory pages:- 4KiB
Q: Write a query that returns the Name of ALL Customers (based on CUS_FNAME and CUS_LNAME in CUSTOMER…
A: Solution
Q: How many permutations are there in the word: Chicks (Consider case sensitivity a distinction) How…
A:
Q: 11 (1) Design a Turing machine for the language of all binary strings that starts with aa and ends…
A: Turing machine: A Turing machine is an abstract computational model that performs computations by…
Q: In this assignment, you are implementing a class from a model shown here. 8 PlayingCard suit char I…
A: Algorithm for the code:- 1. Start 2. Create a PlayingCard class with a constructor that takes two…
Q: T1:R(X), T1:R(Y) T1:W(X) T2:R(X), T2:R(Y), T2:W(X), T2:W(Y) Give two examples of schedules with T1…
A: The question is solved in step2
Q: Learn about the history of the data system and how it came to be by discussing the key players and…
A: Introduction: Focus on the major persons and events that paved the way for the introduction of…
Q: Write SQL query that returns the Name of ALL employees (based on EMP_LNAME and EMP_FNAME in EMPLOYEE…
A: Answer: SQL queries=> 1) For getting EMP_NAME from EMP_FNAME and EMP_LNAME Select…
Q: the following vendors for application development tools: Please include concrete examples to support…
A: Introduction: App development software is a tool that assists in developing mobile applications by…
Q: tate what is printed by the code and justify with step by step explanation of the execution of the…
A: Consider the given code:
Q: 1. Save the program into your ASM folder and run it. 2.Write a line by line explanation (comments).…
A: Hello
Q: If we want to avoid a stalemate, what are the key differences between those two strategies?
A: Introduction: Each process waiting for a resource that is simultaneously being held by another…
Q: Do you think the "Employee Management System" proposal is a good one?
A: Introduction: An employee management system is software that helps your team meet daily corporate…
Q: Complete the following hasCycle function that takes the head of a singly linear lin input and as…
A: Lets see the solution.
Q: Compilers and assemblers can be programmed to sequence assembly language instructions in a way that…
A: Given:Compilers and assemblers can be made to arrange assembly language instructions in a specific…
Q: What process is running on TCP port 5900?
A: The process is running on TCP port 5900 is VNC i.e. Virtual Networking Computing.
Q: Assume that "name" variable contains the full name of a person, with the following format:…
A: By placing a space between each of the C parts and joining them together, str = strjoin(C) creates…
Q: gram acts as an auction house. We’ll let the users bet on x number of products. Assume the minimum…
A: Dear Student, The completed code is given below along with the fillups.
Q: Find out how well the various security options you've considered dealing with your worries about…
A: Introduction: The protection of computer systems and networks from information disclosure, theft, or…
Q: Where does testing fit into BC/DR preparation? Can you tell me how many various tests there are?
A: BC/DR: Business continuity and disaster preparedness assist an organisation survive a disaster.…
Q: How can you tell if a laptop's operating system has been tampered with?
A: A ransomware message arrives. A false antivirus notification appears. You use malicious browser…
Q: Can we define the actual roles and responsibilities of the CPU? To what do you attribute these…
A: CPU: The central processing unit (CPU), which consists of the main memory, the control unit, and the…
Q: Reference the attached zip file containing all data files and birthday_run_once.py. Q1.) Find the…
A: def hi_low_diff(*arg): low = 100000000 high =-100000000 for i in arg: if i…
Q: Write a script that asks for a user's name and age, then prints the user's name and age on the…
A: Here, We have to write a script that asks for a user's name and age, then prints the user's name and…
Q: Exercise 2 (30/40): Write a program that reads in a set of coin descriptions from a file. The input…
A: Hello sir
Q: The two main types of computer memory—ROM and RAM—are what keep a PC running smoothly.
A: Both random access memory (RAM) and read-only memory (ROM) are present on your computer. RAM is…
Q: the following vendors for application development tools: Please include concrete examples to support…
A: INTRODUCTION: A software development toolkit, also known as an SDK, is a collection of separate…
Q: Show Show Show Show Create an HTML code for this; default images will appear. If you click the "Show…
A: The HTML Code is given below according to the instructions Output screenshot is also given
Q: How many integers in the range 11 through 200 (inclusive) are multiples of 22 or 55?
A: The question is solved in step2
Q: Write a Python program to check that a string contains only alphabets and numbers (a-z, A-Z and…
A: Algorithm of the code:- 1. Start 2. Take a string as input from the user 3. Set a boolean variable…
Q: 1] Write a simple C/C++ program that shows that C/C++ does not check the index range for static…
A: In Programming, Static and dynamic scoping which refers to the Static scope is also called lexical…
Q: Think about how the internet has changed over time, as well as the current technological…
A: The objective is to explain the evolution of the Internet. In 1965, two computers at MIT Lincoln…
Q: CLK ·lo D₁ C +++ Figure 1 Do ▷ C D₂ C ·l₂ Using the asynchronous ripple counter in Figure 1 and…
A: Worst-case: It provides the algorithm's resource requirements at their maximum. When it comes to…
Q: 8. 9. Lael wants a quick way to look up students by their Student ID. In cell Q3, nest the existing…
A: Here is the solution for the first two questions: The formulas that are required for the CELL Q3:…
Q: Is there any advantage to using asynchronous programming techniques over more conventional ones? Is…
A: Approaches to asynchronous programming provide the following benefits: 1. Improved responsiveness…
Q: Assume a 32-bit processor, with memory pages of 4 KiB. We use a two-level page table, where the…
A: The size of processor:- 32-bit The size of memory pages:- 4KiB
Q: Convert the following NFA to DFA. Make sure describe all 5 components esulted DFA. For the DFA's…
A: Introduction: A deterministic finite automaton (DFA), also known as a deterministic finite acceptor…
Q: Create an HTML code for this; default images will appear. If you click the "Show in Picture One"…
A: The HTML code is given below with output screenshot The pictures are centered
Q: For an online learning platform, how might you go about determining what kind of training is…
A: The question is solved in step2
Q: Bernie is an aspiring video game developer. Learning which of the following software would benefit…
A: Game developer:- A game developer is a software engineer, programmer, or computer scientist who…
Q: The data tablet has resolutions comparable to those of a CRT monitor while using significantly less…
A: Explanation: While maintaining the same level of resolution as a CRT display, the data tablet device…
Q: e 4 most popular programming languages of 2022 are: 1. Python 2. Javascript 3. Java…
A: Answer to Step 1 Source Code: #print statement print("The 4 most popular programming languages of…
Q: How many B bit strings that either start with 101 or have a 6th bit equal to 1 for both] can we…
A: The number of string with the weight five is equal to 56.
Q: Solve: GCD(408,85)
A: These question answer is as follows,
Q: What is the return type for the following method?
A: Dear Student, The answer to your question is given below -
Q: Explain Linux and its features in your own terms. If you can, please be as detailed as possible.
A: Every iteration of the Linux operating system manages hardware resources, executes and maintains…
Q: The distinction between scalar and superscalar processors could be better understood with the aid of…
A: Introduction: Scalar processors and superscalar processors are two of the many possible varieties of…
Q: What is NETBIOS and NETBEUI?
A: Definition: Network Basic Input Output System offers session layer services connected to the OSI…
Q: Describe how trademark ownership could interfere with a person's right to free speech in the context…
A: The question is solved in step2
**WRITE IN SQL**
Step by step
Solved in 3 steps with 2 images
- 1. Write a PL/SQL program using an explicit cursor that displays all patients PLCO_ID numbers from the colo_proc_data table on the screen if the patients’ procedure is biopsy, the procedure is staging, interval status of linked cancer is never screened, the procedure type is invasive Scopes, biopsies, & surgeries, the procedure type is Lymphadenectomy/Lymph Node Sampling, and the procedure result is abnormal, confirmed metastasis.INFO 2303 Database Programing Assignment # : PL/SQL Procedure & Function Practice Note: PL/SQL can be executed in SQL*Plus or SQL Developer or Oracle Live SQL. Write a function that takes patient date of birth. If the patient born after 30th June 1990 then he/she will be required to set appointment for immunization. Call this function from anonymous block to allow the user to enter the patient ID. Expected output: Enter the patient ID: 168 The status of X-immunization : REQUIREDDevelop a two small PL/SQL programs. 1. Enter students ID from the keyboard. The program then finds student's first name, last name and phone, stores them in variables and prints them on the screen. 2. Similar to the above, only this time the program will receive student's first name only (instead of student's ID)Then program finds full name and address and prints it on the screen. For both programs please implement NO_DATA_FOUND and TOO_MANY_ROWS exceptions. (please refer to chapter 8 in PL/SQL by Example book)For number 2 program, display a message "Possibly you have two or more students with the first name ...." in TOO_MANY_ROWS exception block.
- Write a PL/SQL Function that accepts 4 integers, 2 representing the homeTeamID and visitorTeamID, and the other 2 representing the score for each team during a game : htscore and vtscore The function will determine which team won the match and return the teamID of the winning team. You can achive this by comparing htscore > or < then vtscore.. if htscore is bigger then return hteamID or else return vteamID. If the game was a tie (the 2 scores are the same value) return a 0.Computer Science This question is related to pl/SQL:- Using a Cursor in a Package In this assignment, you work with the sales tax computation because the Brewbean's lead programmer expects the rates and states applying the tax to undergo some changes. The tax rates are currently stored in packaged variables but need to be more dynamic to handle the expected changes. The lead programmer has asked you to develop a package that holds the tax rates by state in a packaged cursor. The BB TAX table is updated as needed to reflect which states are applying sales tax and at what rates. This package should contain a function that can receive a two-character state abbreviation (the shopper's state) as an argument, and it must be able to find a match in the cursor and return the correct tax rate. Use an anonymous block to test the function with the state value NC.Assignment : PL/SQL Practice Note: PL/SQL can be executed in SQL*Plus or SQL Developer or Oracle Live SQL. Write an anonymous PL/SQL block that will update the salary of all doctors in the Pediatrics area by 1000 (Note: Current salary + 1000). Verify that the salary has been updated by issuing a select * from doctor where area = ‘Pediatrics’. You may have to run the select statement twice to check the data before and after the update.
- Develop a PL/SQL block that would go through all the employees from EMPLOYEES table who work in department id= 90 (there is suppose to be 3 employee who work in Department 90)- IN BEGIN END END SECTION; Execute 3 separate of SELECT statement one after the other. Each SELECT will pull first name. salary of each employee and store them in local variables.+ SELECT LOAD INTO v_firstname1, v_salarxlWHERE emrlexee.id=100 Then second WHERE emploxee.id3101+ SELECT first_name, salary INTO v_firstname2, v_salary2 Then third + SELECTSELECTI tirst.name, salary INTO v_firstname3, v_salary3 iin WHERE emploxee id=102 ..... You must now have 6 local variables. DECLARE all of them accordingly in DECLARE section and use them in BEGIN and END.+ Then add another SELECT statement in BEGIN-END to find company average salary SELECT xa(salary) INTO aKasal FROM EMPLOYEES; !!! Do not forget to create y avgsal local variable in DECLARE section.INFO 2303 Database Programming Assignment : PL/SQL Practice Note: PL/SQL can be executed in SQL*Plus or SQL Developer or Oracle Live SQL. Question: Write an anonymous PL/SQL block that will delete all patients for doctors that works in the Family Practice Verify that patients have been deleted accordingly. Then do a select * from patients where doc_id = (select doc_id from doctor where area = ‘Family Practice’. You should get no rows. Patietn table: CREATE TABLE PATIENT(PT_ID NUMBER(3),PT_LNAME VARCHAR2(15),PT_FNAME VARCHAR2(15),PTDOB DATE,DOC_ID NUMBER(3),NEXTAPPTDATE DATE,LASTAPPTDATE DATE,CONSTRAINT PATIENT_PT_ID_PK PRIMARY KEY (PT_ID),CONSTRAINT PATIENT_DOC_ID_FK FOREIGN KEY(DOC_ID)REFERENCES DOCTOR); INSERT INTO patient VALUES(168, 'James', 'Paul', TO_DATE('14-MAR-97'), 432, TO_DATE('01-JUL-03'), TO_DATE('01-JUN-03'));INSERT INTO patient VALUES(331, 'Anderson', 'Brian', TO_DATE('06-MAR-48'), 235,TO_DATE('01-JUL-03'), TO_DATE('01-JUN-03'));INSERT INTO patient…This is a database system question regarding SELECT: Which of the following statements is true for SELECT statements in general? a. HAVING is executed before WHERE when running an SQL query b. SELECT is executed before FROM when running an SQL query c. Each SELECT clause must have a WHERE clause as well. d. COUNT(column_name) function returns the number of values in the column, including any NULLs e. HAVING clause specifies a condition for selecting grouped tuples from the GROUP BY clause.
- INFO 2303 Database Programming Assignment : PL/SQL Practice Note: PL/SQL can be executed in SQL*Plus or SQL Developer or Oracle Live SQL. Write an anonymous PL/SQL block that will delete all patients for doctors that works in the Family Practice Verify that patients have been deleted accordingly. Then do a select * from patients where doc_id = (select doc_id from doctor where area = ‘Family Practice’. You should get no rows.Develop a PL/SQL block that would go through all the employees from EMPLOYEES table who work in department_id= 90 (there is suppose to be 3 employee who work in Department 90) IN BEGIN END END SECTION; Execute 3 separate of SELECT statement one after the other. Each SELECT will pull first_name , salary of each employee and store them in local variables. SELECT LOAD INTO v_firstname1, v_salary1 WHERE employee_id=100 Then second SELECT first_name, salary INTO v_firstname2, v_salary2 ….. WHERE employee_id=101 Then third SELECT, SELECT first_name, salary INTO v_firstname3, v_salary3 ….. WHERE employee_id=102 You must now have 6 local variables. DECLARE all of them accordingly in DECLARE section and use them in BEGIN and END. Then add another SELECT statement in BEGIN-END to find company average salary SELECT avg(salary) INTO v_avgsal FROM EMPLOYEES; !!! Do not forget to create v_avgsal local variable in DECLARE section.database development write a function and funcation call program in PL/SQL to sum the even integers between 1 and any number that is passed as a parameter in a function