Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1803)
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?

601

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

660

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

619

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

600

How do you generate file output from sql?

669

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

634

What is the finger command?

620

What does >> do?

637

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

639

How can you find all the processes on your system?

617

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

621

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

604

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

646

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

617

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

640

Un-Answered Questions { Oracle }

In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??

1916

How to check your oracle database 10g xe installation?

1053

What do you understand from cache fusion?

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2376

Is it possible to split the print reviewer into more than one region ?

2345

What are the differences between char and varchar2 in oracle?

1251

Is there an oracle sql query that aggregates multiple rows into one row?

1032

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1990

What are the conditions kept in mind while connecting the oracle rac with the network?

What is an oracle and why it is used?

1220

What is the simplest tool to run commands on oracle servers?

1057

How would you determine who has added a row to a table?

2389

what is the scripts in data base?

2224

What do you mean by group by clause?

1097

If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)

622

For More Un-Answered { Oracle } Questions Click Here