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?

1045

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?

1114

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?

1085

How to define an oracle sub procedure?

1145

How to define an oracle cursor variable?

1027

What is a user account in oracle?

1121

What are internal user account in oracle?

1006

Un-Answered Questions { Oracle }

Explain a private synonyms?

1037

Why are recursive relationships bad? How do you resolve them?

588

How to check the server version in oracle?

1092

What is an Integrity Constrains in Oracle?

1188

What is instant client oracle?

1021

what is profile in odi?

649

Differentiate between transaction type and transaction source? : oracle accounts receivable

1115

Explain the different types of queries created in reports?

How would you change old and new values in an insert, delete and update triggers?

1022

Explain the wait events in statspack report 'db sequential real'?

636

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1929

What is Data Dictionary Cache in Oracle?

1163

what are savepoint mode and cursor mode properties ?

Which function is used to find the largest integer less than or equal to aspecific value?

564

What is system tablespace?

1097

For More Un-Answered { Oracle } Questions Click Here