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 do a full database export?

853

How to bring a tablespace online?

744

Can group functions be mixed with non-group selection fields?

744

What is the relation of a user account and a schema?

873

How many file formats are supported to export data?

876

Why cursor variables are easier to use than cursors?

785

How to insert a record into a table?

834

How to define a variable to match a table column data type?

766

How to invoke the original export import utilities?

696

What is the difference between formal parameters and actual parameters?

740

How to view the dropped tables in your recycle bin?

1 1152

How to define an anonymous procedure without variables?

752

How many data types are supported?

818

How to connect to the server with user account: sys?

783

How to define default values for formal parameters?

784

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is oracle database client?

767

How to sort the query output in oracle?

811

Explain the use of grant option in exp command.

768

Why do we need oracle client?

689

What is the difference between alert log file and tarce file ?

1854

What is the difference between postgresql and oracle?

734

What is the sql query to concatenate column values from multiple rows in oracle?

802

How to apply filtering criteria at group level in oracle?

809

What is Java Pool in Oracle?

835

How to pass parameters to procedures?

752

Difference between inner join vs where ?

788

How to create lov dynamically at runtime & attach to text field?

884

How to set a transaction to be read only in oracle?

831

What is a trigger oracle?

804

Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

1880

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