Loading, please wait...

Become An Author

SQL (Structured Query Language) MCQ Quiz (Multiple Choice Questions And Answers)

Search here for MCQs

Are you preparing for the next job interviews? If yes, trust me this post will help you also we'll suggest you check out a big collection for Programming Full Forms that may help you in your interview:

List of Programming Full Forms 

16. Table Employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.

So, What the below SQL statement will return:

SELECT COUNT(*) FROM Employee WHERE SALARY > ANY (SELECT SALARY FROM EMPLOYEE);

 

  • 10
  • 9
  • 5
  • 0
View Answer

17. The SQL statement - SELECT SUBSTR('abcdefghij', INSTR('123321234', '2', 3, 2), 2) FROM DUAL; Prints

  • gh
  • 23
  • bc
  • ab
View Answer

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

  • is illegal
  • prints garbage
  • prints 045.926
  • prints 50
View Answer

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

  • Dates
  • Column Alias
  • String
  • All of the mentioned
View Answer

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

  • ROLLBACK
  • COMMIT
  • TRUNCATE
  • DELETE
View Answer

JOIN TUTORIALS LINK

Our Newsletter Will Let You Know When Any New
Articles, Tutorials and Video Are Released.

CONTRIBUTE

Follow us

Copyright © 2024. All Rights Reserved.