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

What are the differences between number and binary_float in oracle?

1069

How to write date and time interval literals in oracle?

990

How to drop a stored procedure in oracle?

1011

How to lock and unlock a user account in oracle?

1043

How to convert characters to numbers in oracle?

1018

What are the differences between blob and clob in oracle?

1045

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

916

How to drop an existing view in oracle?

911

What happens if you set the sga too low in oracle?

1074

How to delete multiple rows from a table in oracle?

1021

How to create a table index in oracle?

1094

What is an oracle function?

1095

How to use subqueries in the from clause in oracle?

1060

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

978

How to create a new table in oracle?

1088

Un-Answered Questions { Oracle }

nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

2159

How to create additional tablespaces for an new database?

985

How to create a new user account in oracle?

974

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1948

What are the various configuration files that are used by oracle forms?

1005

How to sort the query output in oracle?

978

What happens to indexes if you drop a table?

1122

Explain the use of analyse option in exp command.

1080

What are the original export and import utilities?

1080

What are the tools for Oracle ?

1020

Users get the following error: ora-00055 maximum number of dml locks exceeded? What is the problem and how do you fix it?

498

What do you understand by the term 'normalization'?

633

What are the different types of partitions in oracle?

926

in after report trigger if you don't write Srw.user_exit(Fnd_user exit) what it will do it will stop report execution or it will just not free the memory

2870

You see the following on a status report: redo log space requests 23 redo log space wait time 0 is this something to worry about? What if redo log space wait time is high? How can you fix this?

568

For More Un-Answered { Oracle } Questions Click Here