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 > ANY (SELECT SALARY FROM EMPLOYEE);
prints

View solution

Q. The SQL statement
SELECT SUBSTR('abcdefghij', INSTR('123321234', '2', 3, 2), 2) FROM DUAL;
prints

View solution

Q. The SQL statement
SELECT ROUND(45.926, -1) FROM DUAL;

View solution

Q. Which of the following must be enclosed in double quotes?

View solution

Q. Which of the following command makes the updates performed by the transaction permanent in the database?

View solution

Q. Which command undo all the updates performed by the SQL in the transaction?

View solution

Q. Find all the cities whose humidity is 89

View solution

Q. Find the temperature in increasing order of all cities

View solution

Q. What is the meaning of LIKE '%0%0%'

View solution

Q. Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy

View solution

Q. Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature must be greater than 70F.

View solution

Q. Find all the tuples having temperature greater than 'Paris'.

View solution

Q. Find all the cities with temperature, condition and humidity whose humidity is in the range of 63 to 79

View solution

Q. Find the names of the countries whose condition is sunny.

View solution

Q. Find the name of all cities with their temperature, humidity and countries.

View solution

Q. Find the name of cities with all entries whose temperature is in the range of 71 and 89

View solution

Q. Which of the following query finds the names of the sailors who have reserved at least one boat?

View solution

Q. Which of the following query finds colors of boats reserved by "Dustin"?

View solution

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, reserves r
WHERE b.bid = r.bid
AND b.color = 'green')

View solution

Q. Which of the following query finds the name of the sailors who have reserved at least two boats?

View solution