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?

1114

What is an external table?

1080

What are named parameters?

1143

How to connect to a remote server?

1187

What are the predefined tablespaces in a database?

1140

What happens if you use a wrong connect identifier?

1138

How to login to the server without an instance?

1213

How to manage transaction isolation level?

1054

How to export several tables together?

1105

How to import one table back from a dump file?

1082

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

1125

How to invoke the data pump export utility?

1251

How to define an anonymous block?

1245

How to list all tables in your schema?

1115

How to use "in out" parameter properly?

1102

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

what are the advantages of running a database in archive log mode?

2253

What are the ways tablespaces can be managed and how do they differ?

2444

what is difference between sql plus and sql*plus? (not sql and sql plus).

3941

what is Single Byte Overhead...?

2612

How to create an oracle database manually?

1129

What are the execution control statements in oracle?

1129

How to delete all rows a table in oracle?

1119

Explain about integrity constraint?

1176

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2306

What privilege is needed for a user to create views in oracle?

1091

What are advantages of dateset in datastage?

2308

How to create a table in a specific tablespace?

1022

Is postgres faster than oracle?

1083

When system tablespace is created?

1090

What is the difference between I and G in Oracle?

1148

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