Oracle General Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General Interview Questions

Questions Answers Views Company eMail

Q1:code to connect to sql server(database) through jdbc application. Q2:code to connect to Mysql(database) through jdbc application. Q3:code to connect to oracle(database) through jdbc application.

1 4143

difference between oracle8i and oracle9i

NIIT,

4 10124

Explain 1st, 2nd, 3rd normalization form of data base

KH, Thermotech,

3 23017

What is different bet native dynamic sql and Dbms_Sql?

Thermotech,

4 16577

What is TNS File

Thermotech,

7 31967

What is flashback Query ? And Use ?

Thermotech,

4 9390

What is Trace File ?

Thermotech,

4 26185

What is forall Statement ?

Thermotech,

2 5952

Tell me New Feature of Oracle 10g?

Thermotech,

5 11027

Table Has C1 And C2 Column If Exits any record in c1 then Update c2 record Otherwise insert new record in the C1 And C2 (Using Procedure)

Thermotech,

4 7417

What is the diff between Oracle and SQL Server

1 4669

Maximum how many triggers can be updated in table ?

Accenture, Cap Gemini,

5 16512

Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

2186

which statement is running fastly ie insert or delete?

Oracle,

13 18940

9)When information has to be stored w.r.t employees and their respective departments, which of the following is the Correct formulation of entries? A)Employee and department would together be represented as an entity. B)This is too less information to decide on entities. C)An employee would be one entity and a department would be another. D)Such a scenario cannot be modelled in RDBMS

Mind Tree,

2 5490

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What are the major difference between truncate and delete?

1058

How to create a new user account in oracle?

1020

What is PL/SQL ?

2063

How to execute the package in oracle?

1082

What is the difference between sharding and partitioning?

986

ABOUT IDENTITY?

2058

How to define a variable to match a table column data type?

988

What are the execution control statements in oracle?

1095

How to delete a column in an existing table in oracle?

1072

Explain the types of exception?

1143

How to assign values to data fields in record variables?

1035

How to set up autotrace for a user account?

1059

What is clustered table in Oracle?

1196

what is Single Byte Overhead...?

2555

How to turn on or off recycle bin for the session?

1109

For More Un-Answered { Oracle General } Questions Click Here