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 is a junior dba?

571

What are the functions of administration?

506

Which database is best to learn?

523

What is main function of database administrator?

525

What are the different types of database users?

533

What does database administrator do?

512

What degree do database administrators need?

516

What is the main function of database?

560

What are the types of schemas?

539

Can we write insert statement in function in oracle?

1036

What is a package in oracle?

1038

What is pragma autonomous transaction in oracle?

1001

What is define in oracle?

1016

Can we write dml statement in function in oracle?

1033

What is a trigger oracle?

1045

Un-Answered Questions { Oracle }

How to create a server parameter file?

1087

how to remove the duplicate in odi?

583

what is the difference between functional dependecy and multilevel dependency?

2423

How can you tell if an index on particular table is used or not used in 9i?

533

Describe the types of sub query?

948

11. Display the client number and name and the client number and name of the person who referred that client.

2285

What is the use of lockboxes? Steps for lock box : oracle accounts receivable

1322

What is a table index?

1024

Is primary key indexed by default in oracle?

937

How to load a large xml file?

1009

What is the difference between bind and lexical parameter?

1019

Where in the Oracle directory tree structure are audit traces placed?

2581

Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??

1677

Name the three major set of files on disk that compose a database in Oracle?

1074

How can you merge two tables in oracle?

943

For More Un-Answered { Oracle } Questions Click Here