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?

1027

How to create a table interactively?

1166

How to drop a stored function?

1182

How to export data to a csv file?

1385

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

1063

How to bring a tablespace offline?

1113

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

1113

How to retrieve data from an explicit cursor?

1107

What are the arithmetic operations?

1148

What to do if dba lost the system password?

1245

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

1113

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

1264

How to start instance with a minimal initialization parameter file?

1085

How to start your 10g xe server?

1087

How to establish administrator authentication to the server?

1095

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1954

How to specify default values in insert statement using oracle?

1152

Can select statements be used on views in oracle?

1082

How to convert times to characters in oracle?

1071

Does oracle charge for java?

1115

What is instant client oracle?

1072

How to work with data objects interactively?

1043

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2547

What is the difference between substr and instr?

1091

Explain the different normalization forms?

1157

What is an oracle data file?

1157

What are the different oracle database objects?

1149

How to use subqueries with the exists operator in oracle?

1069

How a database is related to tablespaces?

1083

What privilege is needed for a user to connect to oracle server?

1034

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