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 resolve name conflicts between variables and columns?

1031

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

1098

How to rename an index?

1071

What is the scope of a local variable?

1067

What privilege is needed for a user to query tables in another schema?

973

How to initialize variables with default values?

1240

How to define a variable of a specific record type?

1077

What is an external table?

1020

What are named parameters?

1089

How to connect to a remote server?

1124

What are the predefined tablespaces in a database?

1081

What happens if you use a wrong connect identifier?

1063

How to login to the server without an instance?

1162

How to manage transaction isolation level?

1005

How to export several tables together?

1049

Un-Answered Questions { Oracle }

How to change user password in oracle?

1029

i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks

2279

How many anonymous blocks can be defined?

1184

How do I uninstall oracle client from windows?

1010

How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

3198

How to define default values for formal parameters?

1044

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

700

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2272

What is end user in database?

597

What is an Oracle Data Dictionary?

1109

Which dba certification is best?

570

> 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?

2030

Explain what are the characteristics of data files?

1084

What is the disadvantage of User defind function?

2290

What does a dba stand for?

577

For More Un-Answered { Oracle } Questions Click Here