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

Explain about stacked canvas views?

2 11353

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

1 3917

What are the triggers available in the reports?

3 5405

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

1 4376

What are modalless windows?

1 4216

Which of the two views should objects according to possession?

1 4397

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

2 4892

What is an anchoring object & what is its use?

2 5308

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

1 4257

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

1 5536

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

1 3630

Can a formula column refered to columns in higher group?

1 3908

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

1 4099

What is the Symbol use for Inner Join

Oracle, TCS,

1 13392

How do you use trigger to create mutating state of table

TCS,

2 7065

Un-Answered Questions { Oracle }

Can group functions be used in the order by clause in oracle?

992

How to define an explicit cursor in oracle?

1031

How to create tables for odbc connection testing?

1106

Is a rollback possible to any savepoint?

1094

Differentiate between pre-select and pre-query?

1102

What does the no logging option do? Why would we be careful of using it?

597

How to turn on or off recycle bin for the session?

1103

What is mutated trigger? In single user mode we got mutated error, as a dba how you will resolve it?

557

How can you use check constraints for self referential integrity?

963

What are the differences between char and nchar in oracle?

1084

What are the roles and responsibilities of oracle dba?

633

What is clustered table in Oracle?

1186

What is using clause and give example?

1031

How to get maxsal , minsal, ename department wise in single query

1546

What skills do you need to be an administrator?

558

For More Un-Answered { Oracle } Questions Click Here