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?

 547

How to view the dropped tables in your recycle bin?

 1 869

How to define an anonymous procedure without variables?

 553

How many data types are supported?

 622

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

 567

How to define default values for formal parameters?

 598

What are the restrictions on external table columns?

 552

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

 562

How to loop through data rows in the implicit cursor?

 543

How to create additional tablespaces for an new database?

 572

How many categories of data types?

 576

Can you assign multiple query result rows to a variable?

 551

How to use fetch statement in a loop?

 555

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

 311

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

 286

Un-Answered Questions { Oracle }

When do you get a .pll extension in oracle? Explain its importance

575

How can I combine multiple rows into a comma-delimited list in oracle?

583

What are types of data model?

291

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

1525

What do you understand by row chaining?

1




What is J2EE Agent and port number?

297

How would you determine who has added a row to a table?

1798

What are triggers in oracle?

562

What is a nested table?

631

Where in the Oracle directory tree structure are audit traces placed?

2129

What is oracle partial backup?

310

How can you determine the number of sqlnet users logged in to the unix system?

285

Describe an oracle table?

576

Why are recursive relationships bad? How do you resolve them?

289

How to add another datafile to a tablespace?

578

For More Un-Answered { Oracle } Questions Click Here