OCP CBT Question 656
Please solve the following question.
An administrator executes the following SQL statements:
sqlCREATE TABLE regions (region_id NUMBER(2), region_name VARCHAR2(25));INSERT INTO regions VALUES (1, 'Europe');INSERT INTO regions VALUES (2, 'Americas');INSERT INTO regions VALUES (3, 'Asia');INSERT INTO regions VALUES (4, 'Middle East and Africa');COMMIT;SELECT region_name FROM regions WHERE region_id NOT IN (1, 3, 5) ORDER BY region_name DESC;
What is the expected output of the SELECT statement?