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?

917

How to drop an existing view in oracle?

912

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

1076

How to delete multiple rows from a table in oracle?

1024

How to create a table index in oracle?

1096

What is an oracle function?

1096

How to use subqueries in the from clause in oracle?

1062

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

981

How to create a new table in oracle?

1091

How to resolve name conflicts between variables and columns?

995

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

1051

How to rename an index?

1017

What is the scope of a local variable?

1015

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

936

How to initialize variables with default values?

1184

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What are the set operators union, union all, minus & intersect meant to do?

952

What is the simplest tool to run commands on oracle servers?

971

How to convert times to characters in oracle?

995

How to load excel data sheet to oracle database

982

Explain the use of rows option in exp command.

1044

How to drop a stored procedure in oracle?

1012

When system tablespace is created?

985

20. Using a set operator, display the client number of all clients who have never placed an order.

2150

What is the usage of control file in oracle?

1041

How do we get field details of a table?

943

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

2114

How to store only time; not date and time?

973

How to rebuild an index in oracle?

990

How to change program global area (pga) in oracle?

1045

What is Redo Log Buffer in Oracle?

1152

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