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

What are the differences between number and binary_float in oracle?

1101

How to write date and time interval literals in oracle?

1036

How to drop a stored procedure in oracle?

1051

How to lock and unlock a user account in oracle?

1107

How to convert characters to numbers in oracle?

1065

What are the differences between blob and clob in oracle?

1089

What privilege is needed for a user to create tables in oracle?

953

How to drop an existing view in oracle?

946

What happens if you set the sga too low in oracle?

1153

How to delete multiple rows from a table in oracle?

1060

How to create a table index in oracle?

1134

What is an oracle function?

1166

How to use subqueries in the from clause in oracle?

1113

What privilege is needed for a user to create indexes in oracle?

1028

How to create a new table in oracle?

1158

Un-Answered Questions { Oracle }

What is an artificial (derived) primary key? When should an artificial (or derived) primary key be used?

588

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

549

What are object group?

How do you set up tablespaces during an oracle installation?

606

Explain the use of rows option in imp command.

1087

How to import one table back from a dump file?

1025

What is the difference between internal & external schema?

758

What is the page protect in reports?

What is the dba role in oracle?

577

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

2051

How does oracle handle read consistency?

1098

Give the advantages and disadvantages of clusters.

1051

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

606

What is explain plan and how is it used?

608

How to run the anonymous block again?

1132

For More Un-Answered { Oracle } Questions Click Here