Oracle General Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General Interview Questions

Questions Answers Views Company eMail

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

1084

How to export your connection information to a file?

1125

How to shutdown your 10g xe server?

1147

How a tablespace is related to data files?

1107

Where is the export dump file located?

1141

What are the original export and import utilities?

1164

What is a connect identifier?

1037

How to view all columns in an existing table?

932

What is an anonymous block?

1236

How many anonymous blocks can be defined?

1182

How to load data through external tables?

1135

How to create a table index?

1143

How to assign data of the deleted row to variables?

1071

How to work with data objects interactively?

976

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

1016

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is an oracle database?

1033

What is the order of defining local variables and sub procedures/functions?

1058

How to rename an index?

1069

How to write a query with a left outer join in oracle?

1061

how may join possible between (requisition with purchase order)

2241

How to create a table in a specific tablespace?

972

Why does oracle 9i treat an empty string as null?

1052

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

2003

Explain the use of show option in imp command.

1096

What is difference between sid and service name in oracle?

954

Why do we use bulk collect in oracle?

1058

What is the Tune Query

2291

How to shutdown your 10g xe server?

1147

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

1009

What is an oracle user account?

986

For More Un-Answered { Oracle General } Questions Click Here