Category: Uncategorized

Which of the following operations could violate referential integrity?

Per the SQL standard (not specific to any RDBMS implementation, which of the following clauses may not be omitted from a syntactically correct SQL read query?

What is the result of executing the following relational tuple calculus query? 

What is the best mapping into relations for the following EER diagram?  

What DID values are retured by the following query? SELECT DIDFROM DriverWHERE phone LIKE ‘_0%’;

For all states of this database, which of the following SQL queries is/are equivalent to this relational tuple calculus query?

Which query returns the RID of all Riders who have never taken a ride?

Which values are returned from the following nested SQL query? SELECT Dname FROM Driver WHERE DID IN (SELECT DID FROM RideDetail WHERE RID IN (SELECT RID FROM Rider WHERE MemberSince > 2017-01));

Considering the provided database, after executing the following update statement: UPDATE RideDetail xSET tip = price * 0.1WHERE price > 15; What RID value(s) would be returned by the following query: SELECT RIDFROM Rider rWHERE NOT EXISTS (SELECT * FROM RideDetail x WHERE x.RID = r.RID AND TIP > 4);

Which of the following relational algebra queries returns a single tuple with a value of 25?