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

WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

2164

HOW TO SPOT AHIERARCHY?

2349

TILL WHAT LEVEL OF SECURITY BO SUPPORTS?

1 3657

IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?

2316

CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

2130

WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

3023

HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

2114

What is cardinality?

4 7639

WHAT IS CARTESIAN PRODUCT?

2 8305

WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

2075

find out the second highest salary?

Cognizant, Nucsoft, Oracle, TCS, Wondersoft,

55 91489

find out first highest salary?

Verinon Technology Solutions,

10 16696

find out the third highest salary?

CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon,

92 154029

i want to know about mr.b.kotravel......who has answered for second maxmium salary from employee table

3 6264

we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.

Accenture,

2596

Un-Answered Questions { Oracle }

What is a system tablespace and why do we need it?

How do I become a dba?

628

What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?

1207

What are the variable types?

682

where the dff data will be stored

2545

What is pct free/pct used/pct increase parameter in segment? What is growth factor?

602

How to lock and unlock a user account in oracle?

1165

How many concurrent programs you have customized, can you name some of them?

What are database skills?

633

A developer is trying to create a view and the database won’t let him. He has the "developer" role which has the "create view" system privilege and select grants on the tables he is using, what is the problem?

719

How do I escape a reserved word in oracle?

1264

What is Tax Categories?

2162

How translate command is different from replace?

1144

Explain the importance of .pll extension in oracle?

1064

Mention what is split brain syndrome in rac?

For More Un-Answered { Oracle } Questions Click Here