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 4222

How to set up autotrace for a user account?

988

How to run the anonymous block again?

1075

How to see the table columns used in an index?

974

How to drop an index?

920

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

937

How to define an external table with a text file?

1029

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

1041

How to define a sub function?

1096

How to define a data field as not null?

1072

How to enter a new row into a table interactively?

974

How to build data dictionary view an new database?

968

How to get a create statement for an existing table?

922

How to pass parameters to procedures?

983

How to use "in" parameter properly?

1014

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to run queries on external tables?

998

Explain an exception and its types?

1030

Which are the five query types available in oracle?

913

What is program global area (pga) in oracle?

974

What are the uses of a database trigger?

942

What is a schema in oracle?

977

How to loop through data rows in the implicit cursor?

1024

Describe varray?

1009

What is oracle join syntax?

954

How is it different from a normal table?

981

What is a snapshot log?

962

How does one get the view definition of fixed views/tables?

975

What is oracle data type?

913

What is ceil and floor in oracle?

1021

What do you understand by database schema and what does it hold?

1189

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