Sign Up Login


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


Oracle Interview Questions
Questions Answers Views Company eMail

What is the difference between formal parameters and actual parameters?

 753

How to view the dropped tables in your recycle bin?

 1 1164

How to define an anonymous procedure without variables?

 757

How many data types are supported?

 822

How to connect to the server with user account: sys?

 792

How to define default values for formal parameters?

 791

What are the restrictions on external table columns?

 805

What privilege is needed for a user to insert rows to tables in another schema?

 805

How to loop through data rows in the implicit cursor?

 816

How to create additional tablespaces for an new database?

 791

How many categories of data types?

 766

Can you assign multiple query result rows to a variable?

 754

How to use fetch statement in a loop?

 785

What is the use of the drop option in the alter table command?

 420

How do you use automatic pga memory management with oracle 9i and above?

 388

Un-Answered Questions { Oracle }

Can we connect to ORACLE db using Windows Authentication?

942

1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

1819

How to load data from multiple files to single target?

406

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

784

How to start an oracle instance?

785

What are the uses of a database trigger?

722

What is an oracle database?

802

Which process writes data from data files to database buffer cache?

407

What is a table index in oracle?

850

What is concurrency in oracle?

764

What are roles in oracle?

397

Can we protect our pl/sql source code?

796

Which profile required to access solution in Designer tool?

419

How to apply filtering criteria at group level in oracle?

813

Explain parameter file in oracle.

788

For More Un-Answered { Oracle } Questions Click Here