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?

523

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

544

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

541

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

511

How do you generate file output from sql?

573

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

557

What is the finger command?

546

What does >> do?

546

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

539

How can you find all the processes on your system?

529

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

543

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

513

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

565

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

537

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

556

Un-Answered Questions { Oracle }

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

539

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

4513

Where do we use connected and un connected lookups?

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

2266

What is the difference between cold backup and hot backup?

550

Explain each trigger related to mouse.

What is a dba programmer?

528

What is oracle rowcount?

1045

i want to know rdbms certification details and syallabus and for whom i contact for rdbms certification in bangalore i need answer very urgent please mail to aniltelkar50@gmail.com please as soon as possible

2316

Hi Can any one tell me what are the API's used in requisition import.

1890

What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable

1155

When configuring sqlnet on the client what files need to be set up?

593

Explain the use of grant option in imp command.

973

in the package one interface got failed how to know which interface got failed if we no access to operator?

577

Is the After report trigger fired if the report execution fails ?

2881

For More Un-Answered { Oracle } Questions Click Here