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?

1095

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?

999

What are the ansi data types supported in oracle?

947

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

1016

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 }

What is bind variables in oracle reports?

Explain procedure to change characterset of a database.

631

What is an oracle user role?

984

What do you understand by the term 'system change number (scn)'?

582

Explain table?

1113

What is an oracle table?

988

What is ASM (Automatic Storage Management) in Oracle?

1196

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1987

What is BBED in Oracle?

1153

How many types of knowledge Modules? Where are used in km?

621

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1999

How to define an anonymous procedure without variables?

1106

what are steps for interface? where is exchange rate defined in which table?

2158

What are the requirements of simple database?

570

how to handle exceptions in post production

1424

For More Un-Answered { Oracle } Questions Click Here