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

Give two examples of referential integrity constraints.

1 4870

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

3 15191

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

HCL,

1 8188

What command would you use to create a backup control file?

1 8773

Give the stages of instance startup to a usable state where normal users may access it.

1 5205

How would you go about generating an EXPLAIN plan?

Satyam,

1 4936

How would you go about increasing the buffer cache hit ratio?

2659

Explain an ORA-01555

2 7160

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

2 7779

How would you determine the time zone under which a database was operating?

1 5293

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 4474

What command would you use to encrypt a PL/SQL application?

1 11034

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

TCS,

10 55183

Explain the use of table functions.

2588

Name three advisory statistics you can collect.

1 8370

Un-Answered Questions { Oracle }

What is concurrency in oracle?

1061

Why we use oracle d2k?

You see multiple fragments in the system tablespace, what should you check first?

627

What is the volume management techniques used in oracle rac?

What is oracle dba role?

622

Explain oracle insert into command?

1160

How to upsert (update or insert into a table)?

1044

In workflow how can we send a notification to the Supplier giving the Corresponding report Details.

1965

What is hot backup and logical backup?

1117

How to use subqueries with the exists operator in oracle?

1071

What is catalog in Oracle?

1443

Mention what is new feature in oracle asm 12c?

How to delete multiple rows from a table in oracle?

1119

State and explain about oracle instance?

1053

What is the purpose of the grep command?

2198

For More Un-Answered { Oracle } Questions Click Here