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

What is package and main advantages?

Accenture,

559

What is the use solutions?

Accenture,

559

What is the use of Markers?

Accenture,

543

Which profile required to access ODI Console?

Accenture,

557

What are the LKM types?

Virtuas,

555

What are the constraints in odi?

TCS,

575

In topology manager where the data are stored?

Tech Mahindra,

642

What is odi studio?

TCS,

547

What is CDC and explain complete CDC process flow?

Accenture,

540

Which profile required to access solution in Designer tool?

Accenture,

551

What are the Types of repositories in ODI?

Accenture,

548

What is the data quality in odi?

TCS,

607

Have you created fact table and dimension tables?

Virtuas,

601

What is Session Tasks?

Seventhsense Technologies,

560

What is the variable?

Infosys,

582

Un-Answered Questions { Oracle }

Give the various rollback segment states.

1006

How to load excel data sheet to oracle database

977

master table and child table performances and comparisons in Oracle ?

2082

How to use an explicit cursor without open statements?

1018

How to list all indexes in your schema?

1044

What is the difference between a hot backup and a cold backup in oracle?

968

1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?

2132

How can you find out how many users are currently logged into the database?

560

Mention how oracle flex asm works?

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

1048

Give one method for transferring a table from one schema to another?

548

Explain the use of parfile option in exp command.

1004

List the various oracle database objects?

1001

How to use like conditions in oracle?

1003

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

2277

For More Un-Answered { Oracle } Questions Click Here