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 4225

difference between oracle8i and oracle9i

NIIT,

4 10278

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

KH, Thermotech,

3 23166

What is different bet native dynamic sql and Dbms_Sql?

Thermotech,

4 16752

What is TNS File

Thermotech,

7 32219

What is flashback Query ? And Use ?

Thermotech,

4 9537

What is Trace File ?

Thermotech,

4 26350

What is forall Statement ?

Thermotech,

2 6037

Tell me New Feature of Oracle 10g?

Thermotech,

5 11208

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 7568

What is the diff between Oracle and SQL Server

1 4720

Maximum how many triggers can be updated in table ?

Accenture, Cap Gemini,

5 16669

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

2227

which statement is running fastly ie insert or delete?

Oracle,

13 19372

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 5613

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is truncate oracle?

1014

What is integrity and what is constraint??Explain with example

2338

Are truncate and delete commands same? If so why?

1201

what is dynamic SGA and static SGA

4486

I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

2380

What is a sub query? Describe its types?

1071

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

2285

Why does oracle 9i treat an empty string as null?

1127

Explain the difference between sap and oracle?

1085

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4414

State any two functions of oracle?

1096

What is partitioned table in Oracle?

1267

What is memory advisor in Oracle?

1131

Whats the benefit of dbms_stats over analyze?

2064

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

2061

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