Consider the following instance of relation Sells(book_title, library, price): Sells book_title library price The grand design Noura 20,000 Brief history of time Noura 15,000 The grand design Malik's 18,000 Brief history of time Malik's 16,000 Quantum çomputers Malik's 25,000 Brief history of time Al Dirasat 21,000 What this query is trying to find? Select book_title from sells s1 where EXISTS (select * from sells where book_title = s1.book_title and library != s1.library) Select one: O a. Books sold by exactly one library O b. Books sold by more than one library O c. Books sold by one library or more. O d. Books not sold by any library

Consider the following instance of relation Sells(book_title, library, price): Sells book_title library price The grand design Noura 20,000 Brief history of time Noura 15,000 The grand design Malik's 18,000 Brief history of time Malik's 16,000 Quantum çomputers Malik's 25,000 Brief history of time Al Dirasat 21,000 What this query is trying to find? Select book_title from sells s1 where EXISTS (select * from sells where book_title = s1.book_title and library != s1.library) Select one: O a. Books sold by exactly one library O b. Books sold by more than one library O c. Books sold by one library or more. O d. Books not sold by any library

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

i need to create a query that joins these 3 tables, without the duplicate column which would be the shop_id. i cant get them to join without that column duplicating. help would be appreciated thanks! CREATE TABLE COFFEE_SHOP ( shop_id int, shop_name VARCHAR(50), city VARCHAR(50),state CHAR(2), PRIMARY KEY (shop_id)); CREATE TABLE EMPLOYEE ( employee_id int, first_name VARCHAR(30), last_name VARCHAR(30),hire_date Date,job_title VARCHAR(30),shop_id int, PRIMARY KEY (employee_id),FOREIGN KEY (shop_id) REFERENCES COFFEE_SHOP(shop_id)); CREATE TABLE COFFEE ( coffee_id int, shop_id int, supplier_id int,coffee_name VARCHAR(30),price_per_pound NUMERIC(5,2), PRIMARY KEY (coffee_id),FOREIGN KEY (shop_id) REFERENCES COFFEE_SHOP(shop_id),FOREIGN KEY (supplier_id) REFERENCES SUPPLIER(supplier_id));
JOIN TABLES One row in the PAT_ENC table represents one patient encounter. One row in the ORDER MED table represents one medication order. One patient encounter can have many medication orders but one medication order can only have one patient encounter. In other words, the cardinality of this PAT_ENC to ORDER_MED relationship is one-to- many. You start a query with PAT_ENC. You then add ORDER_MED using an inner join. What is true about the granularity of the result set before and after adding the ORDER_MED table? SELECT ONE OF THE FOLLOWING A. The granularity stays at one row per patient encounter. B. The granularity stays at one row per medication order. C. The granularity changes from one row per patient encounter to one row per medication order on an encounter. D. The granularity changes from one row per medication order to one row per patient encounter.
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')
3. What is the result of the following query? 2select name, dept_namefrom Instructorwhere name like ‘%in%’
1