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

Oracle General Interview Questions

Questions Answers Views Company eMail

Explain the use of owner option in exp command.

1041

Explain integrity constraints?

1102

What do you mean by a deadlock?

1059

Will you be able to store pictures in the database?explain.

990

Explain the function of optimizer in oracle?

1139

What are the uses of synonyms?

1135

Explain the use of record option in exp command.

999

Explain the use of analyse option in exp command.

1124

List the types of joins used in writing subqueries?

992

What is meant by recursive hints in oracle?

1084

List out the components of logical database structure of oracle database.

1034

Explain the use of file option in exp command.

1127

material view and view disadvantages?

1064

How many types of tables supported by oracle?

1074

How to select some rows from a table in oracle?

1073

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to define a data field as not null?

1105

Why do we need integrity constraints in a database?

1017

How to change user password in oracle?

1024

Explain the use of show option in imp command.

1096

How to bring a tablespace online?

1073

How can we create the complete backup of data in the oracle.

2156

How to rollback the current transaction in oracle?

1050

How to write an inner join with the where clause in oracle?

1042

What is set verify off in oracle?

1096

Explain view?

1028

WHAT IS ecc 6.0

2147

What is the implicit cursor in oracle?

1102

What is a data lock in oracle?

1111

what are steps for interface? where is exchange rate defined in which table?

2152

What happens to the data files if a tablespace is dropped?

1059

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