Interview Questions Archives - Page 2 of 3

System Monitor Process (SMON) : Oracle Background Process.

SMON Performs critical tasks such as crash recovery when the instance is started following a failure, dead transaction recovery, and maintenance tasks such as temporary space reclamation, data dictionary cleanup,…

asrblogger May 15, 2023No Comments

Interview Questions Oracle

Transparent Data Encryption in Oracle

Transparent Data Encryption (TDE) enables you to encrypt sensitive data that you store in tables and tablespaces. After the data is encrypted, this data is transparently decrypted for authorized users…

asrblogger April 5, 2023No Comments

Interview Questions Oracle

Redolog Buffer Cache : SGA Component of Oracle

The redo log buffer is a circular buffer in the SGA that stores redo entries describing changes made to the database.A redo record is a data structure that contains the information necessary to reconstruct,…

asrblogger March 31, 2023No Comments

Interview Questions Oracle

Shared /Large/Java/Result Pool: SGA Component of Oracle

The shared pool caches various types of program data.For example, the shared pool stores parsed SQL, PL/SQL code, system parameters, and data dictionary information. The shared pool is involved in almost every operation that…

asrblogger March 29, 2023No Comments

Interview Questions Oracle

Overview of the Program Global Area (PGA)

The PGA is memory specific to an operating process or thread that is not shared by other processes or threads on the system. Because the PGA is process-specific, it is…

asrblogger March 8, 2023No Comments

Interview Questions Oracle

Overview of the User Global Area

The UGA is session memory, which is memory allocated for session variables, such as logon information, and other information required by a database session. Essentially, the UGA stores the session…

asrblogger March 7, 2023No Comments

Core DBA Interview Questions Oracle

What is Checkpoint ?

A checkpoint is an operation that Oracle performs to ensure data file consistency. When a checkpoint occurs, Oracle ensures all modified buffers are written from the data buffer to disk…

asrblogger February 5, 2023No Comments

Core DBA Interview Questions Oracle

Read-only user Creation.

Sometimes the DBA requires to create the read-only user for a particular schemas.While creating the user,one should always keep in mind that the user should have minimum privileges. There is…

asrblogger January 15, 2023No Comments

Interview Questions Oracle

ORA-01653: Adding, Resizing of datafiles in Oracle

Datafiles are part of the Oracle Database, these are the files that have the actual data in them. Datafiles can be located on ASM or file system on disk. So…

asrblogger December 31, 2022No Comments

DataGuard Interview Questions

Important Parameters in Data Guard

DB_NAME On a primary database, specify the name used when the database was created. On a physical standby database, use the DB_NAME of the primary database. DB_UNIQUE_NAME Specify a unique…