question 25 In the following procedure, the parameter n is an integer greater than 2.PROCEDURE compute nresult <+ 1j+ 2REPEAT UNTILj >result < result + jj+j + 1RETURNresultWhich of the following best describes the value returned by the procedure? Which of the following best describes the value returned by the procedure?AThe procedure returns nothing because it will not terminate.The procedure returns the value of 2 * n.The procedure returns the value of n * n.The procedure returns the sum of the integers from 1 to n.

Answered: Image /qna-images/answer/c257c81b-0381-4076-9ec1-2cacd8bab38e.jpg

In the following procedure, the parameter n is an integer greater than 2. PROCEDURE compute n result <+ 1 i+ 2 REPEAT UNTIL (j > n result + result + j j+j + 1 RETURN result Which of the following best describes the value returned by the procedure?

In the following procedure, the parameter n is an integer greater than 2. PROCEDURE compute n result <+ 1 i+ 2 REPEAT UNTIL (j > n result + result + j j+j + 1 RETURN result Which of the following best describes the value returned by the procedure?

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Q.No.1. Write the SQL queries. (10) Employee: Deptno Address Empno Emp_name Salary Rawalpindi Ali 5,000 10,000 25,000 D1 DIE1 D1 Islamabad D2E2 Alia D2 Lahore D3E3 Usman 1. Display detail of all employees from Employee table. Answer: 2. Display name of employees, who are working in D1. Answer: 3. Add bonus of 500 to all employee's salary. Answer: 4. As we can see department no. 1 is repeated in the table, display the unique department number. Answer:
How can you concatenate columns in a query?
What is the function of a column qualifier? When do you have to use one?
SUPPLIERS SID SNAME STYPE LOCATION 1 Lulu DS Salalah 2 C4 DS Saadah 3 Smile WS Awqad PRODUCTS PID DESC PRICE SID QTY 801 Pencil 3 1 10 802 A4 6 2 15 803 Ballpen 4 2 804 Marker 2 3 20 Display the PID and Description of products who has the same supplier as product 802. (use subquery)
Task 7: The StayWell marketing team considers sending small gifts to all residents and owners. To decrease the postal costs, they will send gifts to owners in batches to their corresponding offices. Similarly, the marketing team will send the gifts in groups to the residents living in the same property. Therefore, you will need to provide them the number of gifts for each StayWell office and number of gifts for each property. The column headers for the first table should be OFFICE_NUM and GIFTS, the column headers for the second table should be PROPERTY_ID and GIFTS.
Question 14 A fair is visited by at least one visitor. One visitor visits at least one fair. A Visitor Fair Visitor Visitor Fair Visitor Fair
C) Which employees earn less salary than the average salary for the consultants who perform the same job? Show the employees first and last names, job id, salary, department name, and manager's last name. Sort the result by the employees’ employee id. D) For each department, find the manager who pays out the most in salaries. Show the department number, the manager's last name, and the total she/he pays each month. Sort by the department number. Here are the tables and the columns within the table Here are the tables and the columns within the table CONSULTANTS - CONSULTANT_ID- FIRST_NAME- LAST_NAME- EMAIL- PHONE_NUMBER- HIRE_DATE- JOB_ID- SALARY- COMMISSION_PCT- MANAGER_ID- DEPARTMENT_ID . COUNTRIES - COUNTRY_ID- COUNTRY_NAME-REGION_ID . CUSTOMERS - CUST_IDCUST_EMAILCUST_FNAMECUST_LNAMECUST_ADDRESSCUST_CITYCUST_STATE_PROVINCECUST_POSTAL_CODECUST_COUNTRYCUST_PHONECUST_CREDIT_LIMIT . DEPARTMENTS - DEPARTMENT_IDDEPARTMENT_NAMEMANAGER_IDLOCATION_ID . EMPLOYEES -…
In an ORDER BY clause, what are the two ways to refer to the columns to be used for sorting the results of the query?
What is the name of the columns of thee left hand side of the relationships between columns called?
How are the column heading labels in a result table changed?
SQL: Dog DataIn each question below, you will define a new table based on the following tables.CREATE TABLE parents ASSELECT "abraham" AS parent, "barack" AS child UNIONSELECT "abraham" , "clinton" UNIONSELECT "delano" , "herbert" UNIONSELECT "fillmore" , "abraham" UNIONSELECT "fillmore" , "delano" UNIONSELECT "fillmore" , "grover" UNIONSELECT "eisenhower" , "fillmore";CREATE TABLE dogs ASSELECT "abraham" AS name, "long" AS fur, 26 AS height UNIONSELECT "barack" , "short" , 52 UNIONSELECT "clinton" , "long" , 47 UNIONSELECT "delano" , "long" , 46 UNIONSELECT "eisenhower" , "short" , 35 UNIONSELECT "fillmore" , "curly" , 32 UNIONSELECT "grover" , "short" , 28 UNIONSELECT "herbert" , "curly" , 31;CREATE TABLE sizes ASSELECT "toy" AS size, 24 AS min, 28 AS max UNIONSELECT "mini" , 28 , 35 UNIONSELECT "medium" , 35 , 45 UNIONSELECT "standard" , 45 , 60; Q2: By Parent HeightCreate a table by_parent_height that has a column of the names of all dogs that have a parent,ordered by the height…
Table EMP Column name Column type Integer Up to 10 characters Example entry EMPNO ENAME Description Employee ID number Employee surname 7369 SMITH Integer Integer Employee's job title No ID no. of employee's JOBNO 10 MGR 7566 manager HIREDATE Date 17/12/1980 Date employment started Monthly salary SAL Integer 1600 Table JOB Column name Column type Integer Up to 15 characters Example entry Description job title No Employee's job title JOBNO 10 JOB TITLE SALESMAN a) Write SQL statements to create EMP and JOB tables. Define appropriate data types and check constraints for the tables' fields. Write SQL statements to populate these tables with 3 rows of sample data.