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

Oracle General Interview Questions

Questions Answers Views Company eMail

How can we view last record added to a table?

1038

What is the maximum number of triggers that can be applied to a single table?

1024

What is the usage of merge statement?

1154

Explain the difference between a procedure and a function?

1170

What is the difference between $oracle_base and $oracle_home?

1089

State and explain the different types of data models?

944

What is key preserved table?

1021

What is a sub query and what are the different types of subqueries?

1125

What are the different pseudo commands? Explain in general?

1080

Explain the different normalization forms?

1098

State the various uses of dbcc command?

1060

What are a collation and state the different types of collation sensitivity?

1170

State the difference between a primary key and foreign key?

935

What are the different types of trigger and explain its various uses and functions?

1094

Explain about functional dependency and its relation with table design?

1010

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to use "startup" command to start default instance?

1033

What is the difference between postgresql and oracle?

1048

How can I introduce multiple conditions in like operator?

989

What operating systems are supported by oracle database 10g xe?

1034

Explain the use of full option in exp command.

1116

What is the Tune Query

2291

What is a proxy object?

1062

How to create an initialization parameter file?

1049

what is the use of system.effective.date variable in oracle?

1116

List out the components of logical database structure of oracle database.

1036

What is recovery manager in Oracle?

1056

Explain the use of log option in exp command.

1121

What are triggers in oracle?

1039

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

2031

Describe an oracle table?

1049

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