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

What view would you use to determine free space in a tablespace?

2222

How would you determine who has added a row to a table?

2310

How can you rebuild an index?

1 5240

You have just compiled a PL/SQL package but got errors, how would you view the errors?

1 5647

How can you gather statistics on a table?

3 8757

How can you enable a trace for a session?

2 6918

What is the difference between the SQL*Loader and IMPORT utilities?

1 5351

Name two files used for network connection to a database.

1 3305

What is an SQL FORMS ?

Verizon,

2783

What is the maximum size of a form ?

1 4327

Name the two files that are created when you generate the form give the filex extension ?

2 4587

How do you control the constraints in forms ?

1 4593

Commited block sometimes refer to a BASE TABLE ? True or False.

1 3625

Can we create two blocks with the same name in form 3.0 ?

1 5630

While specifying master/detail relationship between two blocks specifying the join condition is a must ? True or False.

2 5172

Un-Answered Questions { Oracle }

How many types of database software are there?

583

how to clone 9i Database on to 10g Database.

2334

What happens if recursive calls get out of control?

1072

How to retrieve values from data fields in record variables?

1109

How can we use tkprof?

What is not equal to in oracle?

995

Which process writes data from data files to database buffer cache?

605

how the indexes are stored in the Oracle Database?

2269

Explain an integrity constrains?

1139

What is an oracle table?

981

How to delete a column in an existing table in oracle?

1067

what is reindexing?

1665

Who is a database user?

538

What is an oracle database schema?

1117

What is translate in oracle?

1091

For More Un-Answered { Oracle } Questions Click Here