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?

 543

How to view the dropped tables in your recycle bin?

 1 864

How to define an anonymous procedure without variables?

 547

How many data types are supported?

 616

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

 564

How to define default values for formal parameters?

 596

What are the restrictions on external table columns?

 550

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

 560

How to loop through data rows in the implicit cursor?

 539

How to create additional tablespaces for an new database?

 570

How many categories of data types?

 572

Can you assign multiple query result rows to a variable?

 548

How to use fetch statement in a loop?

 553

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

 307

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

 281

Un-Answered Questions { Oracle }

Briefly explain what is literal? Give an example where it can be used?

542

What are data pump export and import modes?

611

What do you mean by hz_ in customer tables? : oracle accounts receivable

644

What is an Oracle Rollback Segment?

611

How to store pictures on to the database?

530




What is the sql query to find the employee who has Nth maximum salary?

4288

If you have an example table, what is the best way to get sizing data for the production table implementation?

279

how to write the sub-queries in odi?

330

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

1806

Explain oracle left join with an example?

586

What is a read only transaction in oracle?

596

What is the difference between instance recovery and crash recovery?

1

What happens if you keep split brain syndrome in rac unresolved? How it can be resolved?

1

Assuming that you are an End User How to find that in the payment Batch some of the Invoice was  Missing To pay How to find That??

1268

Can we modify approve purchase order?if yes what is navigation?

1547

For More Un-Answered { Oracle } Questions Click Here