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 create a new view in oracle?

1078

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

1165

What is a database schema in oracle?

1110

What is open database communication (odbc) in oracle?

1003

How to drop an index in oracle?

1076

What is a read only transaction in oracle?

1029

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

1085

How to connect ms access to oracle servers?

1006

How to delete all rows a table in oracle?

1068

What is a parameter file in oracle?

1134

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

992

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

997

What is a static data dictionary in oracle?

1112

How to assign a tablespace to a users in oracle?

1048

How to drop an existing table in oracle?

1058

Un-Answered Questions { Oracle }

How to get the Installed Oracle Version Information ?

1125

What are the logical operations?

1125

What are the varoius components of physical database structure of oracle database?

1006

What are the types of schemas?

578

What are active transformation / passive transformations?

Explain what are the characteristics of data files?

1084

What is a dynamic performance view in oracle?

991

1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

1971

What is data type in oracle?

1125

What is the difference between truncate and delete? How would a full table scan behave after?

552

Why use resource manager in Oracle?

1104

What is J2EE Agent and port number?

614

Why do we need integrity constraints in a database?

1019

How to connect to the server with user account: sys?

1017

How to select some rows from a table in oracle?

1078

For More Un-Answered { Oracle } Questions Click Here