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 end the current transaction in oracle?

1076

What is the implicit cursor in oracle?

1173

How to use like conditions in oracle?

1115

How to define an explicit cursor in oracle?

1102

What is a recycle bin in oracle?

1 1663

How to select an oracle system id (sid)?

1124

What is a user role in oracle?

1187

How to omit columns with default values in insert statement in oracle?

1099

How to open and close an explicit cursor in oracle?

1101

What are the differences between number and binary_float in oracle?

1152

How to write date and time interval literals in oracle?

1087

How to drop a stored procedure in oracle?

1110

How to lock and unlock a user account in oracle?

1164

How to convert characters to numbers in oracle?

1115

What are the differences between blob and clob in oracle?

1139

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to create a new table in your schema?

1132

How to create a testing table in oracle?

1038

How to use "while" statements in oracle?

1381

Explain the use of indexes option in imp command.

1265

What are nested tables?

1227

What are the different types of failures that occur in Oracle database?

1124

What is the difference between primary key and unique key and foreign key in oracle?

1037

What are the limitations of check constraint?

1078

What are the four Oracle system processes that must always be up and running for the database to be useable?

1056

What is columnar storage what is the advantage?

1125

Explain the use of tables option in exp command.

1172

What types of joins are used in writing subqueries?

1035

How to convert raw data type into text in oracle? Explain

1052

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2423

What is a relational database management system?

1175

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