Oracle SQL and PLSQL skills are a must for any Oracle database developer today. Furthermore, because of the standard nature of the SQL language syntax, one can use these skills even for working with a MS SQL Server database as well. Additionally, there is a huge demand for Oracle SQL and PLSQL skills in any Oracle related software development position. One any given day one can find 200+ new job vacancies for Oracle SQL,…"Oracle SQL and PLSQL with Performance Tuning Training"
1. How to get the running Oracle version? Ans : select * from v$version; 2. How to get the time zone under which the DB is running? Ans: select dbtimezone from dual; SQL> select dbtimezone from dual; DBTIME —— +00:00 3. When an user process fails for any reason, which background process cleans it up? Ans: PMON (Process Monitor) 4. Which background process refreshes the materialized views? Ans : Job Queue Processes. …"Oracle SQL Interview Questions"