Redo,Undo,Control file interview questions
Thanks Akhil Mohan. Debasis Maity: 1.Why controlfile and redolog file multiplexed? Control file : A control file is a small…
7 years ago
BUFFER CACHE DEMYSTIFIED CBC EXPLAINED
7 years ago
Oracle License Cost Calculation basics
Author:-//www.linkedin.com/in/maheshsrikakula/ Oracle License Cost Calculation basics How to enable/disable oracle license features at Binary Level
7 years ago
Oracle 13c cloud control agent installation
OMS Server: Where runs the Enterprise Manager Middleware Client Server: Where we’re going to install the agent 1.Pre-requisites setup to…
7 years ago
Oracle user role and privilege interview questions
Answer Credit:- //www.linkedin.com/in/skantali/ //www.linkedin.com/in/hemant-shahi-59921762/ How we can execute PLSQL without any privilege to change it What are the default user…
7 years ago
Oracle PGA (Program Global Area) in 12c
What is PGA The Program Global Area (PGA) is a private memory region that contains the data and control information…
7 years ago
Database Architecture Interview Questions
What are base tables? When and how they will get created? Ans:-Are read-only tables(Data Dictionary Tables) that hold information about…
7 years ago
EXPDP IMPDP Datapump interview questions
1.What are new features of datapump in 12c? //oracle-base.com/articles/12c/data-pump-enhancements-12cr1 2.which case we need to use flashback_time or flashback_scn parameter? If…
7 years ago
Generic DBA
Listener related questions:- Answer Credit:- //www.linkedin.com/in/saibal-ghosh-ccsk-prince2-%C2%AE-469b0a7/ 1.Can we manually force a particular scan ip (out of the three) to relocate…
7 years ago
Clustering Factor and it’s effect on non-assm and assm tablespace
Clustering Factor and it's effect on non-assm and assm tablespace. The clustering factor is a measure of the ordernesss of…
7 years ago