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 check your oracle database 10g xe installation?

986

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

1093

How to sort output in descending order in oracle?

1044

What are ddl statements in oracle?

1075

How to use attributes of the implicit cursor in oracle?

1008

How to name query output columns in oracle?

1187

What is oracle server autotrace in oracle?

1166

How to rename an index in oracle?

1113

How to update values in a table in oracle?

1026

How to call a stored function in oracle?

1018

How to increment dates by 1 in oracle?

1083

How to define an oracle sub procedure?

1144

How to define an oracle cursor variable?

1027

What is a user account in oracle?

1120

What are internal user account in oracle?

1005

Un-Answered Questions { Oracle }

What is the most important action a dba must perform after changing the database from noarchivelog to archivelog?

668

How to pass a cursor variable to a procedure?

1109

What is an oracle recycle bin?

1009

How to loop through data rows in the implicit cursor?

1073

11. Display the client number and name and the client number and name of the person who referred that client.

2339

What is SQL Tuning Advisor in Oracle?

1178

difference between global n context sensitive segments?

2670

How to name query output columns in oracle?

1187

Explain the difference between a procedure and a function? What do you understand by those terms?

1081

How are extents allocated to a segment?

1125

What to do if dba lost the system password?

1172

Explain for repository?

584

How many types of tables are there in oracle?

1061

How to delete multiple rows from a table in oracle?

1060

What are the common oracle dba tasks?

1145

For More Un-Answered { Oracle } Questions Click Here