Thanks Akhil Mohan. Debasis Maity: 1.Why controlfile and redolog file multiplexed? Control file : A control file is a small binary file that records the physical structure of the database and includes: The database name. Names and locations of associated datafiles and online redo log files. The timestamp of the… Continue Reading Redo,Undo,Control file interview questions

OMS Server: Where runs the Enterprise Manager Middleware Client Server: Where we’re going to install the agent 1.Pre-requisites setup to be done in Client Server Create directory where agent will be installed in Client Server In Client,You need to create a directory or mount point as /u01/oemcc Install telnet in… Continue Reading Oracle 13c cloud control agent installation

 Answer Credit:- https://www.linkedin.com/in/skantali/ https://www.linkedin.com/in/hemant-shahi-59921762/ How we can execute PLSQL without any privilege to change it What are the default user created when Oracle is installed ? Can you create password less user in Oracle ? If yes how ? How we can see the procedure /package body with out having… Continue Reading Oracle user role and privilege interview questions

What is PGA The Program Global Area (PGA) is a private memory region that contains the data and control information for a server process. Only a server process can access the PGA. Oracle Database reads and writes information in the PGA on behalf of the server process. An example of… Continue Reading Oracle PGA (Program Global Area) in 12c

What are base tables? When and how they will get created? Ans:-Are read-only tables(Data Dictionary Tables) that hold information about the database. Base tables are own by SYS. When and how they will get created? They get created when the database is built. https://docs.oracle.com/cd/B19306_01/server.102/b14220/datadict.htm Why to execute catproc.sql script? Ans:-Used… Continue Reading Database Architecture Interview Questions

1.What are new features of datapump in 12c? https://oracle-base.com/articles/12c/data-pump-enhancements-12cr1 2.which case we need to use flashback_time or flashback_scn parameter? If you need consistent backup for example when you do initial load using datapump for golden gate. 3.During impdp with full=y caluse , do we need to create user before import?… Continue Reading EXPDP IMPDP Datapump interview questions

Listener related questions:- Answer Credit:- https://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 on a particular host (lets say – on node 5 of 5 node RAC) ? Ans:- srvctl relocate scan_LISTENER -i 1 -n node1 $ srvctl relocate scan -h Usage: srvctl… Continue Reading Generic DBA

Clustering Factor and it’s effect on non-assm and assm tablespace. The clustering factor is a measure of the ordernesss of an index in comparison to the table that it is based on. It is used to check the cost of a table lookup following an index access (multiplying the clustering… Continue Reading Clustering Factor and it’s effect on non-assm and assm tablespace