Database offers a single point of mechanism for storing and retrieving information with the help of tables
1. A table is made up of rows and columns where each column stores specific attributes and each row display value for the corresponding attribute.
2. It is a structure that stores information about the attributes of the entities and relationship among them
3. It also stores data types for attributes and Indexes
A Database is divided into logical Storage Unit called tablespaces. A tablespace is used to grouped related logical structures together.
A view is a virtual table. Every view has a query attached to it. The query is SELECT Statement that identifies the columns and rows of the table the view uses.
From 12c Onwards, the instance is shared with multiple databases.These multiple databases are self-contained and pluggable from one database to another database. This is very useful methodology where database consolidation.In short a
single SGA and background process will be shared to multiple databases, the databases can be created on the fly and drop or attach and detach from one server to another server.
Oracle database is a combination of database and instance where instance is a combination of memory structures and background process which help in reading/writing data to or from the database.
This section covers Oracle DBA 11g interview questions and answers For Freshers. It helps job seekers who are about to attend Oracle DBA interview round.
This section covers Oracle DBA 11g interview questions and answers For Experienced. It helps job seekers who are about to attend Oracle DBA interview round.
Oracle 12C DBA Interview Questions and Answers