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

List the parts of a database trigger.

1051

Explain oracle’s server parameter file.

995

Explain overloading. Can functions be overloaded?

987

Give the advantages and disadvantages of clusters.

1050

Define oracle database

1045

Explain oracle instance.

1180

What is ceil and floor in oracle?

1069

Can a parameter be passed to a cursor?

1126

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

1068

Explain user account with reference to oracle.

990

Explain constraining triggers.

1096

What is the maximum limit on the number of columns in a table?

1086

Why do you create or replace procedures rather that drop and recreate.

1007

How would you change old and new values in an insert, delete and update triggers?

1022

Explain oracle’s system global area (sga).

1139

Un-Answered Questions { Oracle }

what are savepoint mode and cursor mode properties ?

Which database is best to learn?

568

Describe an oracle table?

1049

Which date function is used to find the difference between two dates?

578

How does one coalesce free space?

550

How does oracle handle read consistency?

1097

What happens when the default and temp tablespace clauses are left out from create user statements?

575

What command is used to type files to the screen?

594

What is the difference between sharding and partitioning?

986

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2256

How to check the oracle tns settings?

1047

What do you understand by the oracle?

551

Mention what is the function of cache fusion in oracle rac?

What is the difference between primary key and unique key and foreign key in oracle?

982

What happens to the current transaction if a ddl statement is executed?

1013

For More Un-Answered { Oracle } Questions Click Here