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

958

Why do we use coalesce function in oracle?

1054

What is the quickest way to fetch the data from a table?

1003

How translate command is different from replace?

1009

How will you differentiate between varchar & varchar2?

994

What are the set operators union, union all, minus & intersect meant to do?

941

What is a nvl function? How can it be used?

961

What is the use of aggregate functions in oracle?

981

What do you mean by a database transaction & what all tcl statements are available in oracle?

934

What is a data dictionary and how can it be created?

1059

Why do we need integrity constraints in a database?

975

Write a trigger example in oracle?

983

Explain the difference between sql and oracle?

1026

Please explain oracle left join with an example?

960

Explain the truncate in oracle?

915

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How would you best determine why your MVIEW couldnt FAST REFRESH?

1839

How would you go about verifying the network name that the local_listener is currently using?

1996

Does facebook use oracle?

983

What is recovery manager(rman) backup in Oracle?

1127

What is oracle database 10g express edition?

1075

How to install oracle odbc drivers?

1044

Is oracle a relational database?

873

How to connect to a local oracle 10g xe server?

941

How to check database size in Oracle?

1122

What is a read only transaction in oracle?

975

How to connect to the server with user account: sys?

973

What do you mean by cdb and pdb in oracle 12c?

1008

How to drop a stored procedure in oracle?

1001

Can we write dml statement in function in oracle?

1026

List the various oracle database objects?

996

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