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

List the parts of a database trigger.

990

Explain oracle’s server parameter file.

949

Explain overloading. Can functions be overloaded?

937

Give the advantages and disadvantages of clusters.

997

Define oracle database

993

Explain oracle instance.

1107

What is ceil and floor in oracle?

1011

Can a parameter be passed to a cursor?

1053

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

1012

Explain user account with reference to oracle.

929

Explain constraining triggers.

1045

What is the maximum limit on the number of columns in a table?

1010

Why do you create or replace procedures rather that drop and recreate.

948

How would you change old and new values in an insert, delete and update triggers?

953

Explain oracle’s system global area (sga).

1076

Un-Answered Questions { Oracle }

Query to retrieve record for a many to many relationship ?

2460

How to store pictures on to the database?

923

When should you increase copy latches? What parameters control copy latches?

525

How to use subqueries with the in operator using oracle?

1032

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

970

Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?

1935

How to see the table columns used in an index?

961

How to get a create statement for an existing table?

908

What is rich query?

929

If you see statistics that deal with "undo" what are they really talking about?

604

HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

2467

What are the data management skills?

498

Is oracle dba in demand?

537

What does a dba stand for?

522

How to retrieve data from an cursor to a record?

1019

For More Un-Answered { Oracle } Questions Click Here