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 define a variable of a specific record type?

1028

What is an external table?

968

What are named parameters?

1045

How to connect to a remote server?

1069

What are the predefined tablespaces in a database?

1020

What happens if you use a wrong connect identifier?

995

How to login to the server without an instance?

1120

How to manage transaction isolation level?

958

How to export several tables together?

1000

How to import one table back from a dump file?

981

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

1017

How to invoke the data pump export utility?

1130

How to define an anonymous block?

1091

How to list all tables in your schema?

999

How to use "in out" parameter properly?

1007

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Why should I use oracle database?

959

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1911

How to execute the package in oracle?

1050

What are the differences between blob and clob in oracle?

1044

How to use an explicit cursor without open statements?

1020

What is oracle rowcount?

1043

What is the difference between translate and replace in oracle?

1127

How to assign a table row to a record variable?

978

What the is the diff between local index and global index. give some example.

1595

How to use subqueries with the exists operator in oracle?

981

What is the difference between substr & instr functions?

1139

Describe an oracle table?

1003

What are the attributes of cursor?

1000

How to convert character types to numeric types?

1065

What is a nvl function? How can it be used?

970

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