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?

583

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?

586

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?

574

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

555

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 }

Explain a segment?

1087

How do you bind variables in oracle?

980

What is analyze command used for?

1072

What are the file systems and volume management techniques used in oracle rac?

what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable

1126

How would you begin to troubleshoot an ORA-3113 error?

2078

What is the difference between truncate and delete? How would a full table scan behave after?

552

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

583

What suggestions do you have to reduce the network traffic?

961

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

574

I would like to study certification course in Data base adminidtrator then where would i go to study this course?

2184

What is oracle latest version?

1096

What is user managed backup in Oracle?

1142

what is dynamic SGA and static SGA

4417

How to connect to a local oracle 10g xe server?

992

For More Un-Answered { Oracle } Questions Click Here