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?

636

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

548

What are the requirements of simple database?

570

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?

589

What command is used to type files to the screen?

594

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

606

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

563

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?

689

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?

609

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

554

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

625

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

584

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

569

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

683

What is an artificial (derived) primary key?

613

Un-Answered Questions { Oracle }

Is insert autocommit in oracle?

1068

What is Data Dictionary Cache in Oracle?

1163

How many categories of data types?

994

How can we use tkprof?

How can we collect the statistics of different database objects?

How to create id with auto_increment on oracle?

990

TILL WHAT LEVEL OF SECURITY BO SUPPORTS?

3576

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

558

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

1020

How to set up autotrace for a user account?

1059

How do you set up tablespaces during an oracle installation?

606

What do you mean by database normalization and why is it important?

How can you use check constraints for self referential integrity?

969

How to start a new transaction in oracle?

1087

How to define an external table with a text file?

1067

For More Un-Answered { Oracle } Questions Click Here