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 write a query with a left outer join in oracle?

1006

How many categories of data types in oracle?

969

What are the oracle built-in data types?

1018

What is a read write transaction in oracle?

1036

How to create an oracle database?

980

How to count groups returned with the group by clause in oracle?

1016

What is an oracle tablespace?

993

What is a dynamic performance view in oracle?

955

How to execute a stored procedure in oracle?

1035

How to apply filtering criteria at group level in oracle?

993

How to define and use table alias names in oracle?

888

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

1013

How to start a new transaction in oracle?

1020

How to connect asp pages to oracle servers?

1011

How to create a new tablespace in oracle?

938

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How would you go about verifying the network name that the local_listener is currently using?

2000

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1866

What are the differences between number and binary_float in oracle?

1062

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

2299

What is a connect identifier?

988

How to create a new table in oracle?

1079

Explain what are the type of synonyms?

1061

What is meant by joins?

1021

Does oracle charge for java?

1015

Can we store pictures in the database and if so, how it can be done?

990

How to end the current transaction in oracle?

972

State the various uses of dbcc command?

994

When do I need to use a semicolon vs a slash in oracle sql?

1031

Can you tell me how to add new column in existing views?how?How is possible?

1381

What is parameterized cursor in oracle?

1073

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