1. Categories >> Software >> Databases >> Oracle
  2. Suggest New Category


Oracle Interview Questions
Questions Answers Views Company eMail

what is primary key?

 9 10388

what is foreign key?

 5 6847

what is unique key?

Amazon, Cap Gemini, Infosys, Wipro,

14 22810

what is the difference between primary key & foreign key?

CTS, Infosys, La Multi, Sparsh, Wipro,

57 122257

What is index? How many types of indexes?

HCL,

2 10697

Can Multiple instances be run on Single Machine???

 3 4941

How to create LOV in Oracle forms?

Accenture, Polaris,

2 31955

Table 1: STUDIES PNAME (VARCHAR), SPLACE (VARCHAR), COURSE (VARCHAR), CCOST (NUMBER) Table 2: SOFTWARE PNAME (VARCHAR), TITLE (VARCHAR), DEVIN (VARCHAR), SCOST (NUMBER), DCOST (NUMBER), SOLD (NUMBER) Table 3: PROGRAMMER PNAME (VARCHAR), DOB (DATE), DOJ (DATE), SEX (CHAR), PROF1 (VARCHAR), PROF2 (VARCHAR), SAL (NUMBER) PNAME – Programmer Name, SPLACE – Study Place, CCOST – Course Cost, DEVIN – Language the software or package is developed in, SCOST – Software Cost, DCOST – Development Cost, PROF1 – Proficiency 1 Use the above table definitions to answer the questions that follow. Find out the selling cost average for packages developed in Oracle. Display the names, ages and experiences of all programmers How much revenue has been earned through

Azri Solutions,

1 5777

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)

eicc,

1805

pls explain connect by prior with example and its real time use

 3 13269

I would like to study certification course in Data base adminidtrator then where would i go to study this course?

 1727

which one is currently in used software cmpanies.

 1661

How cost of one Forms created & Report Created?

TCS,

1 3966

What is Index and different types of Indexes?

 7 34019

what is the bitmap index?

 3 5131

Un-Answered Questions { Oracle }

What is an Oracle Data Dictionary?

631

Why more redos are generated when the oracle database is in begin backup mode?

661

Can we call procedure inside function in oracle?

604

How to add a new column to an existing table with a default value?

542

What is an Oracle Instance?

685




What is user managed backup in Oracle?

610

How to get a list of all user accounts in the database?

613

What causes the "snapshot too old" error? How can this be prevented or mitigated?

253

What are joins, explain all types of joins?

1718

What is the Cdc?

380

What language does oracle use?

591

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

525

Why does Oracle not permit the use of PCTUSED with indexes?

1949

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

1485

What are record groups ?

1

For More Un-Answered { Oracle } Questions Click Here