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

Explain can a view based on another view?

1 1460

Explain what are the advantages of views?

1026

Explain what are clusters?

1068

Explain a data segment?

1033

Explain what are the uses of rollback segment?

975

What is sequence?

1031

Explain what are the characteristics of data files?

1046

Explain how are indexes update?

1038

Explain table?

1083

Explain what are the type of synonyms?

1068

Explain what are synonyms used for?

996

Explain a segment?

1046

Explain database link?

1072

Explain an integrity constrains?

1102

Explain the use of control file?

1079

Un-Answered Questions { Oracle }

What happens to indexes if you drop a table?

1128

What is a Garbage Collection? and what is full recursive Garbage collection?

2867

Can you assign multiple query result rows to a variable?

943

Explain the blob datatype?

1035

How can I get column names from a table in oracle?

1004

What privilege is needed for a user to create tables in oracle?

920

Is there a combination of "like" and "in" in sql?

1026

1) Does oracle have any table which contain all the exceptions and it's code internally?

1716

What is the difference between sga and pga?

572

TILL WHAT LEVEL OF SECURITY BO SUPPORTS?

3509

Can we protect our pl/sql source code?

1008

How to Truncate Table in Oracle

1115

Can objects of the same schema reside in different tablespace?

1019

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

2071

What is variable? What is Flow of variable?

578

For More Un-Answered { Oracle } Questions Click Here