Oracle General Interview Questions
Questions Answers Views Company eMail

what are the database links ?

2 3751

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

1 3196

what are different types of locks?

6 6632

master table and child table performances and comparisons in Oracle ?

1650

what are the different types of cursors? explain?

4 8428

what are different types of deletes?

1 2934

can a view be updated?

3 8700

what is pragma?

2 5271

can you write commit in triggers?

4 9619

can u call user defined functions in select statements

2 4281

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

2 6086

After update how do u know how many records got updated

TCS,

4 6990

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

2 4085

how many columns can a plsql table have

NIIT,

13 17558

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

3 4795


Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is a partition in oracle?

534


What is the meaning of recursive hints in oracle?

519


What are the various types of snapshots ?

551


Explain what are clusters?

601


What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4000






how do u setup a replication site?

1482


How many types of tables are there in oracle?

568


What is bulk copy or bcp in oracle?

596


What do database buffers contain?

557


How to delete a column in an existing table?

578


What is a cursor in oracle?

634


How to define an anonymous block?

605


Explain table?

636


What is a view and how is it different from a table?

564


What are set operators?

638