Oracle General Interview Questions
Questions Answers Views Company eMail

How to shutdown your 10g xe server from command line?

807

How to export your connection information to a file?

885

How to shutdown your 10g xe server?

872

How a tablespace is related to data files?

854

Where is the export dump file located?

849

What are the original export and import utilities?

803

What is a connect identifier?

814

How to view all columns in an existing table?

747

What is an anonymous block?

941

How many anonymous blocks can be defined?

854

How to load data through external tables?

902

How to create a table index?

838

How to assign data of the deleted row to variables?

852

How to work with data objects interactively?

770

How to add a new column to an existing table with a default value?

822


Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Explain an extent?

902


How to loop through data rows in the implicit cursor?

858


What are the roles of dba?

849


Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

1906


candidate key is subset of super key but not vice-verse explain

1827


How do I use os authentication with weblogic jdriver for oracle and connection pools?

831


Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

1942


How would you go about verifying the network name that the local_listener is currently using?

1850


How many categories of data types in oracle?

815


What is clustered table in Oracle?

893


What is a synonym? What are its various types?

908


Explain how you would restore a database using RMAN to Point in Time?

1945


Does oracle partitioning improve performance?

780


How to create a testing table in oracle?

789


when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

1745