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/FAQs Part2

21. What is a datafile? Every Oracle database has one or more physical datafiles. Datafiles contain all the database data. The data of logical database structures such as tables and indexes is physically stored in the datafiles allocated for a database. 22. What are the contents of control file? Database name, SCN, LSN, datafile locations, … continue reading

Visit Us On FacebookVisit Us On Google PlusVisit Us On Youtube