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 4317

System.effective_date system variable is read only True/False

1 5185

What is the use of hidden column?

1 4839

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

1 5057

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

1 4764

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

1 4875

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

1 8916

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

1 4850

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

1 4134

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

1 4634

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

2 5353

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 6215

What is a library in Forms 4.0?

1 3845

explain about content canvas views?

1 4306

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

1 6010

Un-Answered Questions { Oracle }

Where would you look to find out if a redo log was corrupted assuming you are using oracle mirrored redo logs?

523

how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

2057

Explain user account with reference to oracle.

973

Explain the use of rows option in exp command.

1086

1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

1965

What os user should be used for the first part of an oracle installation (on unix)?

544

What is the format trigger?

how can you pass values to-and-fro from foreign function?

How can we expand Parameter Form Canvas on Reports 6i?

2415

How to write a query with a right outer join in oracle?

1160

What privilege is needed for a user to delete rows from tables in another schema?

1064

How can I learn oracle dba?

559

If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?

588

What is an oracle wallet?

937

What is an SQL FORMS ?

2782

For More Un-Answered { Oracle } Questions Click Here