Oracle MCQ Questions with Answers – Instances
MS Oracle MCQ questions and answers for the preparation of tests, exams, and certifications. So you will find questions about the Datafiles, Control Files, Redo Log Files, Archive Log Files, Parameter Files, Trace Log, Backup, and much more. This systematic learning method will easily prepare anyone to pass their exam.
1. The database environment in Oracle is called ___________ ?
A Schema
B Instance
C Data structure
D All the answers are true
2. What is the smallest storage unit in an Oracle database?
A Data block
B Segment
C Extent
D Data file
3. A collection of information stored in a database at a given time is called ____________ ?
A Database instance
B Objects in the database
C Data structure
D Database schema
4. The design of an Oracle database is also called _____________?
A Database abstraction
B Database instance
C Database schema
D None of the above
5. A _____________ is a set of tables physically stored together as a table that share a common column?
A Index
B Object
C Datafiles
D Cluster
6. A _______________ is used to group data in a logical way ?
A Database
B Tablespace
C Datafiles
D Object
7. The modification of a level without affecting the high level schema is called _______?
A Data migration
B Data Isolation
C Data Independence
D Data abstraction
8. What are the objects in a pattern made of?
A Table
B Indexs
C Cluster
D All the answers are true
9. What are the valid schemas in Oracle ?
A Logical schema
B Physical schema
C Logical and physical diagram
D None of the above
10. Mapping entities, attributes and relationships in Oracle is represented by ___________?
A Conceptual schema
B Logical schema
C Physical schema
D All the answers are true
Great question