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?

549

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?

590

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?

564

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.

585

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 }

Where does the clusterware write when there is a network or storage issue?

How do I become a database administrator?

572

How to estimate disk space needed for an export job?

1050

How to connect to a remote server?

1125

How to define a specific record type?

1084

How to write date and time interval literals in oracle?

1035

How to use "if" statements on multiple conditions?

1174

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2159

How to create an initialization parameter file?

1049

What to do if dba lost the system password?

1172

What is a data lock in oracle?

1119

What is package and main advantages?

606

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

601

What is bind variables in oracle reports?

Why packages are used in oracle?

1066

For More Un-Answered { Oracle } Questions Click Here