Posted by admin on August 12, 2009 under Interviews | 
Are there any troubleshooting tips for OEM? (for DBA)
Can 2 functions have same name & input parameters but differ only by return datatype ?
Can functions be overloaded ?
Can one export a subset of a table? (for DBA)
Can one import tables to a different tablespace? (for DBA)
Can one improve the performance of SQL*Loader? (for DBA)
Can one load data into multiple tables at once? (for DBA)
Can one load variable and fix length data records? (for DBA)
Can one modify data as it loads into the database? (for DBA)
Can one monitor how fast a table is imported? (for DBA)
Can one selectively load only the records that one need? (for DBA)
Can one skip certain columns while loading data? (for DBA)
Can one write scripts to send alert messages to the console?
Can we define exceptions twice in same block ?
Can you call a stored function in the constraint of a table ?
Can you have two functions with the same name in a PL/SQL block ?
Can you have two stored functions with the same name ?
Can you pass parameters in packages ? How ?
Difference between SUBSTR and INSTR ?
ere can one get more information about TCL? (for DBA)
Explain UNION,MINUS,UNION ALL, INTERSECT ?
How can a cross product be created?
How can get SQL*Loader to COMMIT only at the end of the load file? (for DBA)
How does one backout events and jobs during maintenance slots? (for DBA)
How does one load multi-line records? (for DBA)
How does one start the Oracle Intelligent Agent? (for DBA)
How does one use SQL*Loader to load images, sound clips and documents? (for DBA)
How does one use the import/export utilities? (for DBA)
How does one use the SQL*Loader utility? (for DBA)
How is possible to restrict the user to a list of values while entering values for parameters?
Is there a SQL*Unloader to download data to a flat file? (for DBA)
Should the OEM Console be displayed at all times (when there are scheduled jobs)? (for DBA)
What are the constructs of a procedure, function or a package ?
What are the parts of a database trigger ?
What are the pre requisites ?
What are the triggers available in the reports?
What are the two ways to incorporate images into a oracle forms application?
What are the types of SQL Statement ?
What are the types of visual attribute settings?
What are the various types of database triggers ?
What are the various types of Exceptions ?
What are the various types of parameter modes in a procedure ?
What do you mean by a block in forms4.0?
What is a display item?
What is import/export and why does one need it? (for DBA)
What is Over Loading and what are its restrictions ?
What is SQL*Loader and what is it used for? (for DBA)
What is the difference between a procedure and a function ?
What is the difference between boiler plat images and image items?
What is the difference between the conventional and direct path loader? (for DBA)
What is the Oracle Intelligent Agent? (for DBA)
What kind of jobs can one schedule with OEM? (for DBA)
Why Create or Replace and not Drop and recreate procedures ?
Why is a Where clause faster than a group filter or a format trigger?
Posted by admin on under Interviews |
A table has the following data : [[5, Null, 10]]. What will the average function return ?
An insert statement followed by a create table statement followed by rollback ? Will the rows be inserted ?
Are views automatically updated when base tables are updated ?
Assume that there are multiple databases running on one machine. How can you switch from one to another ?
Can a trigger written for a view ?
Can Check constraint be used for self referential integrity ? How ?
Can database trigger written on synonym of a table and if it can be then what would be the effect if original table is accessed.
Can dual table be deleted, dropped or altered or updated or inserted ?
Can Long/Long RAW be clustered ?
Can null keys be entered in cluster index, normal index ?
Can one read/write files from PL/SQL?
Can one use dynamic SQL within PL/SQL? OR Can you use a DDL in a procedure ? How ?
Can views be specified in a trigger statement ?
Can you alter synonym of view or view ?
Can you create index on view ?
Can you increase the size of a tablespace ? How ?
Can you pass a parameter to a cursor ?
Can you Rollback to any savepoint ?
Can you use %RowCount as a parameter to a cursor ?
Consider a sequence whose currval is 1 and gets incremented by 1 by using the nextval reference we get the next number 2. Suppose at this point we issue an rollback and again issue a nextval. What will the output be ?
Definition of relational DataBase by Dr. Codd (IBM)?
Describe Oracle database’s physical and logical structure ?
For which relational operators in where clause, index is not used ?
How can I protect my PL/SQL source code?
How can you avoid indexes ?
If all the values from a cursor have been fetched and another fetch is issued, the output will be : error, last record or first record ?
If any other table same as dual is created would it act similar to dual?
If content of dual is updated to some value computation takes place or not ?
If I have an execute privilege on a procedure in another users schema, can I execute his procedure even though I do not have privileges on the tables within the procedure ?
If you insert a row in a table, then create another table and then say Rollback. In this case will the row be inserted ?
Is Sysdate a system variable or a system function?
Is there a limit on the size of a PL/SQL block?
Is there a PL/SQL Engine in SQL*Plus?
What all important parameters of the init.ora are supposed to be increased if you want to increase the SGA size ?
What are actual and formal parameters ?
What are cascading triggers? What is the maximum no of cascading triggers at a time?
What are constraining triggers ?
What are mutating triggers ?
What are the advantages of clusters ?
What are the advantages of Oracle ?
What are the disadvantages of clusters ?
What are the min. extents allocated to a rollback extent ?
What are the states of a rollback segment ? What is the difference between partly available and needs recovery ?
What are the types of Notation ?
What are the values of :new and 
ld in Insert/Delete/Update Triggers ?
What are the various types of queries ??
What are the various types of RollBack Segments ?
What are various types of joins ?
What is a forward declaration ? What is its use ?
What is a package cursor ?
What is a transaction ?
What is Auditing ?
What is implicit cursor and how is it used by Oracle ?
What is Multi Threaded Server (MTA) ?
What is PL/SQL?
What is the advantage of a stored procedure over a database trigger ?
What is the difference between a view and a synonym ?
What is the difference between alias and synonym ?
What is the difference between foreign key and reference key ?
What is the difference between unique key and primary key ?
What is the effect of synonym and table name used in same Select statement ?
What is the maximum no. of columns a table can have ?
What is the maximum no. of statements that can be specified in a trigger statement ?
What is the significance of the & and && operators in PL SQL ?
What is the use of Control files ?
What is the use of Data Dictionary ?
What’s the length of SQL integer ?
When to create indexes ?
Which are initial RDBMS, Hierarchical & N/w database ?
Which of the following is not a schema object : Indexes, tables, public synonyms, triggers and packages ?
Which symbol preceeds the path to the table in the remote database ?
While designing in client/server what are the 2 imp. things to be considered ?
Posted by admin on July 31, 2009 under Interviews |
A query fetched 10 records How many times does a PRE-QUERY Trigger and POST-QUERY Trigger will get executed ?
Can a root window be made modal?
Can we create two blocks with the same name in form 3.0 ?
Can we use a restricted package procedure in ON-VALIDATE-FIELD Trigger ?
Can we use GO-BLOCK package in a pre-field trigger ?
Can you attach an alert to a field?
Can you attach an lov to a field at design time?
Can you attach an lov to a field at run-time? if yes, give the build-in name.?
Can you change the alert messages at run-time?
Committed block sometimes refer to a BASE TABLE ?
Deleting a page removes information about all the fields in that page ?
Error_Code is a package proecdure ?
EXIT_FORM is a restricted package procedure ?
Give the equivalent term in forms 4.0 for the following. Page, Page 0?
Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?
Give the Types of modules in a form?
How can one optimize %XYZ% queries? (for DBA)
How do you control the constraints in forms ?
How do you pass the parameters from one form to another form?
How do you trap the error in forms 3.0 ?
How many maximum number of radio buttons can you assign to a radio group?
How many pages you can in a single form ?
Is a Key start up trigger fires as result of a operator pressing a key explicitly ?
Is it possible to attach same library to more than one form?
List some built-in routines used to manipulate images in image_item?
List system variables available in forms 4.0, and not available in forms 3.0?
List the built-in routine for controlling window during run-time?
List the built-in routine for controlling window during run-time?
List the editors available in forms 4.0?
List the system variables related in Block and Field?
List the Types of Items?
List the windows event triggers available in Forms 4.0?
My query was fine last week and now it is slow. Why? (for DBA)
Name the two files that are created when you generate the form give the filex extension ?
State the order in which these triggers are executed ?
Two popup pages can appear on the screen at a time ?Two popup pages can appear on the screen at a time ?
What are the different type of a record group?
What are the different types of key triggers ?
What are the different types of Package Procedure ?
What are the different types of windows?
What are the display styles of an alert?
What are the menu items that oracle forms 4.0 supports?
What are the triggers associated with a check box?
What are the triggers associated with the image item?
What are the type of User Exits ?
What are the types of Pop-up window ?
What are the types of TRIGGERS ?
What are the unrestricted procedures used to change the pop up screen position during run time ?
What built-in is used for changing the properties of the window dynamically?
What built-in is used for showing the alert during run-time?
What do you mean by a page ?
What does an on-clear-block Trigger fire?
What Enter package procedure does ?
What is a Layout Editor?
What is a list item?
What is a Package Procedure ?
What is a predefined exception available in forms 4.0?
What is a radio Group?
What is a Trigger ?
What is a visual attribute?
What is an Alert ?
What is an SQL *FORMS ?
What is an User Exits ?
What is the built-in function used for finding the alert?
What is the built-in routine used to count the no of rows in a group?
What is the built-in used to get and set lov properties during run-time?
What is the difference between a Function Key Trigger and Key Function Trigger ?
What is the difference between an ON-VALIDATE-FIELD trigger and a trigger ?
What is the difference between restricted and unrestricted package procedure ?
What is the difference between system.current_field and system.cursor_field ?
What is the maximum size of a form ?
What is the significance of PAGE 0 in forms 3.0 ?
What is the usage of an ON-INSERT,ON-DELETE and ON-UPDATE TRIGGERS ?
What package procedure used for invoke sql *plus from sql *forms ?
What the PAUSE package procedure does ?
What triggers are associated with the radio group?
When is cost based optimization triggered? (for DBA)
When should one rebuild an index? (for DBA)
Where can one find I/O statistics per table? (for DBA)
While specifying master/detail relationship between two blocks specifying the join condition is a must ?
Why is Oracle not using the damn index? (for DBA)
What built-in routines are used to display editor dynamically?
