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?

489

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

538

Discuss row chaining, how does it happen?

529

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?

566

How can you find dead processes?

512

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

551

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

504

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?

546

What is tkprof and how is it used?

561

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

547

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

505

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 }

How to rename an index in oracle?

1079

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

2272

What is data type in oracle?

1062

What is Session Tasks?

560

What is an Oracle Instance?

1086

Explain coalesce function?

1140

What view would you use to determine free space in a tablespace?

2177

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

515

What are the restrictions in a oracle read only transaction?

983

How to use "if" statements on multiple conditions?

1125

Is primary key indexed by default in oracle?

947

How to compare dates in oracle sql?

1065

What happens to the current transaction if the session is ended?

1051

What types of joins are used in writing subqueries?

947

How can we identify the resources for which the sessions are waiting?

For More Un-Answered { Oracle } Questions Click Here