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

The system administrator tells you that the system has not been rebooted in 6 months, should he be proud of this?

524

How can you find your id on a system?

526

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

510

The system has a program that always includes the word nocomp in its name, how can you determine the number of processes that are using this program?

540

You have installed oracle and you are now setting up the actual instance. You have been waiting an hour for the initialization script to finish, what should you check first to determine if there is a problem?

566

Why are recursive relationships bad? How do you resolve them?

536

You see the following on a status report: redo log space requests 23 redo log space wait time 0 is this something to worry about? What if redo log space wait time is high? How can you fix this?

568

When configuring sqlnet on the client what files need to be set up?

593

A user is getting an ora-00942 error yet you know you have granted them permission on the table, what else should you check?

518

How can you determine the space left in a file system?

606

You have taken import of a table in a database. You have got the integrity constraint violation error. How you are going to resolve it.

550

Can you remove an open file under unix?

652

How can you determine if an oracle instance is up from the operating system level?

523

When should you increase copy latches?

590

How to uncatalog backup?

512

Un-Answered Questions { Oracle }

Can sub procedure/function be called recursively?

961

What is a canvas in oracle forms?

1035

What is key.next.item trigger?

What are roles in oracle?

527

What is oracle archived redo log?

550

What is oracle d2k?

How to create an oracle database manually?

1034

now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd

2254

Which directory will you copy your new custom form, what would be its extension (.fmb or .fmx)?

nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

2160

What do you understand by a database object? Can you list a few of them?

985

What is the string concatenation operator in oracle?

1116

Which is faster join or subquery in oracle?

944

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2224

List the types of joins used in writing subqueries?

953

For More Un-Answered { Oracle } Questions Click Here