Take the following extract from SUPPLIES:SUPNR PRODNR PURCHASE_PRICE DELIV_PERIOD37018532.9984018533.00940185 32.991301001 10.00We type the following query:SELECT SUPNR, MIN(DELIV_PERIOD)FROM SUPPLIESWHERE PRODNR = '0185'What is returned?Supnr: 84; Deliv_Period: 53521Supnr: 94; Deliv_Period: 2Supnr: 94; Purchase_Price: $32.99 \n Supnr: 37; Purchase_price: $32.99Supnr:130, Delv_Period: 1

Here in this question we have given a SQL query and we have aske that what will be retrieved if we…

e the following extract from SUPPLIES: PNR PRODNR PURCHASE_PRICE DELIV_PERIOD 0185 32.99 0185 33.00 0185 32.99 1001 10.00 O type the following query: LECT SUPNR, MIN(DELIV_PERIOD) OM SUPPLIES HERE PRODNR = '0185' hat is returned? Supnr: 84; Deliv_Period: 5 Supnr: 94; Deliv_Period: 2 3 5 2 1 Supnr: 94; Purchase_Price: $32.99 \n Supnr: 37; Purchase_price: $32.99 Supnr:130, Delv_Period: 1

e the following extract from SUPPLIES: PNR PRODNR PURCHASE_PRICE DELIV_PERIOD 0185 32.99 0185 33.00 0185 32.99 1001 10.00 O type the following query: LECT SUPNR, MIN(DELIV_PERIOD) OM SUPPLIES HERE PRODNR = '0185' hat is returned? Supnr: 84; Deliv_Period: 5 Supnr: 94; Deliv_Period: 2 3 5 2 1 Supnr: 94; Purchase_Price: $32.99 \n Supnr: 37; Purchase_price: $32.99 Supnr:130, Delv_Period: 1

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

