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 add a new column to an existing table in oracle?

1074

How to select all columns of all rows from a table in oracle?

995

What is a server parameter file in oracle?

1006

How to use subqueries with the exists operator in oracle?

973

How to use values from other tables in update statements using oracle?

1026

How to recover a dropped table in oracle?

986

How to convert characters to times in oracle?

956

Where are the settings stored for each instance in oracle?

1065

What is an oracle cursor variable?

1013

How to change user password in oracle?

975

How to create a new user account in oracle?

956

How to start a specific oracle instance?

992

What is a dead lock in oracle?

1050

What are the differences between char and varchar2 in oracle?

1076

How to pass a parameter to a cursor in oracle?

1108

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

master table and child table performances and comparisons in Oracle ?

2074

Does oracle partitioning improve performance?

947

Please explain compound trigger in oracle?

997

What is logical backup in oracle?

969

How to create additional tablespaces for an new database?

972

How do we create privileges in oracle?

994

What is a database table in oracle?

962

Why is oracle so popular?

943

How to invoke the data pump export utility?

1118

What is a schema in oracle?

968

How many file formats are supported to export data?

1139

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2223

Explain the types of exception?

1083

How to work with data objects interactively?

927

What is a cursor variable?

1048

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