Quiz  /  Oracle Certification Gate & PSU MCQ Questions With Answers

  • 1. 
    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

  • 2. 
    Which of the following components comprise an Oracle architecture?

  • Database related background processes
  • Tablespaces
  • Datafiles
  • All of the Mentioned

  • 3. 
    In an E-R diagram, an entity set is represented by a ______.

  • Rectangle
  • Ellipse
  • Diamond box
  • Circle

  • 4. 
    Map entities, attributes and relations in Oracle is represented by_________.

  • Logical Schema
  • Conceptual Schema
  • Physical Schema
  • All of the Mentioned

  • 5. 
    Oracle server configuration is dedicated for ________.

  • One server process – Many user processes
  • Many server processes – One user process
  • One server process – One user process
  • Many server processes – Many user processes

  • 6. 
    Which process is an instance made of Oracle?

  • Oracle background processes
  • Memory processes
  • Data processes
  • All of the Mentioned

  • 7. 
    In Oracle, which of the following package procedure is UNRESTRICTED?

  • CALL_INPUT
  • CLEAR_BLOCK
  • USER_EXIT
  • EXECUTE_QUERY

  • 8. 
    What is the use of extent in Oracle?

  • Stores user data within the database
  • Minimize the amount of wasted (empty) storage
  • Stores rollback information used when data must be rolled back
  • All of the Mentioned

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

  • Column
  • Constraint
  • Index
  • Trigger

  • 10. 
    What are the valid Oracle database schemas?

  • Logical Schema
  • Physical Schema
  • Logical and Physical Schema
  • None of the Mentioned

  • 11. 
    Collection of information stored in database at particular instance of time is called as ____________.

  • Instance of Database
  • Objects in Databases
  • Database Instances
  • None of the Mentioned

  • 12. 
    Which is the smallest unit of storage in an Oracle database?

  • Data Block
  • Segment
  • Extent
  • Data File

  • 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
Report Question
warning
access_time
  Time