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 is db_recovery_file_dest in oracle? When do you need to set this value?

1125

What do you mean by Oracle MEDIA RECOVERY?

1226

What is the disk migration? what is the steps involved in oracle disk migration?

1222

Can a Tablespace hold objects from different Schemes in Oracle?

1044

What is an Oracle Rollback Segment?

1119

What is an Oracle Data Dictionary?

1111

What is an Oracle Data Segment?

1043

Can a View based on another View in Oracle?

1028

What is the function of Redo Log in Oracle?

1219

How to define Data Block size in Oracle?

1110

What is an Integrity Constrains in Oracle?

1188

What are Oracle Schema Objects?

1113

What is an oracle database schema?

1124

What are the uses of Oracle Rollback Segment?

1126

What is an Oracle Data Block?

1062

Un-Answered Questions { Oracle }

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

1987

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?

617

Which database is best to learn?

567

System tablespace cant be exported from one database and imported into another why?

555

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1690

How to delete a column in an existing table in oracle?

1071

How to create an oracle database manually?

1085

if some data is not transfered where it will get stored

1942

What are the main functions of dba?

580

HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

2061

What is the Tune Query

2291

Does a dba have to file taxes?

582

How to view existing locks on the database?

1053

What is recovery manager in Oracle?

1056

HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??

1450

For More Un-Answered { Oracle } Questions Click Here