Oracle Interview Questions
Questions Answers Views Company eMail

What is the difference between formal parameters and actual parameters?

536

How to view the dropped tables in your recycle bin?

1 844

How to define an anonymous procedure without variables?

543

How many data types are supported?

610

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

556

How to define default values for formal parameters?

584

What are the restrictions on external table columns?

543

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

550

How to loop through data rows in the implicit cursor?

537

How to create additional tablespaces for an new database?

561

How many categories of data types?

570

Can you assign multiple query result rows to a variable?

543

How to use fetch statement in a loop?

547

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

301

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

279


Un-Answered Questions { Oracle }

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

556


What is a view and how is it different from a table?

566


what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?

1800


How can I see all tables in oracle?

535


What is raw datatype in oracle?

573






What is dba training?

273


How do we represent comments in oracle?

621


What are the different optimizers that are used to optimize database?

1


what is oracle data integrator (odi)?

301


What is memory advisor in Oracle?

624


Differentiate between pre-select and pre-query?

609


What are the types of locks in database?

295


How to omit columns with default values in insert statement in oracle?

571


What is the normalization?

286


i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

1465