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 use select statement to count the number of rows in oracle?

997

How does oracle handle read consistency?

1054

What is the oracle implicit cursor?

1010

What is a subquery in oracle?

1046

What are group functions in oracle?

984

How to check the oracle tns settings?

996

How to delete a user account in oracle?

920

How can windows applications connect to oracle servers?

992

How to write date and time literals in oracle?

956

How to create a new view in oracle?

1018

How to insert a new row into a table in oracle?

1103

What is a database schema in oracle?

1063

What is open database communication (odbc) in oracle?

956

How to drop an index in oracle?

1024

What is a read only transaction in oracle?

975

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What privilege is needed for a user to delete rows from tables in another schema?

1022

Explain the difference between sap and oracle?

984

Explain the truncate in oracle?

917

Why does oracle 9i treat an empty string as null?

983

What is the difference between $oracle_base and $oracle_home?

1036

How to use "while" statements in oracle?

1240

1) Does oracle have any table which contain all the exceptions and it's code internally?

1707

How to lock and unlock a user account in oracle?

1035

What is a nested table and how is it different from a normal table?

991

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

2148

How to define an external table with a text file?

1025

What is system tablespace?

1049

What happens to the indexes if a table is recovered?

948

How to rename a tablespace in oracle?

1038

How to start an oracle instance?

959

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