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 4281

How to set up autotrace for a user account?

1061

How to run the anonymous block again?

1135

How to see the table columns used in an index?

1024

How to drop an index?

966

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

991

How to define an external table with a text file?

1076

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

1090

How to define a sub function?

1139

How to define a data field as not null?

1116

How to enter a new row into a table interactively?

1015

How to build data dictionary view an new database?

1015

How to get a create statement for an existing table?

975

How to pass parameters to procedures?

1039

How to use "in" parameter properly?

1077

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Query to retrieve record for a many to many relationship ?

2523

How to create a testing table in oracle?

995

what is reindexing?

1683

What is oracle sid?

957

How to view all columns in an existing table?

938

is there a tool to trace queries, like profiler for sql server?

1145

What is MTTR advisor in Oracle?

1092

Is it possible to insert comments into sql statements return in the data model editor ?

2570

Differentiate between post-database commit and post-form commit?

1049

how do u setup a replication site?

1992

How to convert csv to table in oracle?

994

Why do we need oracle client?

959

What is a oracle database?

1062

What is Reduced List of Values?

2174

How to create lov dynamically at runtime & attach to text field?

1209

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