image

Oracle Real time Interview Questions with Answer

1) How can you see the Current SCN number of the database? > Select current_scn from v$database; 2) How can you see the Current log sequence number the logwriter is writing in to? > Select * from v$log; 3) If you are given a database, how will you know how many datafiles each tablespace contain? … continue reading

image

where is oracle’s Alert Log located?

The alert log file (also referred to as the ALERT.LOG) is a chronological log of messages and errors written out by an Oracle Database. Typical messages found in this file is: database startup, shutdown, log switches, space errors, etc. This file should constantly be monitored to detect unexpected messages and corruptions. Oracle will automatically create … continue reading

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

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