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

How do you display console on a window ?

1 4218

System.effective_date system variable is read only True/False

1 5098

What is the use of hidden column?

1 4734

What is the built-in used for showing lov at runtime?

1 4938

What are the two types views available in the object navigator?

1 4663

What are the two repeating frame always associated with matrix object?

1 4783

If two groups are not linked in the data model editor, What is the hierarchy between them?

1 8824

Why is a Where clause faster than a group filter or a format trigger?

1 4753

What does the term panel refer to with regard to pages?

1 4055

What is the difference when confine mode is on and when it is off?

1 4528

Does a Before form trigger fire when the parameter form is suppressed.

2 5246

To display the page no. for each page on a report what would be the source & logical page no. or & of physical page no.?

2 6079

What is a library in Forms 4.0?

1 3755

explain about content canvas views?

1 4240

What is the difference when Flex mode is mode on and when it is off?

1 5927

Un-Answered Questions { Oracle }

What is the scope of a local variable?

998

how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

1950

What is oracle d2k?

How to convert characters to dates in oracle?

1026

Can I create users through internet explorer in oracle 10g?

1020

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2433

How to define an external table with a text file?

1021

What are the different optimizers that are used to optimize database?

How to assign values to variables?

1046

Explain the different normalization forms?

1012

What is responsibility and how u attach How to create user and how u attach with responsibility.

1991

What is a snapshot log?

952

Explain implicit cursor.

963

Does oracle charge for java?

1008

Mention how oracle flex asm works?

For More Un-Answered { Oracle } Questions Click Here