Question
(SELECT DISTINCT r.sid
FROM boats b, reserves r
WHERE b.bid = r.bid
AND b.color = 'red')
MINUS
(SELECT DISTINCT r.sid
FROM boats b, reserves r
WHERE b.bid = r.bid
AND b.color = 'green')
a.
Find the sailor IDs of all sailors who have reserved red boats but not green boats
b.
Find the sailor IDs of at least one sailor who have reserved red boats but not green boats
c.
Find the sailor Ids of atmost one sailor who have reserved red boats but not green boats
d.
None of These
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. What does the following query find? (SELECT DISTINCT r.sid FROM boats b, reserves r WHERE b.bid = r.bid AND b.color = 'red') MINUS (SELECT DISTINCT r.sid FROM boats b,...
Similar Questions
Discover Related MCQs
Q. Which of the following query finds the name of the sailors who have reserved at least two boats?
View solution
Q. Which of the following query finds the total rating of the sailors who have reserved boat "103"?
View solution
Q. The SELECT statement SELECT 'Hi' FROM DUAL WHERE NULL = NULL; Outputs
View solution
Q. If a query involves NOT, AND, OR with no parenthesis
View solution
Q. Let the statement
SELECT column1 FROM myTable;
return 10 rows. The statement
SELECT ALL column1 FROM myTable;
will return
View solution
Q. Table employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.
The SQL statement
SELECT COUNT(*) FROM employee WHERE SALARY > ALL (SELECT SALARY FROM EMPLOYEE);
prints
View solution
Q. Which of the following SQL commands can be used to add data to a database table?
View solution
Q. Which of the following join is also called as an 'inner-join'?
View solution
Q. The result of a SQL SELECT statement is a ________ .
View solution
Q. Which of the following query is correct for using comparison operators in SQL?
View solution
Q. How to select all data from student table starting the name from letter 'r'?
View solution
Q. Which of the following SQL query is correct for selecting the name of staffs from 'staffinfo' table where salary is 10,000 or 25,000?
View solution
Q. Select the right statement to insert values to the student table.
View solution
Q. ............. joins two or more tables based on a specified column value not equaling a specified column value in another table.
View solution
Q. In SQL, which command is used to change a table's storage characteristics?
View solution
Q. 'AS' clause is used in SQL for
View solution
Q. The type of function which allows performing additional operations and sending messages to other tables in database program is considered as
View solution
Q. The technique in which source program are replaced by database management generated code is classified as
View solution
Q. In database management systems, the record which contains all the data regarding tuples of database is called
View solution
Q. The database program which handles software applications and include database servers calls to update the data is classified as
View solution
Suggested Topics
Are you eager to expand your knowledge beyond DBMS? We've curated a selection of related categories that you might find intriguing.
Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!
