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?
This post was tagged with the following: Database Interview Questions, Oracle Dba Interview Questions, Oracle Faq, Oracle Forms Interview Questions, Oracle Pl/Sql Interview Questions, Pl/Sql Interview Questions, Sql Interview Questions, Unix Interview Questions