Oracle General Interview Questions
Questions Answers Views Company eMail

How to run create database statement again?

726

How to run queries on external tables?

669

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

673

How to rename a column in an existing table?

713

How to view existing locks on the database?

677

How much memory your 10g xe server is using?

719

How to recover a dropped index?

1 1086

How to assign values to data fields in record variables?

690

How to create a new table by selecting rows from another table?

686

How to create tables for odbc connection testing?

611

What is a named program unit?

709

How to open a cursor variable?

703

What happens to indexes if you drop a table?

834

How to test null values?

780

How to define a data source name (dsn) in odbc manager?

641


Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is oracle server autotrace in oracle?

740


How to execute a stored procedure in oracle?

733


How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2513


What is the difference between sharding and partitioning?

611


What is proxy method?

652






What is the difference between count (*), count (expression), count (distinct expression)?

664


Difference between open_form and call_form in oracle.

806


What is a cursor and what are the steps need to be taken?

702


How to start a new transaction in oracle?

707


What is open database communication (odbc) in oracle?

651


Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

1985


6. Display the client name and order date for all orders using the traditional method.

1907


What is merge statement used for?

679


What happens to the current transaction if the session is ended?

659


Is the After report trigger fired if the report execution fails ?

2547