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?

1070

What is the implicit cursor in oracle?

1169

How to use like conditions in oracle?

1114

How to define an explicit cursor in oracle?

1099

What is a recycle bin in oracle?

1 1656

How to select an oracle system id (sid)?

1120

What is a user role in oracle?

1183

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

1099

How to open and close an explicit cursor in oracle?

1095

What are the differences between number and binary_float in oracle?

1148

How to write date and time interval literals in oracle?

1079

How to drop a stored procedure in oracle?

1104

How to lock and unlock a user account in oracle?

1160

How to convert characters to numbers in oracle?

1112

What are the differences between blob and clob in oracle?

1135

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is an oracle user role?

1038

What is columnar storage what is the advantage?

1120

Describe varray?

1116

Difference between hot backup vs. Cold backup?

1037

What is a trigger and what are its types?

1324

6. Display the client name and order date for all orders using the traditional method.

2355

Why is oracle database so popular?

1069

Can we store pictures in the database and if so, how it can be done?

1089

How many types of cluster table in Oracle?

1080

What are the different pseudo commands? Explain in general?

1123

When system tablespace is created?

1090

How to rename a column in an existing table?

1082

How to store only time; not date and time?

1067

What are the different types of partitions in oracle?

1031

What is the use of aggregate functions in oracle?

1071

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