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

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter9: Joining Data From Multiple Tables

Section: Chapter Questions

Problem 12MC

See similar textbooks

Similar questions

) Consider the relations r(A, B, D), and s(B, D, F), in which A, B, D and F are their attributes. Thefollowing SQL query based on these two relations has a nested subquery. Provide an equivalent SQL querywhich does not have any nested subquery.select A, Bfrom rwhere r.B < some (select Bfrom swhere s.D= r.D)
Consider the following relations for a university: Student (sid: integer, sname: string(100 chars), GPA: real, dateOfBirth: date, Did: integer, FirstYear: integer)Department (did: integer, dname: string(30 chars), capacity: integer)Course (cid: integer, cname: string(50 chars), credit: integer)Enroll (studentID: integer, courseID: integer, departmentID: integer, enrollmentDate: date, finalGrade: real) studentID, courseID, and departmentID in Enroll are foreign keys referencing the primary keys of the student, course, and department relations, respectively. Did in Student is a foreign key referencing the primary key of the department relation. 1) For each student with GPA between 2.5 (included) and 3.5 (included), display the student’s name, GPA,and his/her department ID. Sort the results by the students’ IDs in descending order. 2) For each student who joined the Computer Science department between 2018 (included) and 2020(included), display the…
EmployeeID is the primary key for the relation below. Which column violates a rule (characteristic) of a relation? Employee Relation EmployeeID Department PhoneNum PhoneNum 300 Finance 321-299-1234 407-999-2300 200 Sales 407-222-9090 321-365-0912 400 Sales 407-807-1124 407-453-2294 100 HR 321-934-2034 Group of answer choices The column named PhoneNum because you can’t have two columns with the same name. All the columns are valid. The EmployeeID column because the ID numbers are not in order. The Department column.
Student ID | Student_name | Cource ID | Cource name | Grade 2 Noor 1 HIML B+ 7 C++ A 3 JAVA B 25 Al 2 C+ A 3 JAVA B 27 Sara 1 HIML A 3 JAVA A 28 Abmed 2 C++ B+ 1. What update anomalies may occur in the selation? 2. In which normal form (NF) the above relation? Provide an explanation to support your answer. 3. Decompose the relation so that the resut relations are in the third normal form (3NF).
Given the following relation that stores details about students' activities: StudentID StudentName Activity ActivityFee AmountPaid 100 Jones Golf 65.00 65.00 100 Jones Skiing 200.00 0.00 200 Davis Skiing 200.00 0.00 200 Davis Swimming 50.00 50.00 300 Garrett Skiing 200.00 100.00 300 Garrett Swimming 50.00 50.00 400 Jones Golf 65.00 65.00 400 Jones Swimming 50.00 50.00
Table_1 below has a primary key of column1. Which column(s) from this relation could be a foreign key in another, related relation? Check all that qualify. Generic Relation column1 column2 column3 column4 100 19.99 cde A 200 23.78 klj D 300 77.43 qnw B Group of answer choices column2 any of the columns in the table could be a foreign key column4 column3 column1
Question 2: Consider the following relations: Student(snum: integer, sname: string, major: string, level: string, age: integer) Class(name: string, meets at: string, room: string, fid: integer) Enrolled(snum: integer, cname: string) Faculty(fid: integer, fname: string, deptid: integer) Write the following queries in SQL. No duplicates should be printed in any of the answers. Find the names of all Juniors (level = JR) who are enrolled in a class taught by Teach. Find the age of the oldest student who is either a History major or enrolled in a course taught by I. Teach. Find the names of all classes that either meet in room R128 or have five or more students enrolled. Find the names of all students who are enrolled in two classes that meet at the same time. Find the names of faculty members who teach in every room in which some class is taught.
Question 2: Consider the following relations: Student(snum: integer, sname: string, major: string, level: string, age: integer) Class(name: string, meets at: string, room: string, fid: integer) Enrolled(snum: integer, cname: string) Faculty(fid: integer, fname: string, deptid: integer) Write the following queries in SQL. No duplicates should be printed in any of the answers. Find the names of all Juniors (level = JR) who are enrolled in a class taught by Teach. Find the age of the oldest student who is either a History major or enrolled in a course taught by I. Teach. Find the names of all classes that either meet in room R128 or have five or more students enrolled. Find the names of all students who are enrolled in two classes that meet at the same time. Find the names of faculty members who teach in every room in which some class is taught. I need last 2 subparts answer
Suppose you have a relation containing the x, y coordinates and names ofrestaurants. Suppose also that the only queries that will be asked are of the following form: The query specifies a point and asks if there is a restaurant exactly at that point. Which type of index would be preferable, R-tree or B-tree? Why?
Consider the following SQL query that seeks to find a list of titles of all coursestaught in Spring 2017 along with the name of the instructor.select name, titlefrom instructor natural join teaches natural join section natural join coursewhere semester = 'Spring' and year = 2017What is wrong with this query?
SQL allows a foreign-key dependency to refer to the same relation, as in thefollowing example:create table manager(employee ID char(20),manager ID char(20),primary key employee ID,foreign key (manager ID) references manager(employee ID)on delete cascade )Here, employee_ID is a key to the table manager, meaning that each employeehas at most one manager. The foreign-key clause requires that every manageralso be an employee. Explain exactly what happens when a tuple in the relationmanager is deleted.
You are given this table: Registration SID CourseID SemID Instructor Grade 282712 ENGL210 201701 H. Zacny B+ 362112 CS101 201701 K. Ross C 652123 CS403 201701 K. Ross A 362112 CS403 201701 K. Smith C+ 282712 BIO101 201601 I. Olsen C What will the result of the following query be? select sid, count(*)from registrationgroup by sid Select one: a. The entire table sorted by sid b. No results due to an error c. 282712 2362112 2652123 1 d. 282712 1362112 1652123 1