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?

886

What is instant client oracle?

977

How can I create database in oracle?

963

What language does oracle use?

1056

How do I manually uninstall oracle client?

1033

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

961

What is the database name in oracle?

977

Why do we need oracle client?

894

How do I know if oracle is installed on windows?

886

How do I uninstall oracle 11g?

1047

What is oracle instant client?

976

What is oracle sid?

899

How do I start tns listener?

992

What is tns entry?

1071

What is tns name?

932

Un-Answered Questions { Oracle }

what is difference between sql plus and sql*plus? (not sql and sql plus).

3832

Explain how one can iterate through items and records in a specified block?

1035

How to uncatalog backup?

508

What are the parameters that we can pass through a stored procedure?

1004

How do I connect to oracle?

982

Explain what are the characteristics of data files?

1038

what happened to the global index when I truncate the data in one of the partition?

1968

various types of hints and their usage

2632

Which profile required to access ODI Console?

557

What is different types of joins?

975

How can you tell if a tablespace has excessive fragmentation?

557

What is difference between co-related sub query and nested sub query?

532

where do u put the report file

2048

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

1882

Where do we use decode and case statements?

947

For More Un-Answered { Oracle } Questions Click Here