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 SYSTEM tablespace and When is it Created?

2 7581

Explain the relationship among Database, Tablespace and Data file?

4 12633

What is schema?

Bodhi Global Services, Cognizant, HCL,

41 63292

What are Schema Objects ?

2 5525

Can objects of the same Schema reside in different tablespaces.?

3 9401

Can a Tablespace hold objects from different Schemes ?

3 7595

what is Table ?

2 5269

What is a View ?

3 6523

Do View contain Data ?

10 23514

Can a View based on another View ?

3 11811

What are the advantages of Views ?

3 10194

What is a Sequence ?

3 6920

What is a Synonym ?

3 7067

What are the type of Synonyms?

1 5839

What is a Private Synonyms ?

1 5013

Un-Answered Questions { Oracle }

What is the dba role in oracle?

577

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

1021

What is a dynamic performance view in oracle?

994

In what script is snap$ created? In what script is the scott/tiger schema created?

2710

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2266

What are transaction isolation levels supported by oracle?

1072

The system has a program that always includes the word nocomp in its name, how can you determine the number of processes that are using this program?

581

What does dba stand for in technology?

548

How to pass parameters to procedures in oracle?

1042

What is a trigger and what are its types in oracle?

1074

What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.

3938

What are the system predefined user roles?

1043

What is the difference between sharding and replication?

1055

What is recycle bin in Oracle?

1153

How do I use os authentication with weblogic jdriver for oracle and connection pools?

1053

For More Un-Answered { Oracle } Questions Click Here