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

Oracle General Interview Questions

Questions Answers Views Company eMail

Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?

1 2755

Give the Types of modules in a form?

1 2757

What is PL/SQL ?

3 2069

What are advantages fo Stored Procedures?

1 3236

What are the uses of Database Trigger ?

1720

What is Database Trigger ?

1 3020

Can the default values be assigned to actual parameters?

1 2709

Can a primary key contain more than one columns?

2 3760

What is an UTL_FILE.What are different procedures and functions associated with it?

1 3400

Differentiate between TRUNCATE and DELETE?

2 3049

What is difference between a formal and an actual parameter?

1 2680

What should be the return type for a cursor variable.Can we use a scalar data type as return type?

1 2664

What are different Oracle database objects?

1 2674

What is difference between SUBSTR and INSTR?

1 3037

Display the number value in Words?

1 3093

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What exactly do quotation marks around the table name do?

963

Query to retrieve record for a many to many relationship ?

2520

Explain the use of parfile option in exp command.

1069

Is a rollback possible to any savepoint?

1096

Explain what are the different type of segments?

965

Explain the use of tables option in exp command.

1117

can anyody please send me the dump for Oracle 10g certifications for DBA path?

2122

What is oracle and what are its different editions?

1066

What is difference between sid and service name in oracle?

956

What is the database name in oracle?

1021

What is an oracle?

1018

how to handle exceptions in post production

1426

What are named parameters?

1093

What is the difference between sharding and replication?

1048

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

1116

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