Oracle General Interview Questions
Questions Answers Views Company eMail

How to run create database statement again?

618

How to run queries on external tables?

564

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

562

How to rename a column in an existing table?

615

How to view existing locks on the database?

543

How much memory your 10g xe server is using?

578

How to recover a dropped index?

1 910

How to assign values to data fields in record variables?

580

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

547

How to create tables for odbc connection testing?

485

What is a named program unit?

578

How to open a cursor variable?

602

What happens to indexes if you drop a table?

693

How to test null values?

670

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

525


Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is an index associated with a constraint?

550


What is the difference between I and G in Oracle?

599


What is oracle database 10g express edition?

593


How to create a temporary table in oracle?

687


How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

1827






What is the difference between alert log file and tarce file ?

1628


Explain oracle’s server parameter file.

564


How a database is related to tablespaces?

576


How to define an external table with a text file?

577


Whether any commands are used for months calculation? If so, what are they?

592


How do you find out from the RMAN catalog if a particular archive log has been backed-up?

1656


I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

1854


Differentiate between translate and replace?

625


How to define an anonymous procedure with variables?

543


I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

1844