Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

How many anonymous blocks can be defined?

1115

How to load data through external tables?

1082

How to create a table index?

1077

How to assign data of the deleted row to variables?

1018

How to work with data objects interactively?

929

How to add a new column to an existing table with a default value?

977

How to get a list of all tables in the database?

1 4222

How to set up autotrace for a user account?

988

How to run the anonymous block again?

1072

How to see the table columns used in an index?

974

How to drop an index?

920

What happens to the current transaction if the session is killed?

937

How to define an external table with a text file?

1027

How to get a list of all user accounts in the database?

1037

How to define a sub function?

1095

Un-Answered Questions { Oracle }

What is connection pooling in oracle?

921

Where does the clusterware write when there is a network or storage issue?

What are the tools provided in oracle enterprise manager?

What is supporting issues GL AP and AR?

2477

How you find which is the latest record in SCD type2 transformation?

550

Who is a database user?

488

What is partitioned table in Oracle?

1120

What are the types of schemas?

539

what is tripstop report?

1775

How to create sequence in odi?

613

How to connect the oracle server as sysdba?

1023

Why do we need a database?

550

What is the advantage of using rman?

671

What is the most common database language that a db administrator needs to know?

529

Difference between open_form and call_form in oracle.

1106

For More Un-Answered { Oracle } Questions Click Here