Oracle Technical Interview QA - FAQ

Toad for Oracle - Issues Solutions Tricks and Tips

2014-04-29T02:18:00.003-07:00

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 to help someone :) 1. Is there a way to disable the popup for Statement Processing window? The below solution for In case it is happening at the moment and want to cancel, the solution

PLSQL -Interview QA - 2012 - Part4

2012-02-22T03:44:00.001-08:00

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 among packages and tables, try this dictionary query: select referenced_owner, referenced_name, referenced_type from DBA_DEPENDENCIES where name= 'YOUR_PROCEDURE or

PL/SQL -Q&A - 2011 - Part 3

2011-05-11T02:24:00.000-07:00

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 construct a data warehouse or in multi-master replication environment. A materialized view is a database object that contains the results of a query. The FROM clause of the query can name tables, views, and

Latest Interview QA for PLSQL with basic DBA experience Part 1

2011-05-11T02:19:00.000-07:00

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 below query to find the location, select value from v$parameter where name='background_dump_dest'; One of the most vexing problems that Oracle DBAs around the world face every day? What is that?

Oracle Forms Interview Questions & Answers Part 1

2011-05-11T02:13:00.000-07:00

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 cannot be deleted when a child is existing b) Isolated = The Master can be deleted when the child is existing c) Cascading = The child gets deleted when the Master is deleted. What are the master-detail triggers

Oracle Reports Interview Questions & Answers Part 1

2011-04-12T03:02:00.000-07:00

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 report trigger 3) Before Parameter trigger 4) After parameter trigger 5) Between pages trigger What is the Firing sequence of report trigger? First the before parameter trigger will raise, after firing

Oracle Forms Interview Questions & Answers Part 2

2011-04-12T02:35:00.001-07:00

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 originally develop as extensions for the ms visual basic environments and include such items as sliders, rides and knobs.What is the "LOV of Validation" Property of an item? What is the use of it? When

PL/SQL -Q&A2

2011-04-12T02:34:00.009-07:00

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.What are the return values of functions SQLCODE and SQLERRM ?SQLCODE returns the latest code of the error that has occured.SQLERRM returns the relevant error message of the SQLCODE.Where the

PL/SQL -Q&A1

2011-04-12T02:34:00.007-07:00

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 of PL/SQL ?PL/SQL uses block structure as its basic structure. Anonymous blocks or nested blockscan be used in PL/SQL.Declarative part, Executable part and Execption part.Declaration;BeginExceptionEnd;What

Useful Scripts Collection Part 1

2011-04-12T02:34:00.005-07:00

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;GLOBAL_NAME-------------------------------------------------------tifa.prod.com.sgfind Primary key constraints for a given table name?ora9i$maran> Select2 c.CONSTRAINT_NAME as PCN , c.TABLE_NAME PTN,

DBA (Basic) Part 2

2011-04-12T02:34:00.003-07:00

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 to proceed. It is also used in database recovery.What does a Control file Contain ?A Control file records the physical structure of the database. It contains the following information.i. Database Nameii.

DBA (Basic) Part 1

2011-04-12T02:34:00.001-07:00

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 database is comprised of three types of files. One or more Data files, two are more Redo Log files, and one or more Control files.What are the components of Logical database structure of ORACLE database?

SQL*Plus and SQL - Part 2

2011-04-12T02:33:00.001-07:00

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 deletion. Deleted records can be rolled back or committed.Database triggers fire on DELETE.What is a join ? Explain the different types of joins ?Join is a query which retrieves related columns or rows from

SQL*Plus and SQL - Part 1

2011-04-12T02:29:00.001-07:00

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 database hold all of the user accessible data. Table data is stored in rows and columns.What is a View ?A view is a virtual table. Every view has a Query attached to it. (The Query is a SELECT statement that

SQL*Plus and SQL - Part 3

2011-03-11T02:33:00.000-08:00

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')) --------- ----------------------------------------------------- 800 eight hundred 1600 one thousand six hundred 1250 one thousand two hundred fifty If you want to add some text like, Rs. Three Thousand only. SQL> select sal "Salary ", ('

Forms 4.5/5.0/6.0/9i Techniques with Examples

2010-04-13T04:39:00.000-07:00

List of Forms: Generate INSERT Statements from existing Oracle tables Updated GenInster.zip V3.8 Dropping All Tables without drop/recreate user Popup LOV