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 the difference between formal parameters and actual parameters?

1018

How to view the dropped tables in your recycle bin?

1 1406

How to define an anonymous procedure without variables?

1036

How many data types are supported?

1035

How to connect to the server with user account: sys?

981

How to define default values for formal parameters?

998

What are the restrictions on external table columns?

1002

What privilege is needed for a user to insert rows to tables in another schema?

965

How to loop through data rows in the implicit cursor?

1024

How to create additional tablespaces for an new database?

981

How many categories of data types?

945

Can you assign multiple query result rows to a variable?

938

How to use fetch statement in a loop?

987

What is the use of the drop option in the alter table command?

560

How do you use automatic pga memory management with oracle 9i and above?

542

Un-Answered Questions { Oracle }

What is oracle rownum?

897

Where would you look to find out if a redo log was corrupted assuming you are using oracle mirrored redo logs?

483

What is Segment Advisor in Oracle?

1061

What file will give you oracle instance status information? Where is it located?

573

Why we use bulk collect in oracle?

983

What is a recovery catalog?

There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

1989

How to create a stored program unit?

1140

What does the no logging option do? Why would we be careful of using it?

563

How to change system global area (sga) in oracle?

968

What is an agent and What are the types of agents?

583

What is a trigger and what are its types?

1135

What is the purpose of tables, private synonyms and public synonyms in Oracle?

995

Explain the truncate in oracle?

921

Which is better Oracle or MS SQL? Why?

6279

For More Un-Answered { Oracle } Questions Click Here