Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1803)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

How to change user password in oracle?

1101

How to create a new user account in oracle?

1069

How to start a specific oracle instance?

1083

What is a dead lock in oracle?

1182

What are the differences between char and varchar2 in oracle?

1252

How to pass a parameter to a cursor in oracle?

1236

How to create a stored procedure in oracle?

1157

How to return top 5 rows in oracle?

1115

How to select some columns from a table in oracle?

1181

How to concatenate two text values in oracle?

1159

What is a data lock in oracle?

1182

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

1040

What is an oracle user role?

1042

How to download oracle database 10g xe?

1074

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

1054

Un-Answered Questions { Oracle }

How to create a new tablespace in oracle?

1041

What is a system tablespace and why do we need it?

What is oracle thin client?

1081

What is pragma autonomous transaction in oracle?

1128

Point the difference between translate and replace?

1152

How to define an explicit cursor in oracle?

1103

Guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?

663

What is a private synonym?

1647

How to convert times to characters in oracle?

1079

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1996

What are the different types of modules in oracle forms?

1055

How to create an oracle database?

1107

What is query image?

1023

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

1271

How to run queries on external tables?

1092

For More Un-Answered { Oracle } Questions Click Here