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?

1100

How to write date and time interval literals in oracle?

1034

How to drop a stored procedure in oracle?

1051

How to lock and unlock a user account in oracle?

1106

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?

1150

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?

1165

How to use subqueries in the from clause in oracle?

1112

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

1028

How to create a new table in oracle?

1156

Un-Answered Questions { Oracle }

Any work done in oracle workflow builder. Did you customize or build a new workflow?

How to add a new column to an existing table with a default value?

1016

What are record groups ? Explain the types of record group.

How to convert numbers to characters in oracle?

1030

Differentiate between function and procedure in oracle.

1076

Explain an index segment?

1118

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

What is the simplest tool to run commands on oracle servers?

1009

can u give guidance abt packages of plsql

2174

How data locks are respected in oracle?

1071

How to create tables for odbc connection testing?

1117

Mention how can you determine what protocol is being used for interconnect traffic?

What is set verify off in oracle?

1103

What are the four Oracle system processes that must always be up and running for the database to be useable?

1017

How to create a table interactively?

1090

For More Un-Answered { Oracle } Questions Click Here