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

Explain about stacked canvas views?

2 11458

what are the different objects that you cannot copy or reference in object groups?

1 3998

What are the triggers available in the reports?

3 5547

List some built-in routines used to manipulate images in image_item?

1 4454

What are modalless windows?

1 4309

Which of the two views should objects according to possession?

1 4477

Can a repeating frame be careated without a data group as a base?

2 5019

What is an anchoring object & what is its use?

2 5425

What is the built-in function used for finding the alert?

1 4355

What is the built_in routine used to count the no of rows in a group?

1 5614

How can a text file be attached to a report while creating in the report writer?

1 3728

Can a formula column refered to columns in higher group?

1 3983

What are the built_in used to trapping errors in forms 4?

1 4168

What is the Symbol use for Inner Join

Oracle, TCS,

1 13500

How do you use trigger to create mutating state of table

TCS,

2 7189

Un-Answered Questions { Oracle }

How to write date and time literals in oracle?

1052

What is meant by a deadlock situation?

1156

How to load data from multiple files to single target?

611

What happens if a tablespace clause is left off of a primary key constraint clause?

623

What is meant by recursive hints in oracle?

1135

Does my odi infrastructure require an oracle database?

608

Explain table?

1178

What are the extensions used by oracle reports?

1096

What is pragma autonomous transaction in oracle?

1128

What are the main functions of dba?

622

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

1091

Teradata: How can we know the indexed column in a table?

1948

What degree do database administrators need?

601

What is an SQL FORMS ?

2841

What are referenced objects? Explain the importance of referencing.

For More Un-Answered { Oracle } Questions Click Here