i
Path Infotech
Filter interviews by
I applied via Recruitment Consulltant and was interviewed before Jan 2023. There were 4 interview rounds.
I applied via Approached by Company and was interviewed in Mar 2022. There were 2 interview rounds.
SGA is a shared memory area that stores data and control information for Oracle instance. Shared pool is a part of SGA that stores SQL statements and data dictionary cache.
SGA is a fixed size memory area allocated at instance startup
SGA contains database buffer cache, redo log buffer, shared pool, etc.
Shared pool stores frequently used SQL statements and data dictionary cache
Shared pool can be resized dynamically using
Buffer cache stores frequently accessed data in memory. Old archive logs can be deleted using RMAN commands.
Buffer cache is a portion of memory used to store frequently accessed data to reduce disk I/O
Oracle automatically manages the buffer cache size based on system resources and workload
To delete old archive logs in RMAN, use the DELETE ARCHIVELOG command with options like 'ALL' or 'COMPLETED BEFORE'
Example: DELETE A...
Some of the top questions asked at the Path Infotech Oracle Database Administrator interview for experienced candidates -
based on 12 reviews
Rating in categories
Programmer Analyst
96
salaries
| ₹3.8 L/yr - ₹12.5 L/yr |
Senior Programmer
70
salaries
| ₹3.5 L/yr - ₹11 L/yr |
Team Lead
65
salaries
| ₹6.7 L/yr - ₹15.4 L/yr |
DBA Consultant
51
salaries
| ₹5.2 L/yr - ₹10 L/yr |
Oracle Database Administrator
49
salaries
| ₹2 L/yr - ₹9 L/yr |
TCS
Wipro
Infosys
HCLTech