||| > 4G Students table Write a SQL statement to create the following tow tables: 23 STD_ID STD_NAME COURSE_NO LEV 21 15 33 12 11 Bandar Khalid Naif 102 Ims.kku.edu.sa Yasser Ziyad Courses table 101 231 271 Assignments 231 102 271 101 Mohammad 101 4 Data Science 4 3 6 COURSE NO COURSE_NAME COURSE_TEAC Programming Abdulaziz Computing Abdulaziz Database Mohammad 5 4 ۱۰:۲۲ - Query1: Display all Student names who already registered in a course. - Query2: Display students names and course names from both students and courses tables for only students whose level is higher than 4. Ĵ
Employee(empno, ename, street, city, mgrssn) work_project(eno, pno, number_of_hours) Write a query and optimize it to find employee name and project number in which they work and who live in "New_york". Identify the type of indexing to be applied on 'empno' in Employee Table.
FROM customer WHERE city IN (SELECT city FROM employee WHERE reports_to= 2); 2. SELECT customer.* FROM customer INNER JOIN employee ON customer.city = employee.city WHERE reports_to = 2; Query #1 would be more efficient as it is based on primary and foreign keys. O Query #1 would be more efficient as it is not using indexed columns. Both would be the same as both use the same indices for the join and filter. Query #2 would be more efficient as it is based on primary and foreign keys. 70°F Cloudy QL
The DEPARTMENTS table has the following data: DEPARTMENT ID DEPARTMENT NAME MANAGER ID LOCATION_ID 10 Administration 200 1700 20 Marketing 201 1800 50 Shipping 124 1500 60 IT 103 1400 80 Sales 149 2500 What will be the value in the first row of the result set when the following query is executed? SELECT manager_id FROM departments ORDER BY location_id; O a. 201 O b. 149 O c. 103 O d. 200
Below are some rows of the PROVIDERS table for a factory: PCODE 10192 98411 0489035 NAME Hans, Inc. Tools and More Motors Inc. PHONE 231 - 3092 231-1029 993 - 1821 All providers from the factory zone of the city start with 231. You want to get the providers that are in the factory zone of the city. Which of the following is more appropriate? O a. O b. SELECT * FROM PROVIDERS WHERE PHONE LIKE '% 231' O C. O d. SELECT * FROM PROVIDERS WHERE PHONE LIKE $231%' SELECT * FROM PROVIDERS WHERE PHONE LIKE 231 SELECT * FROM PROVIDERS WHERE PHONE LIKE '%231%'
Task 3: The Car Maintenance team wants to insert and store the following maintenance types to the MAINTENANCE_TYPES table: ID: 1; Description: Tire Change; Price: 50 ID: 2; Description; Oil Change; Price: 45 ID: 3; Description; Full Cleaning; Price: 100 ID: 4; Description; Gas Pump Change; Price: 145 SQL Database Add the four maintenance types to the MAINTENANCE_TYPES table Test Query SELECT * FROM MAINTENANCE_TYPES Expected Results MAINTENANCE_TYPE_ID MAINTENANCE_TYPE_DESCRIPTION MAINTENANCE_PRICE 1 Tire Change 50 2 Oil Change 45 3 Full Cleaning 100 4 Gas Pump Change 145
Some rows of the table STUDENT are shown below: CODE NAME DEPARTMENT GPA YEAR 291 ALEX PSI 3.1 1992 938 MICHELE PHY 2.3 1992 931 JHON MD 3.3 2001 182 JOE MD 3.4 2002 190 REY PHY 2.0 2001 330 RON PSI 3.9 2001 You want the name all departments that have a department GPA average of 2004 greater than the global GPA average. Which query gives you the desired result? a. SELECT DEPARTMENT FROM STUDENT WHERE YEAR = 2004 GROUP BY DEPARTMENT HAVING AVG(GPA) > (SELECT AVG(GPA) FROM STUDENT); b. SELECT DEPARTMENT FROM STUDENT WHERE YEAR = 2004 AND AVG(GPA) > (SELECT AVG(GPA) FROM STUDENT) GROUP BY DEPARTMENT; c. SELECT DEPARTMENT FROM STUDENT WHERE YEAR = 2004 GROUP BY DEPARTMENT HAVING AVG(GPA) > (SELECT GPA FROM STUDENT GROUP BY DEPARTMENT); d. SELECT * FROM STUDENT WHERE YEAR = 2004 GROUP BY DEPARTMENT HAVING AVG(GPA) > (SELECT AVG(GPA) FROM STUDENT);
Write4 query to find the balance characteristics for all customers, including the total of the outstanding balances. The results of this query are shown in Figure P7.39.0.
Some rows of the STUDENT table are shown below: CODE NAME GPA YEAR 291 ALEX 3.1 2 938 MICHELE 2.3 1 931 JHON 3.3 1 182 JOE 3.4 2 190 REY 2.0 2 330 RON 3.9 3 Which best describes the result of the query below? SELECT YEAR, AVG(GPA) FROM STUDENT WHERE GPA > 2.0 GROUP BY YEAR a. The average maximum GPA of all the students in each year. b. The year of the student with the maximum GPA. c. The average GPA of students with a GPA higher than 2.0 each year. d. The average GPA of the students with a GPA higher than 2.0.
If v is a scalar and R is a relation, which statement holds? Select one: a. All of the above are true O b. v < ALL R means V is the minimum value in R С. v != ALL R means V not in R O d. V = ALL R means V in R Students Roster name lastname age ID ID major absence rim ismail 19 123 123 EE 4. sara kamel 18 134 134 EE 7 milad ghantous 21 1345 1345 CCE 2 tarek dib 18 12345 12345 ME 4 Complete the query that finds all student names and last names for those who are 18 years old and they're registered in EE major. Select one: SELECT name,lastname FROM students WHERE age=18 AND ID IN (SELECT ID FROM roster WHERE major='EE') SELECT ID FROM students WHERE ID IN (SELECT ID FROM roster WHERE major ='EE') SELECT name, lastname FROM students WHERE age=D18 and ID= SELECT ID from roster WHERE major='EE')
Based on the following authorication commands (ordered from 1 to 4), which of the following privileges is true, assuming that Ali is the owner of the database? Order By Ali 1 2 3 4 Select one: Omar Ali Ali Command Grant Select on Employee to Omar with grant option; Grant Select on Employee to Samer with grant option; Grant Update on Employee to Omar with grant option; Revoke Select on Employee From Omar Cascade; a) Ali and Omar have Update privilege on employee Ali has select privilege on employee b) Ali and Omar have Update privilege on employee Omar and Samer have select privilege on employee elect c) Ali and Omar have Update privilege on employee Ali and Omar have select privilege on employee d) Ali and Omar have Update privilege on employee Ali, Omar and Samer have select privilege on employee
The Binder Prime Company wants to recognize the employee who sold the most of its products during a specified period. Write a query to display the employee num-ber, employee first name, employee last name, email address, and total units sold for the employee who sold the most Binder Prime brand products between November 1, 2015, and December 5, 2015. If there is a tie for most units sold, sort the output by employee last name