Oracle General Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General Interview Questions

Questions Answers Views Company eMail

Will you be able to store pictures in the database?

1121

Whether any commands are used for months calculation? If so, what are they?

1097

What is difference between truncate and delete?

1040

What are the benefits of ordbms?

1088

What is a oracle database?

1055

What are the various oracle database objects?

1144

Explain the characteristics of oracle dba?

1120

Explain integrity constraint?

1161

In which language oracle has been developed?

1073

Difference between varchar and varchar2 data types?

1184

What is hash cluster in oracle?

1174

What is the parameter mode that can be passed to a procedure?

1047

How many memory layers are in the oracle shared pool?

1181

What are nested tables?

1174

How do we get field detail of a table?

1080

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to delete all rows a table in oracle?

1068

What is a schema in oracle?

1012

Explain the use of indexes option in exp command.

1149

What are the various types of snapshots ?

1029

What privilege is needed for a user to create indexes in oracle?

1028

What is meant by recursive hints in oracle?

1086

How to create a table in a specific tablespace?

976

What is blob datatype?

1128

What is sharded cluster?

1015

How to assign a tablespace to a users in oracle?

1048

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

2008

What is a initialization parameter file in oracle?

1035

what are the advantages of running a database in archive log mode?

2203

What is SQL Tuning Advisor in Oracle?

1179

What to do if dba lost the system password?

1172

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