Question 41 : Find all the cities whose humidity is 89
1. SELECT city WHERE humidity = 89;
2. SELECT city FROM weather WHERE humidity = 89;
3. SELECT humidity = 89 FROM weather;
4. SELECT city FROM weather;
View Answer   Discuss with Members

Question 42 : Which command undo all the updates performed by the SQL in the transaction?
1. ROLLBACK
2. COMMIT
3. TRUNCATE
4. DELETE
View Answer   Discuss with Members

Question 43 : Which of the following command makes the updates performed by the transaction permanent in the database?
1. ROLLBACK
2. COMMIT
3. TRUNCATE
4. DELETE
View Answer   Discuss with Members

Question 44 : Which of the following must be enclosed in double quotes?
1. Dates
2. Column Alias
3. Strings
4. All of the above
View Answer   Discuss with Members

Question 45 : The SQL statement
SELECT ROUND(45.926, -1) FROM DUAL;
1. is illegal
2. prints garbage
3. prints 045.926
4. prints 50
View Answer   Discuss with Members

Question 46 : The SQL statement
SELECT SUBSTR('abcdefghij', INSTR('123321234', '2', 3, 2), 2) FROM DUAL;
prints
1. gh
2. 23
3. bc
4. ab
View Answer   Discuss with Members

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

Question 48 : Which of the following group functions ignore NULL values?
1. MAX
2. COUNT
3. SUM
4. All of the above
View Answer   Discuss with Members

Question 49 : The SQL statement
SELECT SUBSTR('123456789', INSTR('abcabcabc', 'b'), 4) FROM DUAL;
1. 6789
2. 2345
3. 1234
4. 456789
View Answer   Discuss with Members

Question 50 : Which SQL keyword is used to sort the result-set?
1. SORT BY
2. ORDER
3. ORDER BY
4. SORT
View Answer   Discuss with Members