Oracle Interview Questions
Questions Answers Views Company eMail

What is private procedure oracle?

604

How many types of tables are there in oracle?

671

What is parameterized cursor in oracle?

695

How do I spool in oracle?

638

How do I recompile a procedure in oracle?

606

Can we call procedure inside function in oracle?

689

What are the data types in oracle?

658

What is set verify off in oracle?

696

What is oracle data type?

658

How do I connect to oracle database?

640

What is enter substitution variable in oracle?

658

Can we use bind variables in oracle stored procedure?

574

What is execute immediate in oracle?

630

Why do we use bulk collect in oracle?

667

How do I find the database name in oracle?

674


Un-Answered Questions { Oracle }

What happens to the current transaction if a ddl statement is executed?

666


What is the most important action a dba must perform after changing the database from noarchivelog to archivelog?

367


How index is implemented in oracle database?

680


How is clustered index different from non-clustered index?

1


When configuring sqlnet on the client what files need to be set up?

336






Were you involved in any data conversion, which one?

1


What is a schema in oracle?

626


I need to run a report at scheduled timings only. I don't want to run the report on sundays. How to do this?

1


How many types of database software are there?

344


Mention what is the difference between instance recovery and crash recovery?

1


Explain the use of inctype option in exp command.

674


What does dba stand for in technology?

328


How to retrieve the count of updated rows?

660


What is the difference between flex mode and confined mode?

598


What is key.next.item trigger?

1