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 4278

How to set up autotrace for a user account?

1059

How to run the anonymous block again?

1132

How to see the table columns used in an index?

1024

How to drop an index?

959

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

988

How to define an external table with a text file?

1069

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

1087

How to define a sub function?

1130

How to define a data field as not null?

1108

How to enter a new row into a table interactively?

1012

How to build data dictionary view an new database?

1009

How to get a create statement for an existing table?

969

How to pass parameters to procedures?

1034

How to use "in" parameter properly?

1071

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Explain parameter file in oracle.

1029

What is oracle server autotrace in oracle?

1166

How to define an external table with a text file?

1069

Calculate difference between 2 date / times in oracle sql?

1040

What is an Oracle index?

1655

How to convert characters to numbers in oracle?

1065

What is primefaces used for?

1049

How index is implemented in oracle database?

1006

Explain a synonym?

1029

What is memory advisor in Oracle?

1077

What is pragma autonomous transaction in oracle?

1070

Explain the blob datatype?

1071

what is IDE,DMV in sql server?

2819

can u plz provide me oca sql dumps please i need them

1948

What is a table index in oracle?

1131

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