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?

 769

How to view the dropped tables in your recycle bin?

 1 1185

How to define an anonymous procedure without variables?

 784

How many data types are supported?

 841

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

 815

How to define default values for formal parameters?

 812

What are the restrictions on external table columns?

 830

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

 817

How to loop through data rows in the implicit cursor?

 842

How to create additional tablespaces for an new database?

 812

How many categories of data types?

 778

Can you assign multiple query result rows to a variable?

 783

How to use fetch statement in a loop?

 803

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

 436

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

 397

Un-Answered Questions { Oracle }

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

2025

Explain a segment?

841

What is the difference between raid 5 and raid 10? Which is better for oracle?

440

how to do daily transactions with out sql* loader control file regesterd in apps?

1458

What is index-organized table in Oracle?

805

Explain cascading triggers.

832

What is the difference between translate and replace in oracle?

935

What is translate in oracle?

866

How do I recompile a procedure in oracle?

749

How many types of dba are there?

400

What are four common errors found in an alert .log?

395

What is a cursor in oracle?

864

What are the different types of backups that are available in oracle?

1

Can we write dml statement in function in oracle?

854

Which profile required to access solution in Designer tool?

435

For More Un-Answered { Oracle } Questions Click Here