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

Oracle General Interview Questions

Questions Answers Views Company eMail

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

1 4215

How to set up autotrace for a user account?

977

How to run the anonymous block again?

1068

How to see the table columns used in an index?

967

How to drop an index?

910

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

927

How to define an external table with a text file?

1021

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

1037

How to define a sub function?

1086

How to define a data field as not null?

1061

How to enter a new row into a table interactively?

964

How to build data dictionary view an new database?

960

How to get a create statement for an existing table?

908

How to pass parameters to procedures?

975

How to use "in" parameter properly?

1006

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is SQL Tuning Advisor in Oracle?

1112

How to define default values for formal parameters?

985

What are the different editions of oracle?

1053

Is oracle a programming language?

940

How to use an explicit cursor without open statements?

1015

How can we find out the duplicate values in an oracle table?

997

Which is better Oracle or MS SQL? Why?

6269

Explain oracle insert into command?

1058

Can we commit inside a function in oracle?

920

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

1900

How to start your 10g xe server from command line?

1001

In which language oracle has been developed?

1020

What is pragma autonomous transaction in oracle?

993

What are the types of trigger in oracle?

917

What to do if the startbd.bat failed to start the xe instance?

1021

For More Un-Answered { Oracle General } Questions Click Here