Protected: Structured Query Language [SQL] Interview Questions
There is no excerpt because this is a protected post.
Read moreInterview Questions
Protected: Oracle Data Guard 19c – 100 Interview Questions!!
There is no excerpt because this is a protected post.
Read morePatching !!
In which months oracle release CPU patches? JAN, APR, JUL, OCT When we applying single…
Read moreAbout Oracle Database Release Numbers
Oracle products follow a custom release-numbering and -naming convention. The "c" in the current release,…
Read moreBasic Concepts of Index
Oracle uses two different index architectures: b-Tree indexes and bitmap indexes. Cluster indexes, bitmap join…
Read moreExport/Import Interview Questions-II
What is use of INDEXFILE option in imp? Will write DDLs of the objects in…
Read moreExport/Import Interview questions-I
What is use of CONSISTENT option in exp? When you export a table, you are…
Read moreWhat is redo log thread?
In Oracle Database, a redo log thread refers to a specific instance of redo log…
Read moreRMAN Retention Policy Based On Redundancy Policy
When you are taking backups regularly to a specified disk then after some period of…
Read moreOracle Clusterware Startup Sequence
What is Oracle Clusterware – RAC ? Oracle Clusterware enables servers to communicate with each…
Read moreSystem Monitor Process (SMON) : Oracle Background Process.
SMON Performs critical tasks such as crash recovery when the instance is started following a…
Read moreTransparent Data Encryption in Oracle
Transparent Data Encryption (TDE) enables you to encrypt sensitive data that you store in tables…
Read moreRedolog Buffer Cache : SGA Component of Oracle
The redo log buffer is a circular buffer in the SGA that stores redo entries…
Read moreShared /Large/Java/Result Pool: SGA Component of Oracle
The shared pool caches various types of program data.For example, the shared pool stores parsed…
Read moreOverview of the Program Global Area (PGA)
The PGA is memory specific to an operating process or thread that is not shared…
Read moreOverview of the User Global Area
The UGA is session memory, which is memory allocated for session variables, such as logon…
Read moreWhat is Checkpoint ?
A checkpoint is an operation that Oracle performs to ensure data file consistency. When a…
Read moreRead-only user Creation.
Sometimes the DBA requires to create the read-only user for a particular schemas.While creating the…
Read moreORA-01653: Adding, Resizing of datafiles in Oracle
Datafiles are part of the Oracle Database, these are the files that have the actual…
Read moreImportant Parameters in Data Guard
DB_NAME On a primary database, specify the name used when the database was created. On…
Read moreDatabase Buffer Cache : SGA Component of Oracle
The database buffer cache, also called the buffer cache, is the memory area that stores…
Read more