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 3942

How to set up autotrace for a user account?

792

How to run the anonymous block again?

829

How to see the table columns used in an index?

782

How to drop an index?

736

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

754

How to define an external table with a text file?

805

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

840

How to define a sub function?

875

How to define a data field as not null?

855

How to enter a new row into a table interactively?

756

How to build data dictionary view an new database?

786

How to get a create statement for an existing table?

750

How to pass parameters to procedures?

753

How to use "in" parameter properly?

815

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What are the different types of failures that occur in Oracle database?

832

How to select some rows from a table in oracle?

815

How oracle handles dead locks?

810

What is blob data type in oracle?

819

How do I limit the number of oracle database connections generated by weblogic server?

812

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

770

what is the difference between data migration and production migration.

2047

How to retrieve data from an cursor to a record?

755

What is proxy method?

727

Explain an index segment?

840

Can we write insert statement in function in oracle?

808

What are the uses of Database Trigger ?

1338

What happens in oracle commit?

766

Give the advantages and disadvantages of clusters.

784

What are transaction isolation levels supported by oracle?

779

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