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

What is an oracle wallet?

944

What is instant client oracle?

1027

How can I create database in oracle?

1030

What language does oracle use?

1111

How do I manually uninstall oracle client?

1094

How do I know if oracle client is installed on windows?

1024

What is the database name in oracle?

1022

Why do we need oracle client?

958

How do I know if oracle is installed on windows?

931

How do I uninstall oracle 11g?

1123

What is oracle instant client?

1028

What is oracle sid?

957

How do I start tns listener?

1051

What is tns entry?

1162

What is tns name?

984

Un-Answered Questions { Oracle }

If you see contention for library caches how you can fix it?

566

Explain an index?

1140

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5414

What do database buffers contain?

1040

How to define a specific record type?

1088

What is a package ? What are the advantages of package ?

1093

What is a system tablespace and when it is created?

975

definition of cluster and non-clustered index?

3035

hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

2370

How you find which is the latest record in SCD type2 transformation?

592

What does an oracle dba do?

608

How do u print the data horizantally by using XML report? EX:Suppose there is one table names as SAMPLE in that we have only two columns say empno,ename.I want the output like this,At run time user may enter 3 colums(i.e to data print horizantally). empno ename empno ename empno ename 100 aaa 101 bbb 102 ccc 103 ddd 104 eee 105 fff

2217

What is temporary Interface( Yellow Interface) ?

567

How to clone the database using RMAN back

2245

What privilege is needed for a user to connect to oracle server?

994

For More Un-Answered { Oracle } Questions Click Here