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 4211

How to set up autotrace for a user account?

976

How to run the anonymous block again?

1066

How to see the table columns used in an index?

961

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?

1035

How to define a sub function?

1084

How to define a data field as not null?

1061

How to enter a new row into a table interactively?

963

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 }

How can we force the database to use the user specified rollback segment?

1069

Can select statements be used on views in oracle?

985

What is Java Pool in Oracle?

1094

How to use "in" parameter properly?

1006

Explain what are the different type of segments?

915

How to open and close an explicit cursor in oracle?

1002

Please explain joins in oracle?

1009

What is SQL access advisor in Oracle?

1138

What is a nested table?

1007

How to login to the server without an instance?

1106

How do I uninstall oracle 11g?

1044

How many anonymous blocks can be defined?

1104

What are the different types of trigger and explain its various uses and functions?

1010

How to drop a tablespace?

984

What is a user account in oracle?

1069

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