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 can you merge two tables in oracle?

1001

How to store pictures on to the database?

975

Explain temporal data types in oracle

1095

List out the difference between commit, rollback, and savepoint?

1031

Does rowid change in oracle?

1 1394

Is rowid unique in oracle?

998

Is primary key indexed by default in oracle?

987

What are triggers in oracle?

1039

What is max rowid in oracle?

1025

What is oracle rowcount?

1084

What is oracle rownum?

952

What is oracle analytical function?

1143

What is rowid and rownum in oracle?

1011

What is bulk collect in oracle?

996

What is truncate oracle?

971

Un-Answered Questions { Oracle }

What is the meaning of database backup?

626

How to convert dates to characters in oracle?

1041

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

2123

How to connect to oracle using service name instead of sid?

1025

How would you determine what sessions are connected and what resources they are waiting for?

2127

Explain alias?

1151

What is a cognitive schema?

964

What is supporting issues GL AP and AR?

2555

How do I know if oracle is installed on windows?

931

Why does Oracle not permit the use of PCTUSED with indexes?

2424

What is a oracle database?

1055

Explain cascading triggers.

1073

If you see statistics that deal with "undo" what are they really talking about?

653

How would you differentiate between cluster and grid?

What skills do you need to be a database administrator?

543

For More Un-Answered { Oracle } Questions Click Here