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

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

How to create a new view in oracle?

1078

How to insert a new row into a table in oracle?

1162

What is a database schema in oracle?

1110

What is open database communication (odbc) in oracle?

1003

How to drop an index in oracle?

1074

What is a read only transaction in oracle?

1028

How to insert multiple rows with one insert statement in oracle?

1085

How to connect ms access to oracle servers?

1005

How to delete all rows a table in oracle?

1068

What is a parameter file in oracle?

1134

Can the query output be sorted by multiple columns in oracle?

992

Can group functions be used in the order by clause in oracle?

997

What is a static data dictionary in oracle?

1112

How to assign a tablespace to a users in oracle?

1048

How to drop an existing table in oracle?

1058

Un-Answered Questions { Oracle }

System tablespace cant be exported from one database and imported into another why?

555

Is there any link between pr form(purchse requisition)and po form(purchase order)

2722

If you are not sure what command does a particular unix function what is the best way to determine the command?

565

How to make the project as .exe file in oracle forms & reports(d2k)?

How to sort the query output in oracle?

1028

How to execute a stored procedure in oracle?

1091

Can we commit inside a function in oracle?

963

How to create a new user account in oracle?

1020

what is tripstop report?

1834

What is the difference between a user and a schema in oracle?

1034

What is key preserved table?

1021

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

1058

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

1020

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

1030

What is oracle d2k?

For More Un-Answered { Oracle } Questions Click Here