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 do you mean by merge in oracle and how can we merge two tables?

1003

What is a trigger and what are its types?

1115

List out the types of joins.

1083

What are the parameters that we can pass through a stored procedure?

1000

What is a nested table?

1007

How view is different from a table?

969

What do you understand by a database object?

990

What is meant by raw datatype?

1005

When do we use group by clause in a sql query?

995

Where do we use decode and case statements?

945

How can we find out the duplicate values in an oracle table?

996

What is the difference between truncate & delete command?

1125

How will you identify oracle database software release?

944

What are the attributes that are found in a cursor?

1013

What do you understand by a database object? Can you list a few of them?

971

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to call a stored function in oracle?

953

what are actual and formal parameters?

1051

Explain about achiever in sql?

981

How to export data with a field delimiter?

971

What is a package in oracle?

1028

How to compare dates in oracle sql?

1043

How to define a record variable to store a table row?

1005

What are the roles of dba?

1021

What is columnar storage what is the advantage?

986

Can we create database in oracle using command line ?

1031

What is transaction control statement and how many types of transaction control statement in Oracle?

1080

How to sort output in descending order in oracle?

989

How do I use os authentication with weblogic jdriver for oracle and connection pools?

999

What are the ways tablespaces can be managed and how do they differ?

2274

Explain constraining triggers.

1045

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