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

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

687

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

602

What are the requirements of simple database?

610

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?

630

What command is used to type files to the screen?

635

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

646

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

605

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?

719

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?

661

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

601

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

667

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

625

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

609

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

739

What is an artificial (derived) primary key?

660

Un-Answered Questions { Oracle }

How to create Drill down report?

2189

all steps of bitmap report?

2398

How do I know if oracle is installed on windows?

996

What are the differences between number and binary_float in oracle?

1155

What are the variable types?

685

How many types of dimensions in oracle?

609

What are the different types of trigger and explain its various uses and functions?

1176

What do you understand by the oracle?

596

What is an Oracle Data Dictionary?

1166

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

2390

What is the difference between recovery and restoring of the oracle database?

1298

What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?

677

How do you prevent oracle from giving you informational messages during and after a sql statement execution?

639

How can you find all the processes on your system?

617

What does >> do?

637

For More Un-Answered { Oracle } Questions Click Here