21.
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

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

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

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

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

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

27.
Find all the cities whose humidity is 89, Table Name weather

28.
Find the temperature in increasing order of all cities, Table Name 'weather'

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

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