Oracle General Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General Interview Questions

Questions Answers Views Company eMail

what is a view?

7 9975

what is primary key?

9 12973

what is foreign key?

5 8491

what is unique key?

Amazon, Cap Gemini, Infosys, Wipro,

14 26926

what is the difference between primary key & foreign key?

CTS, Infosys, La Multi, Sparsh, Wipro,

57 137582

Can Multiple instances be run on Single Machine???

3 6071

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

eicc,

2325

pls explain connect by prior with example and its real time use

3 14550

What is Index and different types of Indexes?

7 36242

what is the bitmap index?

3 6960

How you find out version of installed workflow?

1 4907

how many triggers we can create on a table

G2 Technology, TCS,

11 52332

normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

iFlex,

2217

can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ?

Allfon,

2 5894

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

iFlex,

1948

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to run create database statement?

1040

what is difference between sql plus and sql*plus? (not sql and sql plus).

3909

How remove data files before opening a database?

1080

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

2037

What is tns service name?

1133

What is flashback in Oracle?

1027

What is oracle rowcount?

1090

What is the exact use of Collections?

2145

Why we use bulk collect in oracle?

1054

What is oracle database 10g express edition?

1127

What is the disadvantage of User defind function?

2302

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

993

What are the uses of linked server and explain it in detail?

1063

What is a tns service name?

1015

How to convert characters to times in oracle?

1025

For More Un-Answered { Oracle General } Questions Click Here