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

How to apply filtering criteria at group level in oracle?

1042

How to define and use table alias names in oracle?

943

What is the relation of a user account and a schema in oracle?

1080

How to start a new transaction in oracle?

1088

How to connect asp pages to oracle servers?

1072

How to create a new tablespace in oracle?

987

How oracle handles dead locks?

1066

How to convert characters to dates in oracle?

1100

How to create an oracle database manually?

1085

What is a procedure in oracle?

1197

How to create a stored function in oracle?

1105

How to use regular expression in pattern match conditions in oracle?

1041

How to rename a tablespace in oracle?

1086

How to create a new oracle data file?

1032

What is oracle database 10g express edition?

1118

Un-Answered Questions { Oracle }

I am getting error "no communication channel" after changing the domain name? What is the solution?

600

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1989

What is analyze command used for?

1072

How to convert raw data type into text in oracle? Explain

993

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

1090

what is the difference between substr and instr function in oracle?

1090

What is system global area (sga) in oracle?

991

What is translate in oracle?

1098

How to connect to a remote server?

1125

How do I know if oracle is installed on windows?

931

Explain the use of indexes option in imp command.

1179

What is transactional trigger property?

Explain self joins in oracle?

1019

What is the max number of columns in an oracle table?

999

what are the tools used for oracle 10g in real time.

2441

For More Un-Answered { Oracle } Questions Click Here