CMS IT Services Oracle Database Administrator Interview Questions, Process, and Tips

Oracle architecture is a multi-tiered structure that includes the client, application server, and database server.

• Oracle architecture consists of multiple components such as the client, application server, and database server.

• The client sends requests to the application server, which in turn communicates with the database server.

• The database server manages the storage, retrieval, and manipulation of data.

• Oracle archite...read more

SGA (System Global Area) is a shared memory region that stores data and control information for an Oracle database. PGA (Program Global Area) is a memory region that stores data and control information for a single Oracle session or process.

• SGA is shared by all users and processes connected to the database

• SGA includes the database buffer cache, shared pool, and redo log buffer

• PGA is private to each individual session o...read more

Dataguard is a feature of Oracle Database that provides high availability, data protection, and disaster recovery.

• Dataguard is used to create and maintain one or more standby databases that can be used for failover or disaster recovery purposes.

• It works by continuously applying changes from the primary database to the standby database(s) to keep them synchronized.

• In case of a failure or disaster, the standby database c...read more

TNS is a network protocol used to connect to Oracle databases, while LISTENER is a process that listens for incoming connection requests.

• TNS (Transparent Network Substrate) is a protocol used to establish connections between clients and Oracle databases.

• LISTENER is a process that runs on the database server and listens for incoming connection requests.

• TNS resolves the service name to the database's network address, all...read more

To start RFS and MRP Service in Oracle Database, you can use the ALTER SYSTEM command.

• Connect to the Oracle Database as a user with SYSDBA or SYSOPER privilege.

• To start RFS (Remote File Server) Service, execute the following command: ALTER SYSTEM SET REMOTE_LISTENER='listener_name' SCOPE=SPFILE;

• To start MRP (Managed Recovery Process) Service, execute the following command: ALTER DATABASE RECOVER MANAGED STANDBY DATABAS