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

Oracle General (1809)
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?

1029

How to create a new user account in oracle?

1020

How to start a specific oracle instance?

1037

What is a dead lock in oracle?

1120

What are the differences between char and varchar2 in oracle?

1170

How to pass a parameter to a cursor in oracle?

1178

How to create a stored procedure in oracle?

1102

How to return top 5 rows in oracle?

1062

How to select some columns from a table in oracle?

1091

How to concatenate two text values in oracle?

1112

What is a data lock in oracle?

1118

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

994

What is an oracle user role?

984

How to download oracle database 10g xe?

1018

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

996

Un-Answered Questions { Oracle }

How to define a data source name (dsn) in odbc manager?

1029

Explain an index segment?

1118

Explain the wait events in statspack report 'db scattered read', 'db sequential real', 'enqueue'?

659

What is the data type of dual table?

993

Explain joins in oracle?

1035

In what script is snap$ created? In what script is the scott/tiger schema created?

2708

What are the different responsibilities of a dba?

722

1. What is PO rate variance gain and loss?

2919

What is the use of Oracle Control File?

1073

What is new feature in oracle asm 12c?

How to load a large xml file?

1055

How can you determine if the sqlnet process is running for sqlnet v1? How about v2?

570

Mention what are the key characteristics of rac or why to use rac?

How to bring a tablespace online?

1079

What is the use of lockboxes? : oracle accounts receivable

1208

For More Un-Answered { Oracle } Questions Click Here