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

Give two examples of referential integrity constraints.

1 4794

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 15026

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

HCL,

1 8042

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

1 8684

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

1 5121

How would you go about generating an EXPLAIN plan?

Satyam,

1 4841

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

2593

Explain an ORA-01555

2 7064

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

2 7661

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

1 5168

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 4380

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

1 10932

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

TCS,

10 54671

Explain the use of table functions.

2466

Name three advisory statistics you can collect.

1 8277

Un-Answered Questions { Oracle }

What is SQL Tuning Advisor in Oracle?

1170

What is ceil and floor in oracle?

1067

Explain what are the uses of rollback segment?

1004

What is the meaning of recursive hints in oracle?

1044

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

1009

What are operators in oracle?

1053

How to get a create statement for an existing table?

965

What are data pump export and import modes?

1060

Is there any function in oracle similar like group_concat of mysql?

1049

How do I manually create a database in oracle?

1014

Explain the use of grant option in imp command.

1020

Explain the purpose of oracle real application clusters (rac)?

How do I know if oracle client is installed on windows?

1019

Explain the wait events in statspack report 'db scattered read', 'db sequential real', 'enqueue'?

656

Explain procedure to change characterset of a database.

618

For More Un-Answered { Oracle } Questions Click Here