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

Oracle General Interview Questions

Questions Answers Views Company eMail

what are the database links ?

2 4880

does the query needs a hint to access a materialized view?

1 3942

what are different types of locks?

6 8793

master table and child table performances and comparisons in Oracle ?

2194

what are the different types of cursors? explain?

4 10411

what are different types of deletes?

1 3862

can a view be updated?

3 9900

what is pragma?

2 6865

can you write commit in triggers?

4 11016

can u call user defined functions in select statements

2 5445

can you call insert/update/delete in select statements. If yes how? If no what is the other way?

2 7082

After update how do u know how many records got updated

TCS,

4 8543

select statement does not retrieve any records. what exception is raised?

2 5773

how many columns can a plsql table have

NIIT,

13 21840

what is load balancing and what u have used to do this?(sql loader)

3 6184

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is sequence?

1136

State all possible different index configurations a table can possibly have?

1100

How to define a specific record type?

1136

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2440

How many categories of data types?

1041

can anyody please send me the dump for Oracle 10g certifications for DBA path?

2194

How remove data files before opening a database?

1133

What operating systems are supported by oracle database 10g xe?

1085

Explain about functional dependency and its relation with table design?

1059

How to view all columns in an existing table?

979

Difference between inner join vs where ?

1096

How to check the oracle tns settings?

1087

In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

1982

There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

2084

What is oracle instant client?

1067

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