-
Oracle JVM
How to use oracle JVM in Oracle 10g, installation and it's functionalities.How to run a java program on the SQL prompt?
-
Formatting Commands
What are the SQL formatting commands?
-
Register Forms in Oracle Application
How to register forms in oracle application 11i?
-
Cluster Index in Oracle
What is Cluster Index in Oracle?
-
Oracle Data Adapter
What is Data Adapter in Oracle?
-
Oracle Migration
How to migrate from Oracle to Teradata?
-
Autonomous Transaction
What are the disadvantages of Autonomous Transaction?
-
Spliting
What do you mean by spliting? Explain with example
-
Debug Oracle PL/SQL Package
How to Debug the Oracle PL/SQL Package?
-
Select Updated Values
Without Using Update Statement on Database how we can Select the Updated values on a Object(Table,View or etc..)?
-
Count Last Transaction Records
How to count the last transaction number of record in singal table?How to view uncommited transaction / uncommited record?
-
Record Focus
What is the built-in that tells you the record that the user is placed the fouces?
-
Partitioned Table
What is partitioned table in Oracle?
-
Improve Oracle Performance
How do you improve performance in Oracle?
-
Mutual Table
What is the Mutual Table?
-
Change LOV Dynamically
What is POST in D2K.How can you change the LOV Dynamically?
-
Exceptions
What do yo mean by exceptions? How many type of predefined exceptions are there & What are they?
-
Oracle Inventory
Where is Oracle Inventory located in Oracle 10g and 11i ?
-
Passing Record Group from Form to Report in D2k
How to run same report with different query through parameter
-
Compare Duplicate Tables
How to avoid Cartesian product comparing duplicate tables in SQL?
Oracle Basics Interview Questions
Ans