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 tables for odbc connection testing?

1117

What is a named program unit?

1082

How to open a cursor variable?

1035

What happens to indexes if you drop a table?

1169

How to test null values?

1106

How to define a data source name (dsn) in odbc manager?

1030

How to do a full database export?

1108

How to bring a tablespace online?

1079

Can group functions be mixed with non-group selection fields?

1020

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

1134

How many file formats are supported to export data?

1220

Why cursor variables are easier to use than cursors?

1094

How to insert a record into a table?

1070

How to define a variable to match a table column data type?

988

How to invoke the original export import utilities?

1064

Un-Answered Questions { Oracle }

What is a nvl function?

1032

How many types of auditing in Oracle?

1035

How can you determine if the sqlnet process is running for sqlnet v1? How about v2?

571

How can be determining the size of the log files?

583

How to export your own schema?

1007

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

1059

How can we view last record added to a table?

1038

How to see free space of each tablespace?

1035

What is an oracle database?

1035

What are the execution control statements?

1063

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2275

Explain a synonym?

1028

How to rollback the current transaction in oracle?

1054

now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd

2297

What are the five main functions of a database administrator?

635

For More Un-Answered { Oracle } Questions Click Here