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 many anonymous blocks can be defined?

1178

How to load data through external tables?

1133

How to create a table index?

1139

How to assign data of the deleted row to variables?

1070

How to work with data objects interactively?

974

How to add a new column to an existing table with a default value?

1014

How to get a list of all tables in the database?

1 4274

How to set up autotrace for a user account?

1053

How to run the anonymous block again?

1124

How to see the table columns used in an index?

1017

How to drop an index?

952

What happens to the current transaction if the session is killed?

984

How to define an external table with a text file?

1059

How to get a list of all user accounts in the database?

1085

How to define a sub function?

1125

Un-Answered Questions { Oracle }

Explain the difference between repeating frame and frame.

What is the easiest method to create a file on unix?

568

What is catalog in Oracle?

1354

What are the types of locks in database?

613

What happens if you keep split brain syndrome in rac unresolved? How it can be resolved?

> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?

2026

did u received a single file or multiple files

2013

Is oracle a language?

935

Difference between cartesian join and cross join?

1031

Explain index?

1252

Explain an index segment?

1109

What to do if the startbd.bat failed to start the xe instance?

1078

Is oracle a programming language?

983

What privilege is needed for a user to connect to oracle server?

987

what we specify the in XML data server and parameters for to connect to xml file?

696

For More Un-Answered { Oracle } Questions Click Here