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

Differentiate between function and procedure in oracle.

1074

Give the constructs of a package, function or a procedure.

1040

Which are the five query types available in oracle?

949

Explain parameter file in oracle.

1029

Is a rollback possible to any savepoint?

1094

Give the various rollback segment states.

1052

Explain cascading triggers.

1073

What do you mean by oracle dba and what is its role?

586

What is the advantage of using rman?

722

What are the beneficial tools for administering the database?

543

Which files are vital that should be backed up?

603

What do you understand by a control file?

560

What do you understand by recovery catalog?

567

What do you understand by the term 'system change number (scn)'?

582

What is the difference between a database and instance?

693

Un-Answered Questions { Oracle }

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

2043

How to delete multiple rows from a table in oracle?

1060

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4366

What are materialized views & where do we use them? What is a materialized view log?

Users are not being allowed on the system. The following message is received: ora-00257 archiver is stuck. Connect internal only, until freed. What is the problem?

610

What is execute immediate in oracle?

1021

Can we convert a date to char in oracle and if so, what would be the syntax?

1015

What is a subquery in oracle?

1109

What is oracle log switch?

619

How do I spool to a csv formatted file using sqlplus?

1033

What are internal user account in oracle?

1004

How do we get field details of a table?

978

What is an SQL FORMS ?

2788

Is there any link between pr form(purchse requisition)and po form(purchase order)

2722

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

7670

For More Un-Answered { Oracle } Questions Click Here