SQL MCQ Questions and answers Page-3 section-1

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

A. 10

B. 9

C. 5

D. 0

Answer & Solution Discuss in Board Save for Later

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

A. gh

B. 23

C. bc

D. ab

Answer & Solution Discuss in Board Save for Later

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

A. is illegal

B. prints garbage

C. prints 045.926

D. prints 50

Answer & Solution Discuss in Board Save for Later

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

A. Dates

B. Column Alias

C. Strings

D. All of the above

Answer & Solution Discuss in Board Save for Later

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

A. ROLLBACK

B. COMMIT

C. TRUNCATE

D. DELETE

Answer & Solution Discuss in Board Save for Later

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

A. ROLLBACK

B. COMMIT

C. TRUNCATE

D. DELETE

Answer & Solution Discuss in Board Save for Later

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

A. SELECT city WHERE humidity = 89;

B. SELECT city FROM weather WHERE humidity = 89;

C. SELECT humidity = 89 FROM weather;

D. SELECT city FROM weather;

Answer & Solution Discuss in Board Save for Later

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

A. SELECT city FROM weather ORDER BY temperature;

B. SELECT city, temperature FROM weather;

C. SELECT city, temperature FROM weather ORDER BY temperature;

D. SELECT city, temperature FROM weather ORDER BY city;

Answer & Solution Discuss in Board Save for Later

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

A. Feature begins with two 0's

B. Feature ends with two 0's

C. Feature has more than two 0's

D. Feature has two 0's in it, at any position

Answer & Solution Discuss in Board Save for Later

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

A. SELECT city, temperature, condition FROM weather WHERE condition NOT IN ('sunny', 'cloudy');

B. SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN ('sunny', 'cloudy');

C. SELECT city, temperature, condition FROM weather WHERE condition IN ('sunny', 'cloudy');

D. SELECT city, temperature, condition FROM weather WHERE condition BETWEEN ('sunny', 'cloudy');

Answer & Solution Discuss in Board Save for Later

SQL MCQ Questions and answers

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

Answer & Solution

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

Answer & Solution

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

Answer & Solution

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

Answer & Solution

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

Answer & Solution

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

Answer & Solution

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

Answer & Solution

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

Answer & Solution

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

Answer & Solution

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

Answer & Solution

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