Polaris Most Frequently Asked Latest Oracle Interview Questions Answers
What Is The Function Of Redo Log?
The primary function of the redo log is to record all changes made to data.
What Is A Redo Log?
The set of redo log files for a database is collectively known as the database redo log.
What Are The Characteristics Of Data Files?
A data file can be associated with only one database. Once created a data file can’t change size. One or more data files form a logical unit of database storage called a tablespace.
What Is A Datafile?
Every Oracle database has one or more physical data files. A database’s data files contain all the database data. The data of logical database structures such as tables and indexes is physically stored in the data files allocated for a database.
What Is A Temporary Segment?
When the statement finishes execution, the temporary segment extents are released to the system for future use.
What Are The Uses Of Rollback Segment?
To generate read-consistent database information during database recovery and to rollback uncommitted transactions by the users.
What Is Rollback Segment?
A database contains one or more rollback segments to temporarily store “undo” information.
What Is An Index Segment?
Each index has an index segment that stores all of its data.
What Are The Different Types Of Segments?
Data segment, index segment, rollback segment and temporary segment.
What Is A Segment?
A segment is a set of extents allocated for a certain logical structure.
What Are Synonyms Used For?
- Mask the real name and owner of an object.
- Provide public access to an object
- Provide location transparency for tables, views or program units of a remote database.
- Simplify the SQL statements for database users.
What Is Mean By Program Global Area (pga)?
It is area in memory that is used by a single Oracle user process.
What Is A Shared Pool?
Shared pool in oracle contains cache information that collects, parses, interprets and executes SQL statements that goes against database. This shared pool acts like a buffer for these SQL statements.
What Is Sga?
The System Global Area in an Oracle database is the area in memory to facilitate the transfer of information between users. It holds the most recently requested structural information between users. It holds the most recently requested structural information about the database. The structure is database buffers, dictionary cache, redo log buffer and shared pool area.
What Is A Cluster Key?
The related columns of the tables are called the cluster key. The cluster key is indexed using a cluster index and its value is stored only once for multiple tables in the cluster.
What Are Clusters?
Group of tables physically stored together because they share common columns and are often used together is called cluster.
What Is A Control File?
Database’s overall physical architecture is maintained in a file called control file. It will be used to maintain internal consistency and guide recovery operations. Multiple copies of control files are advisable.
It Is Possible To Use Raw Devices As Data Files And What Are The Advantages Over File System Files?
The advantages over file system files are that I/O will be improved because Oracle is bye-passing the kernel which writing into disk. Disk corruption will be very less.
How Can We Plan Storage For Very Large Tables?
Limit the number of extents in the table
Separate table from its indexes.
Allocate sufficient temporary storage.
What Is The Function Of Redo Log?
The primary function of the redo log is to record all changes made to data.
What Is A Redo Log?
The set of redo log files for a database is collectively known as the database redo log.
What Are The Characteristics Of Data Files?
A data file can be associated with only one database. Once created a data file can’t change size. One or more data files form a logical unit of database storage called a tablespace.
What Is A Datafile?
Every Oracle database has one or more physical data files. A database’s data files contain all the database data. The data of logical database structures such as tables and indexes is physically stored in the data files allocated for a database.
What Is A Temporary Segment?
When the statement finishes execution, the temporary segment extents are released to the system for future use.
What Are The Uses Of Rollback Segment?
To generate read-consistent database information during database recovery and to rollback uncommitted transactions by the users.
 |
| Polaris Most Frequently Asked Latest Oracle Interview Questions Answers |
What Is Rollback Segment?
A database contains one or more rollback segments to temporarily store “undo” information.
What Is An Index Segment?
Each index has an index segment that stores all of its data.
What Are The Different Types Of Segments?
Data segment, index segment, rollback segment and temporary segment.
What Is A Segment?
A segment is a set of extents allocated for a certain logical structure.
What Are Synonyms Used For?
- Mask the real name and owner of an object.
- Provide public access to an object
- Provide location transparency for tables, views or program units of a remote database.
- Simplify the SQL statements for database users.
What Is Mean By Program Global Area (pga)?
It is area in memory that is used by a single Oracle user process.
What Is A Shared Pool?
Shared pool in oracle contains cache information that collects, parses, interprets and executes SQL statements that goes against database. This shared pool acts like a buffer for these SQL statements.
What Is Sga?
The System Global Area in an Oracle database is the area in memory to facilitate the transfer of information between users. It holds the most recently requested structural information between users. It holds the most recently requested structural information about the database. The structure is database buffers, dictionary cache, redo log buffer and shared pool area.
What Is A Cluster Key?
The related columns of the tables are called the cluster key. The cluster key is indexed using a cluster index and its value is stored only once for multiple tables in the cluster.
What Are Clusters?
Group of tables physically stored together because they share common columns and are often used together is called cluster.
What Is A Control File?
Database’s overall physical architecture is maintained in a file called control file. It will be used to maintain internal consistency and guide recovery operations. Multiple copies of control files are advisable.
It Is Possible To Use Raw Devices As Data Files And What Are The Advantages Over File System Files?
The advantages over file system files are that I/O will be improved because Oracle is bye-passing the kernel which writing into disk. Disk corruption will be very less.
How Can We Plan Storage For Very Large Tables?
Limit the number of extents in the table
Separate table from its indexes.
Allocate sufficient temporary storage.