Loading, please wait...

Oracle 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 

11.  In an E-R diagram an entity set is represent by a

  • Rectangle
  • Ellipse
  •  Diamond box
  • Circle

12. Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?

  • Data Definition Language(DDL)
  • Data Manipulation Language(DML)
  • DML and DDL
  • All of the Mentioned

13.  ________clause is an additional filter that is applied to the result.

  • Select
  • Group-by
  • Order by
  • Having

14. Which command is used for removing a table and all its data from the database:

  • Create command
  •  Drop table command
  • Alter table command
  • All of the Mentioned

15. ___________ defines rules regarding the values allowed in columns and is the standard mechanism for enforcing database integrity.

  • Column
  • Constraint
  • Index
  • Trigger