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?

 679

How to view the dropped tables in your recycle bin?

 1 1063

How to define an anonymous procedure without variables?

 686

How many data types are supported?

 760

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

 711

How to define default values for formal parameters?

 720

What are the restrictions on external table columns?

 685

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

 726

How to loop through data rows in the implicit cursor?

 719

How to create additional tablespaces for an new database?

 722

How many categories of data types?

 708

Can you assign multiple query result rows to a variable?

 706

How to use fetch statement in a loop?

 710

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

 384

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

 355

Un-Answered Questions { Oracle }

How do you bind variables in oracle?

692

How to load excel data sheet to oracle database

710

How to create a new view in oracle?

777

Give the various exception types.

683

What are the five main functions of a database administrator?

376




What is dual table oracle?

651

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

384

What are the general rules on data consistency?

703

What is an SQL FORMS ?

2455

What is the quickest way to fetch the data from a table?

744

Explain the use of online redo log files in oracle.

727

What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?

422

master table and child table performances and comparisons in Oracle ?

1832

Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?

1703

What is a user function?

417

For More Un-Answered { Oracle } Questions Click Here