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 create a table in a specific tablespace?

976

How to create a table interactively?

1090

How to drop a stored function?

1137

How to export data to a csv file?

1305

What are the differences between interval year to month and interval day to second?

1026

How to bring a tablespace offline?

1064

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

1061

How to retrieve data from an explicit cursor?

1059

What are the arithmetic operations?

1084

What to do if dba lost the system password?

1172

How to define a record variable to store a table row?

1058

What happens if variable names collide with table/column names?

1191

How to start instance with a minimal initialization parameter file?

1040

How to start your 10g xe server?

1041

How to establish administrator authentication to the server?

1041

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Explain do view contain data?

1011

Is there a combination of "like" and "in" in sql?

1065

What is oracle in java?

969

What is the relation of a user account and a schema?

1134

What is an oracle cursor variable?

1075

How to filter out duplications in the returning rows using oracle?

1018

Can you have more than one content canvas view attached with a window ?

2333

How do I connect to oracle?

1029

What to do if dba lost the system password?

1172

What is a select query statement in oracle?

968

Explain the use of consistent option in exp command.

1066

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1899

Can we write insert statement in function in oracle?

1089

How to load excel data sheet to oracle database

1024

How to get last row id?

992

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