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?

1184

How to load data through external tables?

1135

How to create a table index?

1147

How to assign data of the deleted row to variables?

1075

How to work with data objects interactively?

982

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

1016

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

1 4277

How to set up autotrace for a user account?

1059

How to run the anonymous block again?

1130

How to see the table columns used in an index?

1024

How to drop an index?

959

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

988

How to define an external table with a text file?

1067

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

1087

How to define a sub function?

1129

Un-Answered Questions { Oracle }

How do you analyze the tables

Which dba certification is best?

570

What is the scd? and Types of SCD?

623

How many dba can you have?

544

Explain alias?

1147

Explain the difference between a procedure and a function?

1169

What are four common errors found in an alert .log?

563

What is oracle forms system.currentblock?

What is the quickest way to export a table to a flat file?

968

What do you understand from cache fusion?

What is oracle full backup?

570

Where can you get a list of all initialization parameters for your instance? How about an indication if they are default settings or have been changed?

589

How to save query output to a local file?

1026

What are the types of trigger in oracle?

979

How to filter out duplications in the returning rows using oracle?

1016

For More Un-Answered { Oracle } Questions Click Here