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 are actual and formal parameters?

1104

Differentiate between translate and replace?

1116

Explain the use of rows option in imp command.

1085

Explain the use of rows option in exp command.

1090

Explain the use of tables option in exp command.

1115

Differentiate between post-database commit and post-form commit?

1037

Explain the use of full option in exp command.

1116

Difference between pre-select and pre-query

1106

Explain an exception?

993

What are the varoius components of physical database structure of oracle database?

1006

Explain the use of online redo log files in oracle.

1036

Explain the use of grant option in exp command.

1063

What is a sub query? What are its various types?

1177

Explain enable novalidate constraint.

1080

What is a synonym? What are its various types?

1110

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What are the various types of snapshots ?

1027

How can you merge two tables in oracle?

1001

What privilege is needed for a user to connect to oracle server?

994

what is normalisation?what are its uses?

2273

Explain how you would restore a database using RMAN to Point in Time?

2144

What is a snapshot log?

1003

How to update values in a table in oracle?

1026

What is using clause and give example?

1038

When do I need to use a semicolon vs a slash in oracle sql?

1090

What are the data types in oracle?

1039

How to do a full database export?

1107

How do I manually uninstall oracle client?

1084

Explain the use of analyse option in exp command.

1126

How to create a stored procedure in oracle?

1102

What is a trigger and what are its types?

1227

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