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

When configuring sqlnet on the server what files must be set up?

594

I have applied the following commands: now what will happen, will the database will give an error / it will work?

517

What are the requirements of simple database?

527

Where can you get a list of all initialization parameters for your instance? How about an indication if they are default settings or have been changed?

542

What command is used to type files to the screen?

553

How can you find out how many users are currently logged into the database?

560

How can you determine if an index needs to be dropped and rebuilt?

525

A developer is trying to create a view and the database won’t let him. He has the "developer" role which has the "create view" system privilege and select grants on the tables he is using, what is the problem?

652

You look at your fragmentation report and see that smon has not coalesced any of you tablespaces, even though you know several have large chunks of contiguous free extents. What is the problem?

572

If you have an example table, what is the best way to get sizing data for the production table implementation?

510

What file will give you oracle instance status information? Where is it located?

573

A tablespace has a table with 30 extents in it. Is this bad? Why or why not.

524

How would you find total size of database in os level?

526

What is ora-1555 snapshot too old error? Explain in detail?

632

What is an artificial (derived) primary key?

571

Un-Answered Questions { Oracle }

What is a snapshot in oracle database?

983

What is an anonymous block?

1181

Mention in rac what files should be created on shared storage?

Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.

2293

What are the file storage options provided by oracle database for oracle rac?

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

7595

IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?

2220

WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

2895

i am having a report Jan to Dec are the columns if the present month is Mar only Mar to Dec columns should appear in report output

1949

defination of bitmap index

2061

How to update values in a table in oracle?

975

What is dba in sound level?

542

What is the use of lockboxes? : oracle accounts receivable

1167

How can I introduce multiple conditions in like operator?

939

Explain the use of show option in imp command.

1062

For More Un-Answered { Oracle } Questions Click Here