Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

How to write a left outer join with the where clause in oracle?

1084

How to count duplicated values in a column in oracle?

1039

What are the differences between char and nchar in oracle?

1096

How to install oracle odbc drivers?

1093

What is a table index in oracle?

1131

How to grant create session privilege to a user in oracle?

1000

What are the ansi data types supported in oracle?

947

How to filter out duplications in the returning rows using oracle?

1018

How to specify default values in insert statement using oracle?

1104

What is an oracle database table?

1015

What is an oracle user account?

990

How to change system global area (sga) in oracle?

1013

How to commit the current transaction in oracle?

1120

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

1009

How to check the server version in oracle?

1092

Un-Answered Questions { Oracle }

How to create a table in a specific tablespace?

976

How do you analyze the tables

Describe an oracle table?

1049

What is procedure overloading in oracle?

1061

What are the tools provided in oracle enterprise manager?

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

1020

What is the Repository and how many types of repository?

575

suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables

2022

How to apply filtering criteria at group level in oracle?

1042

Explain the use of control file?

1113

material view and view disadvantages?

1073

How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

3200

Is truncate autocommit in oracle?

1087

1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count

17641

How do you bind variables in oracle?

980

For More Un-Answered { Oracle } Questions Click Here