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?

971

What are named parameters?

1048

How to connect to a remote server?

1071

What are the predefined tablespaces in a database?

1024

What happens if you use a wrong connect identifier?

1001

How to login to the server without an instance?

1125

How to manage transaction isolation level?

961

How to export several tables together?

1004

How to import one table back from a dump file?

985

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

1019

How to invoke the data pump export utility?

1134

How to define an anonymous block?

1093

How to list all tables in your schema?

1005

How to use "in out" parameter properly?

1010

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is a read only transaction in oracle?

984

Explain oracle instance.

1121

How to pass parameters to procedures?

987

What is merge in oracle?

1004

Calculate difference between 2 date / times in oracle sql?

1003

How to bring a tablespace online?

1017

what are the default admin accounts in Oracle 10g ?

929

How would you change old and new values in an insert, delete and update triggers?

967

How to manage transaction isolation level?

961

What is a subquery in oracle?

1063

nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

2160

How to create tables for odbc connection testing?

1035

How to use attributes of the implicit cursor in oracle?

965

What is a static data dictionary in oracle?

1047

What is the disadvantage of User defind function?

2259

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