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

You have taken a manual backup of a datafile using os. How rman will know about it?

552

What is an artificial (derived) primary key? When should an artificial (or derived) primary key be used?

586

How many control files should you have? Where should they be located?

581

What are four common errors found in an alert .log?

563

How do you generate file output from sql?

619

You see multiple extents in the temporary tablespace. Is this a problem?

591

What is the finger command?

584

What does >> do?

585

How do you prevent oracle from giving you informational messages during and after a sql statement execution?

582

How can you find all the processes on your system?

570

What happens when the default and temp tablespace clauses are left out from create user statements?

573

What is pct free/pct used/pct increase parameter in segment? What is growth factor?

554

When looking at v$sysstat you see that sorts (disk) is high. Is this bad or good? If bad -how do you correct it?

601

What is pct free/pct used/pct increase parameter in segment?

576

What does a hard one-to-one relationship mean (one where the relationship on both ends is "must")?

593

Un-Answered Questions { Oracle }

What are the goals of dba?

558

How to create additional tablespaces for an new database?

1026

How to list all tables in your schema?

1053

What is the difference between view and materialized view in Oracle?

1152

if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure

2071

What is the sql query to find the employee who has Nth maximum salary?

5329

Explain the difference between replace() and translate() functions in oracle?

1036

What is the difference between oracle media recovery and crash recovery?

1174

can u give guidance abt packages of plsql

2174

What is an oracle cursor variable?

1075

What is Session Tasks?

601

what is the difference between substr and instr function in oracle?

1090

How can we tune a sql query to optimize the performance of a database?

What is sharded cluster?

1014

What is oracle rownum?

951

For More Un-Answered { Oracle } Questions Click Here