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 privilege is needed for a user to create tables in oracle?

915

How to drop an existing view in oracle?

910

What happens if you set the sga too low in oracle?

1073

How to delete multiple rows from a table in oracle?

1020

How to create a table index in oracle?

1091

What is an oracle function?

1093

How to use subqueries in the from clause in oracle?

1059

What privilege is needed for a user to create indexes in oracle?

977

How to create a new table in oracle?

1086

How to resolve name conflicts between variables and columns?

989

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

1049

How to rename an index?

1014

What is the scope of a local variable?

1012

What privilege is needed for a user to query tables in another schema?

934

How to initialize variables with default values?

1180

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is flashback in Oracle?

975

How to write date and time literals in oracle?

961

How to concatenate two text values in oracle?

1064

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

2059

What are the different types of modules in oracle forms?

963

Can you have more than one content canvas view attached with a window ?

2276

Hi Can any one tell me what are the API's used in requisition import.

1888

Can select statements be used on views in oracle?

997

material view and view disadvantages?

1023

What do database buffers contain?

977

How to convert a date to char in oracle? Give one example.

1013

What is an oracle data file?

1053

List the various oracle database objects?

1008

How to empty your oracle recycle bin?

994

What is ceil and floor in oracle?

1021

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