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

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

Oracle Interview Questions

Questions Answers Views Company eMail

How to resolve name conflicts between variables and columns?

1082

What happens to the current transaction if the session is ended?

1140

How to rename an index?

1127

What is the scope of a local variable?

1124

What privilege is needed for a user to query tables in another schema?

1038

How to initialize variables with default values?

1310

How to define a variable of a specific record type?

1120

What is an external table?

1086

What are named parameters?

1148

How to connect to a remote server?

1195

What are the predefined tablespaces in a database?

1150

What happens if you use a wrong connect identifier?

1143

How to login to the server without an instance?

1218

How to manage transaction isolation level?

1059

How to export several tables together?

1110

Un-Answered Questions { Oracle }

Explain a private synonyms?

1100

What is call form stack?

State all possible different index configurations a table can possibly have?

1105

What is oracle and what are its different editions?

1122

How to sort output in descending order in oracle?

1107

Explain how to convert a report into excel sheet.

How do we display rows from the table without duplicates?

1019

What is the use solutions?

647

I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.

3387

if u want to delete all these detail block etc what will happen in form

2056

Explain the use of control file?

1180

What is primefaces used for?

1102

I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users

1261

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

2289

What are ddl statements in oracle?

1133

For More Un-Answered { Oracle } Questions Click Here