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 do I become a database administrator?

572

What is the difference between internal & external schema?

757

Are database administrators in demand?

565

What are elements of administration?

596

What does a senior database administrator do?

608

What is da in database?

543

What skills do you need to be an administrator?

566

What is the most common database language that a db administrator needs to know?

575

What are the data management skills?

551

What are types of data model?

551

How long does it take to learn database administration?

557

Who is a database user?

545

What are the types of locks in database?

619

What is end user in database?

597

Why do we need a database?

595

Un-Answered Questions { Oracle }

What is the data pump import utility?

1035

How can we monitor the space allocations in a database?

How to divide query output into groups in oracle?

992

what is Single Byte Overhead...?

2555

System tablespace cant be exported from one database and imported into another why?

555

What is Journalization and why we are using in ODI?

571

What are the advantages of oracle?

1028

Is oracle dba in demand?

594

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2144

I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.

3331

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

1011

What is Restricted Mode of Instance Startup in Oracle?

1199

Name the different triggers supported by oracle reports and their firing order.

1086

What is the function of grid naming service used in oracle rac

How to invoke the original export import utilities?

1064

For More Un-Answered { Oracle } Questions Click Here