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 table index?

1018

How a database is related to tablespaces?

989

How to define a specific record type?

1038

How to estimate disk space needed for an export job?

995

How to use "if" statements on multiple conditions?

1113

What is the data pump import utility?

972

How to update a table row with a record?

963

What is an index associated with a constraint?

976

What are the numeric comparison operations?

1061

How to delete a column in an existing table?

1020

How to use an explicit cursor without open statements?

1015

Can multiple cursors being opened at the same time?

1018

How to invoke the data pump import utility?

1082

How to pass a cursor variable to a procedure?

1042

How to view the data files in the current database?

1045

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How do I manually uninstall oracle client?

1025

When system tablespace is created?

973

What is background process in Oracle?

1052

What is the data pump import utility?

972

What is meant by joins?

1017

Hi Can any one tell me what are the API's used in requisition import.

1885

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

2153

What is the difference between a primary key & a unique key?

1043

what are archived logs?

2146

How to create a table index in oracle?

1086

How to lock and unlock a user account in oracle?

1030

Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??

1670

How to convert characters to numbers in oracle?

1001

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

2263

What privilege is needed for a user to delete rows from tables in another schema?

1020

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