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 stored procedure in oracle?

1150

How to return top 5 rows in oracle?

1112

How to select some columns from a table in oracle?

1170

How to concatenate two text values in oracle?

1156

What is a data lock in oracle?

1180

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

1033

What is an oracle user role?

1038

How to download oracle database 10g xe?

1065

How to join two tables in a single query using oracle?

1052

How to check your oracle database 10g xe installation?

1041

How to set a transaction to be read only in oracle?

1137

How to sort output in descending order in oracle?

1101

What are ddl statements in oracle?

1127

How to use attributes of the implicit cursor in oracle?

1061

How to name query output columns in oracle?

1240

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2311

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

1262

How to rename an index?

1122

How many types of tables are there in oracle?

1111

How to do a full database export?

1152

What is Trigger in Oracle?

1240

What are the various types of snapshots ?

1082

Write a trigger example in oracle?

1113

What is difference between cartesian join and cross join?

1155

Explain oracle 12c new features for developers?

1125

What are the database administrators utilities available?

1094

types of indexes and the rationale behind choosing a particular index for a situation.

2559

How to view the tablespaces in the current database?

1024

Explain the different normalization forms?

1156

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

1091

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