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 does dba stand for in technology?

542

What are the goals of dba?

550

What is dba software?

637

How many databases should a dba manage?

647

What is the dba role in oracle?

566

What does an oracle dba do?

595

What skills should a dba have?

570

What are roles in oracle?

565

What are the five functions of a database?

605

What are database skills?

581

How do I become an administrator?

579

How do I become a data manager?

523

What skills do you need to be a database administrator?

538

What are the five main functions of a database administrator?

611

How many types of database software are there?

582

Un-Answered Questions { Oracle }

what happened to the global index when I truncate the data in one of the partition?

2014

What is the difference between a primary key & a unique key?

1086

What is control file used for?

1196

What is the difference between substr & instr functions?

1219

How to define a variable of a specific record type?

1068

How index is implemented in oracle database?

1000

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

1015

6. Display the client name and order date for all orders using the traditional method.

2299

How to connect to a remote server?

1120

What are the major difference between truncate and delete?

1050

How many types of km's?

582

How to use "in out" parameter properly?

1044

How to pass a parameter to a cursor in oracle?

1172

How to establish administrator authentication to the server?

1034

i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

1940

For More Un-Answered { Oracle } Questions Click Here