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 4223

How to set up autotrace for a user account?

989

How to run the anonymous block again?

1077

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?

975

How to build data dictionary view an new database?

969

How to get a create statement for an existing table?

922

How to pass parameters to procedures?

985

How to use "in" parameter properly?

1014

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How will you identify oracle database software release?

955

What is oracle rownum?

897

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1963

Why is oracle used?

892

How to start instance with a minimal initialization parameter file?

1000

What is the quickest way to fetch the data from a table?

1009

material view and view disadvantages?

1023

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1860

Explain view?

988

How to invoke the data pump import utility?

1089

Explain about your project and its relation to the current job position you are applying to?

953

What are temporal data types in oracle?

1080

Will you be able to store pictures in the database?explain.

940

How to import one table back from a dump file?

982

What is oracle rowcount?

1043

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