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

Oracle General (1803)
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?

1259

How to load data through external tables?

1192

How to create a table index?

1234

How to assign data of the deleted row to variables?

1120

How to work with data objects interactively?

1045

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

1061

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

1 4347

How to set up autotrace for a user account?

1115

How to run the anonymous block again?

1181

How to see the table columns used in an index?

1075

How to drop an index?

1016

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

1043

How to define an external table with a text file?

1129

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

1134

How to define a sub function?

1206

Un-Answered Questions { Oracle }

What is the mandatory setup in cyclecount ?

2810

How to shutdown your 10g xe server?

1208

How to install oracle odbc drivers?

1150

What is an oracle database?

1113

What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?

677

How do you analyze the tables

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

1043

Why are recursive relationships bad? How do you resolve them?

629

What is meant by joins?

1112

What is the difference between substr and instr?

1093

how to dynamically change the page size of d2k reports?

What is oracle analytical function?

1239

What is not equal to in oracle?

1052

How to use "in out" parameter properly?

1108

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

2364

For More Un-Answered { Oracle } Questions Click Here