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?

946

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

1054

How to sort output in descending order in oracle?

999

What are ddl statements in oracle?

1031

How to use attributes of the implicit cursor in oracle?

965

How to name query output columns in oracle?

1147

What is oracle server autotrace in oracle?

1113

How to rename an index in oracle?

1080

How to update values in a table in oracle?

975

How to call a stored function in oracle?

971

How to increment dates by 1 in oracle?

1017

How to define an oracle sub procedure?

1077

How to define an oracle cursor variable?

988

What is a user account in oracle?

1077

What are internal user account in oracle?

960

Un-Answered Questions { Oracle }

What is the full form of dba?

560

I need to run a report at scheduled timings only. I don't want to run the report on sundays. How to do this?

How to calculate the approximate size of the SGA based on the size of the block,shared_pool,redo_buffer_cache and db_buffer_cache?

2659

How to rename an index?

1018

Explain oracle 12c new features for developers?

1007

How to write a query with a right outer join in oracle?

1130

how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2523

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

982

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?

2220

How to upsert (update or insert into a table)?

970

What are the LKM types?

561

How you find which the latest record in SCD type2 transformation is?

548

What is execute immediate in oracle?

968

What is clustered table in Oracle?

1132

What is save point in oracle database?

1259

For More Un-Answered { Oracle } Questions Click Here