Question 31 : 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
1. 10
2. 9
3. 5
4. 0
View Answer   Discuss with Members

Question 32 : Let the statement
SELECT column1 FROM myTable;
return 10 rows. The statement
SELECT ALL column1 FROM myTable;
will return
1. less than 10 rows
2. more than 10 rows
3. exactly 10 rows
4. None of these
View Answer   Discuss with Members

Question 33 : If a query involves NOT, AND, OR with no parenthesis
1. NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last.
2. NOT will be evaluated first; OR will be evaluated second; AND will be evaluated last.
3. AND will be evaluated first; OR will be evaluated second; NOT will be evaluated last.
4. The order of occurrence determines the order of evaluation.
View Answer   Discuss with Members

Question 34 : Which of the following is illegal?
1. SELECT SYSDATE - SYSDATE FROM DUAL;
2. SELECT SYSDATE - (SYSDATE - 2) FROM DUAL;
3. SELECT SYSDATE - (SYSDATE + 2) FROM DUAL;
4. None of these
View Answer   Discuss with Members

Question 35 : The SELECT statement SELECT 'Hi' FROM DUAL WHERE NULL = NULL;Outputs
1. Hi
2. FLASE
3. TRUE
4. Nothing
View Answer   Discuss with Members

Question 36 : 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 = 'g
1. Find the sailor IDs of all sailors who have reserved red boats but not green boats
2. Find the sailor IDs of at least one sailor who have reserved red boats but not green boats
3. Find the sailor Ids of atmost one sailor who have reserved red boats but not green boats
4. None of These
View Answer   Discuss with Members

Question 37 : Find the name of cities with all entries whose temperature is in the range of 71 and 89
1. SELECT * FROM weather WHERE temperature NOT IN (71 to 89);
2. SELECT * FROM weather WHERE temperature NOT IN (71 and 89);
3. SELECT * FROM weather WHERE temperature NOT BETWEEN 71 to 89;
4. SELECT * FROM weather WHERE temperature BETWEEN 71 AND 89;
View Answer   Discuss with Members

Question 38 : Find the names of the countries whose condition is sunny.
1. SELECT country FROM location WHERE condition = 'sunny';
2. SELECT country FROM location WHERE city IN (SELECT city FROM weather WHERE condition = sunny');
3. SELECT country FROM location WHERE city NOT IN (SELECT city FROM weather WHERE condition = 'sunny');
4. SELECT country FROM location WHERE city UNION (SELECT city FROM weather WHERE condition = 'sunny');
View Answer   Discuss with Members

Question 39 : Find all the cities with temperature, condition and humidity whose humidity is in the range of 63 to 79
1. SELECT * FROM weather WHERE humidity IN (63 to 79)
2. SELECT * FROM weather WHERE humidity NOT IN (63 AND 79)
3. SELECT * FROM weather WHERE humidity BETWEEN 63 AND 79
4. SELECT * FROM weather WHERE humidity NOT BETWEEN 63 AND 79
View Answer   Discuss with Members

Question 40 : Find all the tuples having temperature greater than 'Paris'.
1. SELECT * FROM weather WHERE temperature > (SELECT temperature FROM weather WHERE city = 'Paris')
2. SELECT * FROM weather WHERE temperature > (SELECT * FROM weather WHERE city = 'Paris')
3. SELECT * FROM weather WHERE temperature > (SELECT city FROM weather WHERE city = 'Paris')
4. SELECT * FROM weather WHERE temperature > 'Paris' temperature
View Answer   Discuss with Members