Oracle Technical Interview QA - FAQ

Toad for Oracle I am using Toad for Oracle for long time for my projects. Here, I have listed out few tricks and tips and issues/solution which I faced during my work. I happy to share this post ...

http://oracle-faq-qa.blogspot.com/2014/04/toad-for-oracle-issues-solutions-tricks.html

How to find dependencies referenced Inside PL/SQL Store Procedure The Oracle data dictionary tracks the object types referenced in PL/SQL with the dba_dependencies view. To track the dependency a...

http://oracle-faq-qa.blogspot.com/2012/02/plsql-interview-qa-2012-part4.html

What is difference between Materialized View and Materialized Log? Materialized views are schema objects that can be used to summarize, precompute, replicate, and distribute data. E.g. to constru...

http://oracle-faq-qa.blogspot.com/2011/05/plsql-q-2011-part-3.html

Where is the alert log files located on Oracle11g? The alert.log file normally is in the $ORACLE_BASE//bdump location Oracle 11g in the database specific location in the diagnostic_dest. Run the ...

http://oracle-faq-qa.blogspot.com/2011/05/latest-interview-qa-for-plsql-with.html

Oracle Forms – Technical – Interview – Question Answers What are the Various Master and Detail Relation ships. The various Master and Detail Relationship are a) NonIsolated = The Master can...

http://oracle-faq-qa.blogspot.com/2011/04/oracle-forms-interview-questions_12.html

racle Reports - Technical Interview Questions & Answers How many different triggers are available in Report? There are five types of triggers in report 6i 1) Before report trigger 2) After re...

http://oracle-faq-qa.blogspot.com/2011/04/oracle-reports-interview-questions.html

What are the vbx controls? Vbx control provide a simple method of building and enhancing user interfaces. The controls can use to obtain user inputs and display program outputs.vbx control where ...

http://oracle-faq-qa.blogspot.com/2011/04/oracle-forms-interview-questions.html

Do you have your own Blog or Website? Try PuppyURL - Free and Automated Directory Submission.Level: IntermediateWhat are the components of Physical database structure of Oracle Database?.ORACLE d...

http://oracle-faq-qa.blogspot.com/2011/04/dba-basic-part-1.html

What is the use of Control File ?When an instance of an ORACLE database is started, its control file is used to identify the database and redo log files that must be opened for database operation...

http://oracle-faq-qa.blogspot.com/2011/04/dba-basic-part-2.html

Do you have your own Blog or Website? Try PuppyURL - Free and Automated Directory Submission.SCRIPT COLLECTION - How-to find global name of your database?ora9i$maran> select * from global_name...

http://oracle-faq-qa.blogspot.com/2011/04/useful-scripts-collection-part-1.html

What is PL/SQL ?PL/SQL is a procedural language that has both interactive SQL and proceduralprogramming language constructs such as iteration, conditional branching. What is the basic structure o...

http://oracle-faq-qa.blogspot.com/2011/04/plsql-q_12.html

What is Raise_application_error ?Raise_application_error is a procedure of package DBMS_STANDARD which allows toissue an user_defined error messages from stored sub-program or database trigger.Wh...

http://oracle-faq-qa.blogspot.com/2011/04/plsql-q.html

What is difference between TRUNCATE & DELETE ?TRUNCATE commits after deleting entire table i.e., can not be rolled back.Database triggers do not fire on TRUNCATEDELETE allows the filtered del...

http://oracle-faq-qa.blogspot.com/2011/04/sqlplus-and-sql-part-2.html

Do you have your own Blog or Website? Try PuppyURL - Free and Automated Directory Submission. what is Table ? A table is the basic unit of data storage in an ORACLE database. The tables of a data...

http://oracle-faq-qa.blogspot.com/2011/04/sqlplus-and-sql-part-1.html

Display the number value in Words SQL> select sal, (to_char(to_date(sal,'j'), 'jsp')) from emp; the output like, SAL (TO_CHAR(TO_DATE(SAL,'J'),'JSP')) --------- -------------------------------...

http://oracle-faq-qa.blogspot.com/2011/04/sqlplus-and-sql-part-3.html