Oracle Interview Questions
Questions Answers Views Company eMail

List the parts of a database trigger.

790

Explain oracle’s server parameter file.

761

Explain overloading. Can functions be overloaded?

793

Give the advantages and disadvantages of clusters.

795

Define oracle database

800

Explain oracle instance.

905

What is ceil and floor in oracle?

810

Can a parameter be passed to a cursor?

816

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

824

Explain user account with reference to oracle.

765

Explain constraining triggers.

848

What is the maximum limit on the number of columns in a table?

768

Why do you create or replace procedures rather that drop and recreate.

756

How would you change old and new values in an insert, delete and update triggers?

777

Explain oracle’s system global area (sga).

873


Un-Answered Questions { Oracle }

how to do daily transactions with out sql* loader control file regesterd in apps?

1450


How to invoke the data pump import utility?

843


What is snapshot is too old? Give and example for better understand.

1329


Explain table?

859


What is a snapshot in oracle database?

781


What is a table in oracle?

729


How do I use os authentication with weblogic jdriver for oracle and connection pools?

786


How to omit columns with default values in insert statement in oracle?

823


What are the different pseudo commands? Explain in general?

806


What is ELT? Or What is the difference between ODI and other ETL Tools?

505


What is archive log in Oracle?

837


What are the differences between char and varchar2 in oracle?

813


What is the difference between substr and instr?

725


what is the odi console?

465


How does one create a new database?

423