Oracle Interview Questions -27

Oracle Interview Questions -27

Q.What is a User_exit?

Calls the user exit named in the user_exit_string. Invokes a 3Gl program by name which has been properly linked into your current oracle forms executable.

Q.Does one need to drop/ truncate objects before importing? (for DBA)
Before one import rows into already populated tables, one needs to truncate or drop these tables to get rid of the old data. If not, the new data will be appended to the existing tables. One must always DROP existing Sequences before re-importing. If the sequences are not dropped, they will generate numbers inconsistent with the rest of the database. Note: It is also advisable to drop indexes before importing to speed up the import process. Indexes can easily be recreated after the data was successfully imported.

Q.Can you use a commit statement within a database trigger?

Q.What WHERE CURRENT OF clause does in a cursor?
SELECT num_credits INTO v_numcredits FROM classes
WHERE dept=123 and course=101;
UPDATE students
FHKO;;;;;;;;;SET current_credits=current_credits+v_numcredits

Q.What are various joins used while writing SUBQUERIES?
Self join-Its a join foreign key of a table references the same table. Outer Join--Its a join condition used where One can query all the rows of one of the tables in the join condition even though they don't satisfy the join condition.
Equi-join--Its a join condition that retrieves rows from one or more tables in which one or more columns in one table are equal to one or more columns in the second table.

Q.Display the records between two range?
select rownum, empno, ename from emp where rowid in (select rowid from emp where rownum <=&upto minus select rowid from emp where rownum<&Start);

Q.Differentiate between TRUNCATE and DELETE?
TRUNCATE deletes much faster than DELETE
It is a DDL statement
It is a DML statement
It is a one way trip, cannot ROLLBACK
One can Rollback
Doesn't have selective features (where clause)
Doesn't fire database triggers
It requires disabling of referential constraints.

Q.What are different Oracle database objects?

Q.What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?

Procedures and Functions,Packages and Database Triggers.

Q.What are the advantages of having a Package ?
Increased functionality (for example,global package variables can be declared and used by any proecdure in the package) and performance (for example all objects of the package are parsed compiled, and loaded into memory once)

Q.Give the structure of the procedure ?
PROCEDURE name (parameter list.....)
local variable declarations
Executable statements.
exception handlers

Q.What is OEM (Oracle Enterprise Manager)? (for DBA)
OEM is a set of systems management tools provided by Oracle Corporation for managing the Oracle environment. It provides tools to monitor the Oracle environment and automate tasks (both one-time and repetitive in nature) to take database administration a step closer to "Lights Out" management.

Q.What is a Check Box?
A Check Box is a two state control that indicates whether a certain condition or value is on or off, true or false. The display state of a check box is always either "checked" or "unchecked".

Q.What is a canvas-view?
A canvas-view is the background object on which you layout the interface items (text-items, check boxes, radio groups, and so on.) and boilerplate objects that operators see and interact with as they run your form. At run-time, operators can see only those items that have been assigned to a specific canvas. Each canvas, in term, must be displayed in a specific window.

Q.What are the built_in used to trapping errors in forms 4?
Error_type return character
Error_code return number
Error_text return char
Dbms_error_code return no.
Dbms_error_text return char

Q.What is the most important module in Oracle Financials? (for DBA)
The General Ledger (GL) module is the basis for all other Oracle Financial modules. All other modules provide information to it. If you implement Oracle Financials, you should switch your current GL system first.GL is relatively easy to implement. You should go live with it first to give your implementation team a chance to be familiar with Oracle Financials.

Q.What triggers are associated with the radio group?
Only when-radio-changed trigger associated with radio group
Visual Attributes.

Q.List some built-in routines used to manipulate images in image_item?

Q.What are the triggers associated with the image item?
When-Image-activated(Fires when the operator double clicks on an image Items)
When-image-pressed(fires when the operator selects or deselects the image item)

Q.How do you pass the parameters from one form to another form?
To pass one or more parameters to a called form, the calling form must perform the following steps in a trigger or user named routine execute the create_parameter_list built-in function to programmatically. Create a parameter list to execute the add parameter built-in procedure to add one or more parameters list. Execute the call_form, New_form or run_product built_in procedure and include the name or id of the parameter list to be passed to the called form.

Q.What is an Alert ?
An alert is window that appears in the middle of the screen overlaying a portion of the current display.

Q.Deleting a page removes information about all the fields in that page ?
a. True. b. False
a. True.

Q.Can we use GO-BLOCK package in a pre-field trigger ?

Q.Can we create two blocks with the same name in form 3.0 ?

Q.How many pages you can in a single form ?

Q.While specifying master/detail relationship between two blocks specifying the join condition is a must ?
True or False. ?

Q.What is the use of GRANT option in IMP command ?

A flag to indicate whether grants on database objects will be imported.

Q.What are the different methods of backing up oracle database ?
- Logical Backups
- Cold Backups
- Hot Backups (Archive log)

Q.What is the use of ROWS option in EXP command ?
Flag to indicate whether table rows should be exported. If 'N' only DDL statements for the database objects will be created.

Q.What is the use of COMPRESS option in EXP command ?
Flag to indicate whether export should compress fragmented segments into single extents.


Post a Comment