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 connect to a local oracle 10g xe server?

992

How to use subqueries with the in operator using oracle?

1091

Can select statements be used on views in oracle?

1027

How to use "while" statements in oracle?

1325

How to sort the query output in oracle?

1028

How to use null as conditions in oracle?

1084

How to use "for" statements in oracle?

1074

How to use group functions in the select clause using oracle?

1071

What is transport network substrate (tns) in oracle?

1047

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

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is SQL Tuning Advisor in Oracle?

1179

How to run create database statement again?

1154

How to start your 10g xe server from command line?

1073

How do I uninstall oracle client from windows?

1010

What is a directory object?

1097

How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

2178

What is the purpose of save points in oracle database?

1118

What is proxy method?

971

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1933

Explain a synonym?

1028

How would you begin to troubleshoot an ORA-3113 error?

2077

How a database is related to tablespaces?

1031

types of indexes and the rationale behind choosing a particular index for a situation.

2510

What is a trigger and what are its types in oracle?

1072

How to do paging with oracle?

999

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