image

Oracle DBA Interview Questions, Oracle FAQ Questions? Part IV

61. What is the use of root.sh & oraInstRoot.sh? Ans: Changes ownership & permissions of oraInventory Creating oratab file in the /etc directory In RAC, starts the clusterware stack 62. What is transportable tablespace (and across platforms)? 63. How can you transport tablespaces across platforms with different endian formats? Ans: RMAN 64. What is xtss … continue reading

image

Oracle DBA Interview Questions/FAQs Part3

41. What are materialized view refresh types and which is default? Complete, fast, force(default) 42. How fast refresh happens? 43. How to find out when was a materialized view refreshed? Query dba_mviews or dba_mview_analysis or dba_mview_refresh_times SQL> select MVIEW_NAME, to_char(LAST_REFRESH_DATE,’YYYY-MM-DD HH24:MI:SS’) from dba_mviews; (or) SQL> select NAME, to_char(LAST_REFRESH,’YYYY-MM-DD HH24:MI:SS’) from dba_mview_refresh_times; (or) SQL> select MVIEW_NAME, … continue reading

image

Oracle DBA Interview Questions, Oracle FAQ Questions?

Oracle DBA Interview Questions/FAQs Part1 1. What is an instance? SGA + background processes. 2. What is SGA? System/Shared Global Area. 3. What is PGA (or) what is pga_aggregate_target? Programmable Global Area. 4. What are new memory parameters in Oracle 10g? SGA_TARGET PGA_TARGET 5. What are new memory parameters in Oracle 11g? MEMORY_TARGET 6. What … continue reading

Visit Us On FacebookVisit Us On Google PlusVisit Us On Youtube