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

How can you find out how many users are currently logged into the database? How can you find their operating system id?

540

What happens if a tablespace clause is left off of a primary key constraint clause?

581

Discuss row chaining, how does it happen?

569

You get a call from you backup dba while you are on vacation. He has corrupted all of the control files while playing with the alter database backup controlfile command. What do you do?

604

How can you find dead processes?

539

I am getting error "no communication channel" after changing the domain name? What is the solution?

600

Discuss row chaining, how does it happen? How do you correct it?

549

You attempt to add a datafile and get: ora-01118: cannot add anymore datafiles: limit of 40 exceeded. What is the problem and how can you fix it?

598

What is tkprof and how is it used?

611

As an oracle dba what are the entire unix file you should be familiar with?

579

You are getting busy buffer waits. Is this bad? How can you find what is causing it?

537

Where does the clusterware write when there is a network or storage issue?

What is the difference between instance recovery and crash recovery?

What is the volume management techniques used in oracle rac?

What are the benefits of oracle rac?

Un-Answered Questions { Oracle }

What is difference between sid and service name in oracle?

956

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1884

What is a package ? What are the advantages of package ?

1091

What do you understand by the oracle?

551

WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

2113

How can be determining the size of the log files?

584

How to create sequence in odi?

650

what we specify the in XML data server and parameters for to connect to xml file?

700

Is it possible to have multiple layouts in a report?

1029

What is meant by raw datatype?

1060

What are the limitations of check constraint?

1033

What do you mean by merge in oracle and how can we merge two tables?

1049

What is a canvas in oracle forms?

1066

What is a trigger and what are its types?

1227

Give one method for transferring a table from one schema to another?

605

For More Un-Answered { Oracle } Questions Click Here