Oracle General Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General Interview Questions

Questions Answers Views Company eMail

What is a initialization parameter file in oracle?

993

How to unlock the sample user account in oracle?

933

How to rollback the current transaction in oracle?

992

What are the differences between date and timestamp in oracle?

995

How to pass parameters to procedures in oracle?

1005

What is system global area (sga) in oracle?

944

How to delete an existing row from a table in oracle?

1025

How to write numeric literals in oracle?

1134

How to write a query with a full outer join in oracle?

1 1414

What operating systems are supported by oracle database 10g xe?

991

How data locks are respected in oracle?

1020

What is program global area (pga) in oracle?

972

How to write an inner join with the where clause in oracle?

1016

How to list all user accounts in oracle?

987

What are dml statements in oracle?

1050

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2084

What is a proxy object?

1018

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

2229

How to check database size in Oracle?

1133

What is the difference between view and materialized view in Oracle?

1099

What is a trigger and what are its types?

1134

How to convert characters to numbers in oracle?

1013

What is the quickest way to export a table to a flat file?

928

Is java required for oracle client?

936

What is oracle latest version?

1044

State all possible different index configurations a table can possibly have?

955

What is coalesce function?

1022

How to rename a column in an existing table?

983

Can I create users through internet explorer in oracle 10g?

1028

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

939

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