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

Oracle General (1803)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

How to create a new view in oracle?

1132

How to insert a new row into a table in oracle?

1223

What is a database schema in oracle?

1157

What is open database communication (odbc) in oracle?

1055

How to drop an index in oracle?

1122

What is a read only transaction in oracle?

1084

How to insert multiple rows with one insert statement in oracle?

1138

How to connect ms access to oracle servers?

1061

How to delete all rows a table in oracle?

1119

What is a parameter file in oracle?

1197

Can the query output be sorted by multiple columns in oracle?

1062

Can group functions be used in the order by clause in oracle?

1051

What is a static data dictionary in oracle?

1197

How to assign a tablespace to a users in oracle?

1092

How to drop an existing table in oracle?

1107

Un-Answered Questions { Oracle }

What is a database schema in oracle?

1157

What is a directory object?

1142

What are the new features in release 11i?

How can I see all tables in oracle?

1063

What is the difference between PFILE and SPFILE in Oracle?

1115

What is literal?

1066

What is a snapshot log?

1054

When should you increase copy latches?

682

Give the different types of rollback segments.

1084

what is the difference between restoring and recovering?

1062

What do you understand by a database object?

1109

How to select some columns from a table in oracle?

1180

Have you attended the client meetings?

662

What is the best way to do multi-row insert in oracle?

1114

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1990

For More Un-Answered { Oracle } Questions Click Here