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 4279

How to set up autotrace for a user account?

1061

How to run the anonymous block again?

1134

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?

1138

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?

974

How to pass parameters to procedures?

1039

How to use "in" parameter properly?

1077

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to get last row id?

1001

How to drop an index in oracle?

1076

What are the various types of snapshots ?

1032

What are the differences between blob and clob in oracle?

1089

What do you mean by redo log file mirroring?

1036

Can a formula column be obtained through a select statement ?

2333

What is BBED in Oracle?

1161

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2299

What is ADDM Advisor in Oracle?

1183

What to do if dba lost the system password?

1176

Can you create a synonym without having a table?

1046

What are the components of logical database structure in oracle database?

1088

How to run create database statement?

1037

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

1100

1) Does oracle have any table which contain all the exceptions and it's code internally?

1754

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