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

Can we create trigger on view in oracle?

1 1270

Can we create trigger on materialized view in oracle?

946

Does oracle partitioning improve performance?

951

What are the different types of partitions in oracle?

922

What are the types of partitions in oracle?

986

What is a partition in oracle?

1051

How can I see all tables in oracle?

963

Can we store images in oracle database?

954

Does facebook use oracle?

991

What are the advantages of oracle 12c?

1133

What are the advantages of oracle?

969

What is oracle used for?

980

What is the max number of columns in an oracle table?

946

What is the use of oracle?

995

Why is oracle so popular?

945

Un-Answered Questions { Oracle }

How view is different from a table?

980

does odi support web services?

533

what is the difference between restoring and recovering?

971

Difference between vat and property class.

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

955

State the various uses of dbcc command?

997

Explain user account with reference to oracle.

937

How to load data through external tables?

1083

What is the relation between database and instance?

597

State all possible different index configurations a table can possibly have?

955

Explain the blob datatype?

1028

I am new to sas, can anybody explain the process of extracting data from source systems,storing in ods and how data modelling is done?

When do I need to use a semicolon vs a slash in oracle sql?

1040

What is da in database?

500

Describe an oracle table?

1002

For More Un-Answered { Oracle } Questions Click Here