Interview Questions

In which months oracle release CPU patches? JAN, APR, JUL, OCT When we applying single Patch, can you use opatch utility? Yes, you can use Opatch incase of single patch. The only type of patch that cannot be used with OPatch is a patchset. Is it possible to apply OPATCH without downtime? As you know … Read more

Oracle products follow a custom release-numbering and -naming convention. The “c” in the current release, Oracle Database 23c, stands for “Cloud”. Previous releases (e.g. Oracle Database 10g and Oracle9i Database) have used suffixes of “g” and “i” which stand for “Grid” and “Internet” respectively. Prior to the release of Oracle8i Database, no suffixes featured in … Read more

Oracle uses two different index architectures: b-Tree indexes and bitmap indexes. Cluster indexes, bitmap join indexes, function-based indexes, reverse key indexes and text indexes are all just variations on the two main types. b-Tree is the “normal” index . The “-Tree” in b-Tree A b-Tree index is a data structure in the form of a … Read more

What is use of INDEXFILE option in imp? Will write DDLs of the objects in the dumpfile into the specified file. What is use of IGNORE option in imp? Will ignore the errors during import and will continue the import. What are the differences between expdp and exp (Data Pump or normal exp/imp)? Data Pump … Read more

What is use of CONSISTENT option in exp? When you export a table, you are guaranteed that the contents of that table will be consistent with the time that the export of that table was started. This means that if you start exporting the table at 12:00 and someone makes changes to the data in … Read more

In Oracle Database, a redo log thread refers to a specific instance of redo log processing within the database. Redo logs are crucial components of a database system, responsible for recording changes made to data (such as inserts, updates, and deletes) in a sequential manner. These changes are logged in redo log files to ensure … Read more