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

Oracle General (1803)
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?

1134

How to count duplicated values in a column in oracle?

1109

What are the differences between char and nchar in oracle?

1148

How to install oracle odbc drivers?

1153

What is a table index in oracle?

1189

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

1055

What are the ansi data types supported in oracle?

993

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

1068

How to specify default values in insert statement using oracle?

1157

What is an oracle database table?

1065

What is an oracle user account?

1047

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

1072

How to commit the current transaction in oracle?

1191

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

1058

How to check the server version in oracle?

1145

Un-Answered Questions { Oracle }

How to use like conditions in oracle?

1118

Difference between 10g & 11g in odi?

827

How to view existing locks on the database?

1103

Explain the different types of queries created in reports?

What is coalesce function?

1149

What is the use of aggregate functions in oracle?

1077

How would you best determine why your MVIEW couldnt FAST REFRESH?

1935

How I can use srw.run_report in reports6i?

Explain the use of ignore option in imp command.

1090

How do you set up tablespaces during an oracle installation?

657

What is oracle host variable?

1139

What is instant client oracle?

1074

Can a Tablespace hold objects from different Schemes in Oracle?

1089

How to use an explicit cursor without open statements?

1104

How will you write a query to get a 5th rank student from a table student_report?

1926

For More Un-Answered { Oracle } Questions Click Here