1. Categories >> Software >> Databases >> Oracle
  2. Suggest New Category


Oracle Interview Questions
Questions Answers Views Company eMail

How can you Enforce Referential Integrity in snapshots ?

 1 2075

What is a SNAPSHOT ?

 1 2065

What is a shared pool?

 1 1841

Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?

 1 2024

Give the Types of modules in a form?

 1 1920

What is PL/SQL ?

 1115

What are advantages fo Stored Procedures?

 1 2504

What are the uses of Database Trigger ?

 1101

What is Database Trigger ?

 1 2221

Can the default values be assigned to actual parameters?

 1 2043

Can a primary key contain more than one columns?

 2 2773

What is an UTL_FILE.What are different procedures and functions associated with it?

 1 2655

Differentiate between TRUNCATE and DELETE?

 2 2111

What is difference between a formal and an actual parameter?

 1 1964

What should be the return type for a cursor variable.Can we use a scalar data type as return type?

 1 2066

Un-Answered Questions { Oracle }

What is StandAlone Agent and default port number?

358

How can we delete duplicate rows in a table?

566

Please explain joins in oracle?

547

How to use "out" parameter properly?

628

material view and view disadvantages?

635




What is oracle used for?

534

How do you generate file output from sql?

263

what happened to the global index when I truncate the data in one of the partition?

1518

How to sort the query output in oracle?

610

What is a trigger and what are its types in oracle?

534

what is tripstop report?

1354

Explain coalesce function?

624

How to bring a tablespace offline?

543

Is rowid unique in oracle?

528

What are nested tables?

673

For More Un-Answered { Oracle } Questions Click Here