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 are the roles of dba?

1068

Differentiate between pre-select and pre-query?

1106

What is save point in oracle database?

1296

What is hot backup and logical backup?

1051

What is the fastest query method to fetch data from the table?

1361

What do you mean by a tablespace?

1039

Explain the blob datatype?

1071

Explain rename?

980

List the various oracle database objects?

1057

Explain the use of show option in imp command.

1098

What suggestions do you have to reduce the network traffic?

961

Explain the use of grant option in imp command.

1030

Explain the dml?

981

Explain alias?

1150

Explain the use of constraints option in exp command.

1048

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

2310

How to use "if" statements on multiple conditions?

1174

How a tablespace is related to data files?

1109

What are the four Oracle system processes that must always be up and running for the database to be useable?

1017

Can we write insert statement in function in oracle?

1089

How to retrieve data from an explicit cursor?

1059

Explain a private synonyms?

1036

How to convert characters to times in oracle?

1023

How to connect ms access to oracle servers?

1006

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

2424

Explain user account with reference to oracle.

990

What to do if dba lost the system password?

1172

How do we get field detail of a table?

1079

What are the different types of partitions in oracle?

977

How to create a table index?

1151

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